Removing a secondary replica database in Always On SQL Environment
Removing a database from an Always On availability group is pretty straight forward and can be accomplished by either ssms...
2018-06-19
133 reads
SQLSat Houston This Weekend!
The wife and I are making the road trip this weekend to SQLSat Houston and we're both speaking!This SQLSaturday Houston is going to be great - looking forward to...
2018-06-19
14 reads
Verify Allocation Unit Size for SQL Server
Why Do I Care? Everything in SQL Server is stored on disk in 8K pages. The Microsoft recommended best practice...
2018-06-19
83 reads
Verify Allocation Unit Size for SQL Server
Why Do I Care? Everything in SQL Server is stored on disk in 8K pages. The Microsoft recommended best practice...
2018-06-19
705 reads
South Florida Vacation Notes
I extended my trip to SQLSaturday South Florida for a couple days vacation. If I’m going to drive 3-1/2 hours...
2018-06-19
336 reads
Installing SSDT for Visual Studio 2017
I had SSDT for VS 2017 installed some time ago, but due to some issues I had to uninstall it....
2018-06-19
3,937 reads
Join Elimination: When SQL Server Removes Unnecessary Tables
In this post and video at SQLPerformance.com, I discuss what join elimination is and how it works in SQL Server. ...
2018-06-19
642 reads
Join Elimination: When SQL Server Removes Unnecessary Tables
In this post and video at SQLPerformance.com, I discuss what join elimination is and how it works in SQL Server. Join elimination is one of the many techniques that...
2018-06-19
10 reads
Join Elimination: When SQL Server Removes Unnecessary Tables
In this post and video at SQLPerformance.com, I discuss what join elimination is and how it works in SQL Server. Join elimination is one of the many techniques that...
2018-06-19
18 reads
SQL Server 2017 – SELECT INTO [A SPECIFIC FILEGROUP]
Forget about Adaptive Query Processing for a minute, what other feature have I been waiting for? SELECT INTO a specific...
2018-06-19
586 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