(last updated: 2019-04-22 @ 13:00 EST / 2019-04-22 @ 17:00 UTC ) SQL Server 2012 introduced a significant improvement to CREATE CERTIFICATE: the ability to import a certificate —…
Coming up in just a couple of weeks, I’ll be presenting my session, Power BI Governance 101, at SQL Saturday #820 in Jacksonville, Florida on May 4th. The event…
SQL Server needs to make sure data types match when performing operations that involve multiple pieces of data. When the data types do not match, SQL Server has to…
My default setup for a few years is to only use named instances, usually with a standard SQL2014 or SQL 2016 as the name of the instance. Recently, I…
In my last post I showed how to build an Azure DevOps Pipeline for a Terraform build of an Azure SQLDB. This will take the terraform code and build…
One part of my job is to understand the compliance landscape. This means that I read a lot about the GDPR and related similar laws. I also have to…
Database recovery (crash recovery) is a nerve wrenching situation under the wrong conditions. It can be as bad as a root canal and just as necessary to endure that…
Yes, I realize you shouldn’t shrink your database (data files or log files), but I recently had a case where … Continue reading
This is part of a series of posts that look at the changes to the SQLServerCentral design, bringing us to v3 of the site. You can see the other…
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance…
By Brian Kelley
My certification came in! I’m now accredited to provide training for the Certified Information...
By Bert Wagner
Correlated subqueries provide an intuitive syntax for writing queries that return related data. However,...
By Arun Sirpal
A quick 2 minute upload (with sound, my voice) showing you how easy it...
Comments posted to this topic are about the item Can Azure Stack Reduce Software...
Hello, I have data from an Orders table has the following columns; OrderId (int)...
Ask SSC