Query Store, Force Plan and “Better” Plans
I am endlessly fascinated by how the Query Store works. I love teaching it at every opportunity too. Plus, almost...
2016-09-12 (first published: 2016-09-06)
1,351 reads
Blog Posts
SQL Server Interview Questions And Answers
This is post going to be more like a list of question for self assessment. So I will not be...
2016-09-12
58 reads
SQL Server Interview Questions And Answers
This is post going to be more like a list of question for self assessment. So I will not be...
2016-09-12
245 reads
SQL Server 2016 In-Memory OLTP and After Trigger Support
SQL Server 2016 supports AFTER triggers! I could find no good example of how to do this with a project...
2016-09-12
759 reads
Top 5 SQL Server Books for the DBA
The Top 5 series has proved rather popular. My Top 5 books for Enterprise Architecture was the most popular post in...
2016-09-12 (first published: 2016-09-07)
2,546 reads
Pluralsight = Essential Training
Edit (11-Sep-2016) See comment that pricing tiers have been adjusted since this blog post
I've been aware of Pluralsight for a...
2016-09-11
207 reads
Pluralsight = Essential Training
Edit (11-Sep-2016) See comment that pricing tiers have been adjusted since this blog post I’ve been aware of Pluralsight for a couple of years and as I’m always looking...
2016-09-11
48 reads
SQLPort in Aveiro
Its not a big secret that Microsoft Data Platform community in Portugal has not stopped its expansion – we are trying...
2016-09-11
434 reads
Live! 360–Speaking at SQL Server Live Orlando 2016
If you are looking for a great conference to attend, please look at Live! 360. This event combines 6 different...
2016-09-10
609 reads
Archiving Azure SQL Database to a BACPAC
UPDATE: The other half of this scenario has been posted. Check out Importing a BACPAC to SQL Server.
Azure SQL...
2016-09-09 (first published: 2016-09-06)
5,244 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers