Code that writes code
Code that writes code it one of the best productivity tips I can give you. And no, I’m not talking...
2018-03-30
549 reads
The Journey Begins
Thanks for joining me! Target Audience. Database developers, designers and architects. Background. I am lazy efficient, at least am trying to...
2018-03-30
319 reads
Database Doing DevOps
DevOps. It’s one of the latest buzz words in many technical communities. Database Doing DevOps This phrase, however, is NOT...
2018-03-30
456 reads
YouTube Channel Update: March 30, 2018
Hey everyone!
Here’s the latest stuff on my new YouTube Channel. Please let me know if these videos are helpful. Also,...
2018-03-30
391 reads
Azure SQL Database – Automatic Index Tuning
Introduction: -
We live in an era of “Automation”. Planes run on auto pilot mode, cars will soon be auto driven, so why not have auto indexed databases? This article...
2018-03-30
22 reads
Azure SQL Database – Automatic Index Tuning
Introduction: -
We live in an era of “Automation”. Planes run on auto pilot mode, cars will soon be auto driven, so why not have auto indexed databases? This article...
2018-03-30
409 reads
SQL Script to find the database & their files details on a SQL Server
Sometimes we need a SQL Script which can gives the below information about the databases created on a SQL Server for house keeping purpose: -1) Database Name2) Database ID3)...
2018-03-30
14 reads
SQL Script to find the database & their files details on a SQL Server
Sometimes we need a SQL Script which can gives the below information about the databases created on a SQL Server...
2018-03-30
9,700 reads
Thursday Night at the PASS Summit
It’s early days for thinking about the Summit, but as I wrote the post for yesterday about not submitting I...
2018-03-30
458 reads
SQL Script: - How to find the database restoring history of SQL Server databases
Sometime we need to find out the history of database restoration to get the answers of following questions: -1) Do we need to restore the database again as there...
2018-03-30
16 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
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...
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