SQLSaturday #39 Announced
SQLSaturday #39 will be held April 24, 2010 and is being coordinated by Melissa Demsak and others from the NJ...
2010-01-28
582 reads
Blog Posts
SQLSaturday #40 Announced
SQLSaturday #40 will be held July 31st, 2010 in Miramar, FL. This is the second annual SQLSaturday organized by Scott...
2010-01-28
608 reads
The Black Art of PowerShell V2 Version Numbers
Last week while helping someone in the SQLPSX forums having an issue importing modules I suspected they had a CTP...
2010-01-28
829 reads
The Little Stick
In the end, that was what made the difference. I was typing along one night on my spare Acer and...
2010-01-28
869 reads
The Predictioneer
I’m not sure how this book got on my radar, but it turned out to be fairly interesting. It’s written...
2010-01-28
812 reads
What the Exec?
I’ve been working with SQL Server for 10 years and have worked in production with versions 6.5 – 2005 and used...
2010-01-28
684 reads
Cleaning up sys.dm_exec_cached_plans
Following on from my previous post in which I noticed that SQLServer itself was artificially bloating sys.dm_exec_cached_plans, the next obvious...
2010-01-27
1,138 reads
Handling Escape Sequences in SSIS Expression String Literals
The SSIS expression language is a powerful tool for a developer that gives you one method of making a package...
2010-01-27
8,471 reads
Handling Escape Sequences in SSIS Expression String Literals
The SSIS expression language is a powerful tool for a developer that gives you one method of making a package...
2010-01-27
995 reads
Identity Values – Dropouts and Spaces
Identity values are very useful, but there can be misconceptions about the way in which they work. One of the...
2010-01-27
999 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