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
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers