Recursive Common Table Expression
December 17th, 2011
Microsoft introduced the Common Table Expression (CTE) with the release of SQL Server 2005, so it has been around for..
Read More
Microsoft Baseline Security Analyzer
November 16th, 2011
Microsoft Baseline Security Analyzer 2.2 (MBSA) is a tool that provides a streamlined method of identifying any missing security updates..
Granting a SQL Service account permissions to create SPN’s
November 15th, 2011
When preparing for a SQL Server installation, whether that be for a Stand-alone Instance or a clustered Instance, using a..
SQL Server 2012 Licensing – How does it compare
November 7th, 2011
With the release of SQL Server 2012 sometime within the first 6 months of 2012, Microsoft released recently a data..
SQL Server 2012 Licensing
November 4th, 2011
With the announcement that Microsoft’s SQL Server code-name ‘Denali’ at SQL PASS 2011 to be known as SQL Server 2012,..
SQL PASS 2011 Day 3
October 23rd, 2011
Well we have reached the 3rd and final day of SQL PASS 2011. Once again the day starts off with..
SQL PASS 2011 Day 2
October 14th, 2011
Following on from yesterday the sessions once again had plenty to choose from with 19 DBA based sessions to choose..
SQL PASS 2011 Day 1
October 14th, 2011
Well yesterday was officially the first day of SQL PASS 2011 in Seattle Washington. The day started out with the..
SQL Server 2008 R2 SP1 CU5
October 9th, 2011
Microsoft has released Service Pack 1 Cumulative Update 5 for you to download as of 22 February 2012. The download..
Installing SQLScheduler
September 19th, 2011
Are you using a version of SQL Server Express 2005, 2008, 2008 R2? Well these editions do not have the..
SQL Server Compression Estimation
September 14th, 2011
Previously I blogged about the release of the Compression Estimation Tool available for download from CodePlex. To read more about..
I am a Microsoft Data Platform MVP as well as a Microsoft Certified Master working as the Principal Consultant here at SQL Masters Consulting. When I am not working with the SQL Server Stack I like to get away to the Snow and spend time Snowboarding.
Search
Recent Posts
Categories
AlwaysOn Availability Groups Arc Data Services Availability Groups Azure Azure Data Studio CosmosDB Data Database DevOPs Database Lifecycle Management DevOPs Disaster Recovery DLM General High Availability JSON Kerberos Performance Power BI Presentations Reporting Services Security Service Broker Service Packs SMC SQL SQL Server 2005 SQL Server 2008 SQL Server 2008 R2 SQL Server 2012 SQL Server 2014 SQL Server 2016 SQL Server 2017 SQL Server 2019 SQL Server 2022 SQLServer SQLServerCentral T-SQL T-SQL Tuesday TSQL Uncategorized