T-SQL Tuesday #40 Roundup: Files and Filegroups
Good day all, and happy T-SQL Tuesday #40! Yes, this event has officially hit middle age now. I fully expect...
2013-03-18
851 reads
Using Templates
Templates are one of those really handy tools that most DBAs I know of have either never heard of or...
2013-03-18
1,168 reads
Last Weeks Top “Reading” Links #24
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-03-18
634 reads
Star Trek and the Death of IT
GAAAAAAAHHHHH!!!!
I feel slightly better, but only slightly.
I started watching Star Trek: The Next Generation on Netflix just to unwind my...
2013-03-18
1,144 reads
SQL Server – Changing Default Database Location for Server
When you create a new database in SQL Server without explicitly specifying database file locations, SQL Server created files in...
2013-03-18
2,211 reads
.Net Code Camp Orlando 2013
This past Saturday March 16th, I had the opportunity to speak once again the .Net Orlando Code Camp. I presented...
2013-03-18
789 reads
PASS Data Arch VC presents Steve Hughes on Accounting for Windows Azure
I meet Steve this past November in Seattle at the PASS Summit. Reading his series on XMLA and Analysis Services...
2013-03-17
639 reads
SQL Server : Part 5 : Explaining Non clustered Index on Heap
In the last post, we have discussed about non clustered index on a clustered table.In this post we will discuss...
2013-03-17
7,821 reads
PowerShell Usage in DBA Work — Case Study 4/7
One common surprise I have encountered in almost all my DBA environments is that a sql job that usually runs...
2013-03-17
938 reads
Database Health and Performance at SQLSaturday Detroit
Today I had the pleasure of speaking at the inaugural SQL Saturday event in Detroit, MI. I spoke on one of my...
2013-03-16
620 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