I’m a big fan of using queries based on the dynamic management view sys.dm_exec_query_stats to capture the most resource hungry...
2017-11-13 (first published: 2017-11-01)
5,184 reads
SQLCMD variables can be a useful way of having changeable parameters for your SQL scripts, allowing you to specify the...
2017-11-01
10,545 reads
External USB drives should be safely detached from Windows instead of just unplugging them from the computer. Most of us...
2017-11-01
395 reads
Whee! It’s the first day of the main SQL PASS Summit conference and I made it to the keynote early for the first time ever. The hype says we’re going...
2017-11-01
16 reads
I have a favourite new feature of SQL Server Management Studio 17.3 (SSMS), and that’s XE Profiler, which allows you to...
2017-11-01
496 reads
In this module you will learn how to use the Enlighten Stack Shuffle Custom Visual. The Enlighten Stack Shuffle is...
2017-11-14 (first published: 2017-11-01)
1,981 reads
I used to be on the fence regarding whether or not Automatic Tuning should be on as the default when...
2017-11-01
382 reads
It’s the first full day of the 2017 PASS Summit. As I write this, I am somewhere over the panhandle...
2017-11-01
330 reads
If you’ve never seen the movie “A Knights Tale” I recommend that you do. In the movie, the character William...
2017-11-01
143 reads
If you’ve never seen the movie “A Knights Tale” I recommend that you do. In the movie, the character William...
2017-11-01
363 reads
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Comments posted to this topic are about the item The New World Of AI...
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Security has long been a problem for me. Every time I think I understand...
What does this return on SQL Server 2025?
select bit_count(null)See possible answers