SmartPaster
I recently discovered this great little free Visual Studio Add-in that allows pasting text as preformatted strings in VB or...
2012-02-02
820 reads
Case Sensitive searches in T-SQL
I just ran into an issue with one of my applications where a SQL statement had updated a status code...
2012-01-19
2,746 reads
Excel for the DBA, Part 1–The Basics
This will be a series of handy hints for people that know SQL and are frustrated by Excel. I am...
2011-12-06
2,115 reads
An Attempt to Make SSIS Package Deployment More Reasonable
Full disclosure: There might be a better way to do this. I am not aware of it.
Problems:
Maintaining multiple DB environments...
2011-11-03
1,468 reads
Save a step: Using Computed Columns in a Table Variable (or Temp Table)
One of the databases that I support reports all money values in both the local currency and US Dollars. Very...
2011-10-28
15,198 reads
Tobias Ternstrom’s Great Denali Preview
Tobias Ternstrom from Microsoft gave a great talk at Tech Ed regarding upcoming features of SQL Server Denali. His presentation...
2011-06-30
2,222 reads
The Recursive CTE
(Yet another boring org chart example – except this one has multiple roots)
One of my apps has a hierarchial org chart...
2011-05-18
1,702 reads
How to determine the current SSIS runtime environment
If you want to test if you’re currently debugging an SSIS package via BIDS/Visual Studio, or running normally via DTExec,...
2011-04-28
2,412 reads
Renumbering Rows in a Table Variable (or Table/Temp Table)
I was recently working on a data cleanup problem where I had to do lots of comparisons of one row...
2011-02-24
2,097 reads
Renumbering Rows in a Table Variable (or Table/Temp Table)
I was recently working on a data cleanup problem where I had to do lots of comparisons of one row...
2011-02-18
4,311 reads
Blogs
SQL Server instance metadata inventory with PowerShell and SMO
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
5 SQL Tricks Worth Remembering Before You Close the Laptop
Disclosure: this post may contain links to books as an affiliate link. If you...
Claude Context Window
By Arun Sirpal
Every Claude conversation has a context window. It is the total amount of text...
Forums
Celebrating 30 years of PostgreSQL, A Thank you message
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
provisioning sql server via VMware Cloud Foundation
Hello, has anyone here ever provisioned and actually used an MS SQL Server with...
No More Deadlocks
Comments posted to this topic are about the item No More Deadlocks
Question of the Day
No More Deadlocks
After detecting deadlocks in SQL Server 2025 and lowering the time threshold for detecting future issues, when does the Database Engine return to the 5s default interval?
See possible answers