DBCC Clonedatabase and Query Store
Cloning things is all the rage these days…..even Storm Troopers.
Anyway, by now, you probably have seen documentation on Query Store...
2018-06-04 (first published: 2018-05-25)
1,777 reads
You know everything about GROUP BY. Do you?
SQL is a stout language and SQL Server has so many features that it’s impossible to be an expert in...
2018-06-01 (first published: 2018-05-25)
5,851 reads
Day 25 Optimization
Locking is depends upon Isolation level and Storage Engine. MySQL uses table level locking (instead of page, row, or column...
2018-05-25
284 reads
Techorama 2018 Session Materials
Techorama 2018 is over, sadly enough. It was a great conference: lots of awesome speakers and sessions and very nicely...
2018-05-25
282 reads
Fix For Using Azure Active Directory and DacFX
Update:
Refer to this post instead
Hello!
One of the things I feel strongly about is that a build/release pipeline needs to be as complete as possible - that is all configuration...
2018-05-25
24 reads
Day 24 Replication Setup
Today we will discuss how setup a replication: Master – Slave Replication: Requirement: 2 (Linux) System (MasterServer and SlaveServer) MySQL Installed...
2018-05-24
297 reads
Query Predicates
Sometimes people speak “SQL” and expect you know all the terminology. In recent a conversation about query plans I was...
2018-05-24
1,059 reads
One Week to Music City Tech
Next week is Music City Tech, a three day conference consisting of Coding, Agile, and Data tracks, takes place in...
2018-05-24
727 reads
Power BI and Data Security – Audit Logs, Powershell, Power BI and @AngryAnalytics
The following has been reposted with permission from Steve Howard a.k.a. @AngryAnalytics. I have made some formatting changes but the...
2018-05-24
459 reads
Convert a Positive Number To a Negative In SQL With a Spot of Bitwise Logic
Now this is something that I’ve seen asked a few times and it’s always a question that gets a fair...
2018-05-24
2,572 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Trigger isn't working
Hi, I have a trigger, that works fine elsewhere but is not working at...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers