Upgrade From SQL 2012 to SQL 2016 - Problem with Certificates
You may need to drop and recreate your certificates after migrating from SQL 2012 to SQL 2016+
2018-07-23
1,031 reads
Mike Good
Strange Filtered Index Problem
What I thought was a strange filtered index problem but turned out to be a DB settings problem
2018-05-11 (first published: 2015-08-26)
4,667 reads
A Simple Approach to SQL Server 2005 Encryption
SQL Server 2005 has added encryption capabilities to the platform, much to the delight of many DBAs. However setting up encryption can be confusing and difficult for most DBAs. New author Mike Good brings us a perspective from someone who is brand new to this set of features and has spent time working through the functions and documenting them for the rest of us.
2007-08-02
20,432 reads
Blogs
Trace Query in Extended Events
The ability to quickly and easily trace a query is important to database professionals....
Using Erik Darling’s sp_pressure_detector to resolve CPU issues
By DesertDBA
Last Friday I spent my lunch break going through some links I had marked...
How to Resolve Remove-AzKeyVaultKey : Operation returned an invalid status code ‘Forbidden’ Error
I’ve come across another error message in my seemingly never-ending battle with Azure Key...
Forums
How to import Excel with XML
Hi, I have an Excel sheet that I have to import into SQL Server....
Recursive CTE - Batches
Hi Folks I'm trying to group rows into batch and adding batch to query...
XQuery - Use column value to display correct node
Hi All First time with XQuery and despite trying to read as many guides...
Ask SSC