Checklist: DR Plan Sanity Check
If a disaster struck tomorrow, are you ready for it? Are you sure you thought of everything? I cannot count...
2017-09-04
503 reads
CISL 1.5.0 is released
I am glad to share that the 1.5.0 release of the CISL (Columnstore Indexes Scripts Library) is finally released.
The biggest...
2017-09-04
363 reads
Truncate vs Delete in SQL Server: What’s the Difference?
I’ve been using TRUNCATE TABLE to clear out some temporary tables in a database. It’s a very simple statement to...
2017-09-04
1,172 reads
HTTP 403 error – PowerShell Remoting, Different Domains and Proxies
On my day to day work I use Nagios monitoring software. I want to add some custom SQL Server scripts...
2017-09-04
1,827 reads
Kerberos Explained - Taming the Beast: Kerberos for the SQL Server DBA
David has a talk that he delivers at SQL Saturdays, all about Kerberos authentication. What it is, how it works...
2017-09-04
796 reads
Upcoming speaking events
Back in March I did my first “feature length” presentation at SQL Saturday Iceland
At that point I’d done a few...
2017-09-04
275 reads
DBCC CloneDatabase for SQL Server 2012
Dear All,In case you are wondering, title of the post is not a typo 🙂 DBCC CloneDatabase is going to be available for SQL Server 2012 :)For folks who...
2017-09-03
17 reads
DBCC CloneDatabase for SQL Server 2012
Dear All,In case you are wondering, title of the post is not a typo 🙂 DBCC CloneDatabase is going to be available for SQL Server 2012 :)For folks who...
2017-09-03
615 reads
DBCC CloneDatabase for SQL Server 2012
Dear All,
In case you are wondering, title of the post is not a typo 🙂 DBCC CloneDatabase is going to be...
2017-09-03
707 reads
Setting Up a Drillthrough Action in your Power BI Report
At some point this weekend, the Microsoft Power BI folks turned on the drill-through feature in the Power BI service....
2017-09-03
1,719 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
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
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...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers