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
957 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,637 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,354 reads
Blogs
How to get the Active Directory user password policy values
By SQLPals
Recently I have had to troubleshoot quite a bit of SQL login issues and...
How do you use PowerShell toc check if an active directory user locked out, disabled etc.?
By SQLPals
If your organization uses a password policy (there are very good odds these days...
DBA Myths: The system sessions are the ones with a session_id 50 or less
Anecdotally any session_id that’s 50 or less is going to be a system session...
Forums
Numeric and Decimal
Comments posted to this topic are about the item Numeric and Decimal, which is...
Monitor / Alert PII fields - Best 3rd party tool?
I have been tasked with finding a new tool for Database Activity Monitoring. We...
Trigger store procedure with a file in SQL Server
Hi, Will receive a JSON file from an application on to D drive D:\tmp...
Ask SSC