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
2,861 reads
Mike Good
- Interests: NY Times crosswords, golfing, playing guitar
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)
5,206 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
21,425 reads
Blogs
Build a C++ Pipeline with Docker, GitHub Actions, Azure ACR and Azure App Service
In today’s Software Development Life Cycle (SDLC), having a robust build pipeline is very...
Better Trigger Design: #SQLNewBlogger
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
SQL Server in the Cloud – Are DBAs Still Needed?
By Kevin3NF
Things your cloud vendor may not tell you Here’s a common theme I...
Forums
Dropping a PK constraint.
I will have to test this next week, but will not have a chance...
SQL - Conditional merge join
I want to add a condition in the joining columns part of the merge...
Is there a way to implement ROWS between logic?
Hi everyone SUM function has the option to select ROWS BETWEEN parameter to allow...
Question of the Day
What is Between?
I have a table of products in SQL Server 2022. There are sequential items in the table with ProductIDs of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. If I run this code, how many rows are returned?
SELECT * FROM dbo.Products WHERE ProductID BETWEEN 4 AND 7;See possible answers