Category Archives : #SQLServer

21

Mar

Quickblog:How to install an MSI file unattended
Quickblog:How to install an MSI file unattended

How to install an MSI file unattended MSIEXEC /a “product.msi” /qn Example: MSIEXEC /a “d:\downloads\ssdt.msi)” /qn Typically this installation will not show any user interaction or verbose logging. Combine with the Full MSI Syntax options as listed below to output READ MORE

20

Mar

Installing SQL Server Data Tools BI (and unattended install)

  About SQL Server Data Tools If you are anywhere involved with Microsoft Business Intelligence using Analysis Services, SQL Reporting Services or even SSIS you need to have SQL Server Data Tools for Business Intelligence installed. Now most people would READ MORE

17

Mar

QuickBlog: Upgrading SQL Server
QuickBlog: Upgrading SQL Server

The end of SQL Server 2005 extended support is nearing on April 12, 2016. To accomplish a smooth and trouble-free upgrade to SQL Server 2014, you should plan for upgrade and address the complexity of upgrade for your applications. As READ MORE

28

Feb

Reblog: SQLServer Firewall Configuration using command line

REBLOG from old ILIKESQL BLOG SQL Server Firewall Configuration using command line I’ve been asked the question many times, and you probably have seen it before … The “warning” message that displays during a SQL Server installation and warns you READ MORE

23

Feb

Migrating from #sqlserver to #Azure SQL Database – Cookbook

The Azure SQL Server Migration Cookbook for Azure SQL Database describes how you can migrate an on-premises SQL Server Database to Azure and can be downloaded here. The cookbook describes engine compatibility, tools to use and how to approach migration READ MORE