What I mess up whenever I install SQL Server on a new VM
These two things stop me in my tracks whenever I try to install SQL Server on a new VM.
Monthly Archive: July 2015
Prepare for an Upgrade with the SQL Server 2016 Upgrade Advisor
Tip : Prepare for an Upgrade with the SQL Server 2016 Upgrade Advisor
I have an aversion to @@VERSION
I suggest a different approach to providing more data about service packs and cumulative updates than messing with @@VERSION.
SQL Server 2012 Service Pack 2 Cumulative Update #7
Microsoft has released Cumulative Update #7 for SQL Server 2012 Service Pack 2. This update has 38 fixes, including the QFE security fix from MS15-058. If you've installed MS15-058 (either the QFE – 11.0.5613...
Vulnerability Affecting All Supported Versions of SQL Server
Well, it's that time again: Patch Tuesday. SQL Server hasn't had a security update since August, but today we're giving the hotfix download servers a run for their money. Both GDR and QFE fixes...
T-SQL Tuesday #68 : All Features With Defaults
I look at the tempting All Features With Defaults installation choice for this T-SQL Tuesday.
Use Dynamic Data Masking in SQL Server 2016 CTP 2.1
Tip : Use Dynamic Data Masking in SQL Server 2016 CTP 2.1