On the Eleventh Day…
Yesterday we had an introduction into setting up a virtual lab to help the DBA learn and test new technologies while improving his/her own skill set. Today we will...
2012-12-24
9 reads
On the Eleventh Day…
Yesterday we had an introduction into setting up a virtual lab to help the DBA learn and test new technologies...
2012-12-24
1,028 reads
Big Data And Hadoop Part 2
In my previous blog I have given more insight on Big Data and now we will take a closer look at...
2012-12-24
446 reads
SQL Server Database File Size and Free Space
(There is a more up to date version of this script here.
Hey folks, and welcome to my first proper blog post. One of the things that I like to...
2012-12-24
15 reads
How About a PASS Holiday Ornament?
One of the simpler pleasures in life is having an idea and putting it up for discussion. Not all ideas...
2012-12-23
904 reads
Generate MERGE Statements for Your Tables
Today I’ll show you a special script which will let you “take a snapshot” of your table’s data, and apply...
2012-12-23
1,568 reads
How to drop all tables in a SQL Server Database whose name begins with a common value
Scenario
I have discovered from working on projects that sometimes you may have to make use of temporary or staging tables...
2012-12-23
2,732 reads
What Is Your Mindset?
Steve Jones sent me a link to this post about Intelligence vs Effort months ago, since then I’ve looked at...
2012-12-22
791 reads
On the Tenth Day…
Silver and Gold have a way of really bringing the look and feel of the Christmas season. Silver and Gold also seem to represent something of greater value. We...
2012-12-22
7 reads
On the Tenth Day…
Silver and Gold have a way of really bringing the look and feel of the Christmas season.
Silver and Gold also...
2012-12-22
1,260 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