sql 2012

Sample Configurationfile.ini

Below is a sample configurationfile.ini which can be used for an unattended/automatic installation of SQL 2012/2014 This file is usually found here [for SQL 2012 installs]: C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log For 2014 Installations, change 110 to 120 in the above path. To generate this, run the GUI setup almost to the end, answering installation […]

Read More

Windows Server 2008 R2 – Disable UAC

Steps to disable UAC on Windows Server 2008 R2. In some situations, UAC hinders full functionality of some SQL Server components such as SSIS 2008/2012/2014 Click on Start button Control Panel User Accounts Change UAC Settings Slide down to Never notify Select OK Select Yes Restart Computer/Server  

Read More

Microsoft SSIS 2012 Data Import – WA State Corporation Data

Below are screenshots of SSIS – Microsoft SQL Server Integration Services 2012 importing data from Washington State Secretary of State Corporations public data file. Click here for the source link.   Below is the target table creation T-SQL code USE [CorpWA] GO /****** Object: Table [dbo].[Corporations] Script Date: 8/2/2013 12:16:57 AM ******/ SET ANSI_NULLS ON […]

Read More

Security Update for SQL Server 2012 RTM (KB2716442)

Security Update for SQL Server 2012 RTM (KB2716442) : “A security issue has been identified in the SQL Server 2012 RTM that could allow an attacker to compromise your system and gain control over it.” This will update your SQL 2012 instance from version number 10.0.2100 to 11.0.2218 as shown below: select @@VERSION ——output ——————————————————————————————- […]

Read More