All Mac users should do this immediately
This post is a public service announcement for all users of macOS High Sierra (10.13). (Note: Apple has already released...
2017-12-06
547 reads
Restrict the usage of a SQL Server Authenticated Application Id
SQL Server login ids may not be the most secure thing in the world but they are likely to be...
2017-12-18 (first published: 2017-12-06)
1,724 reads
Overview of Encryption Tools in SQL Server
More and more people are considering some level of encryption against their data stored in SQL Server. In many cases...
2017-12-14 (first published: 2017-12-05)
4,249 reads
Design, Deploy, and Optimize SQL Server on VMware
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-12-05
659 reads
More Beginner / Fundamentals Content
Not surprisingly, there are folks who want beginner / fundamentals presentations and blog posts.
I put up the poll based on a...
2017-12-22 (first published: 2017-12-05)
1,898 reads
SQL Prompt Gets Even Better
SQL Prompt v9 came out recently, and just when you thought they couldn’t make it better, they found a way....
2017-12-05
857 reads
New version of sp_WhoIsActive (v11.20) is available – Deployed on 123 instances in less than 1 minute
Last night, I received Adam Machanic's (b | t) newsletter "Announcing sp_whoisactive v11.20: Live Query Plans". For those who don't know...
2017-12-15 (first published: 2017-12-05)
2,493 reads
Azure SQL Database – Using sp_BlitzIndex
I was doing some normal activities on one of my Azure SQL Databases, I went to make a cup of...
2017-12-14 (first published: 2017-12-05)
1,702 reads
How to use Statistics IO to Improve Your Query Performance
SQL Server’s STATISTICS IO reporting is a great tool to help you performance tune queries.Usually the goal of performance tuning...
2017-12-05
3,494 reads
How to use Statistics IO to Improve Your Query Performance
SQL Server's STATISTICS IO reporting is a great tool to help you performance tune queries.
Usually the goal of performance tuning is to make your query run faster. One of...
2017-12-05
64 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers