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
830 reads
New York City .NET
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,871 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,129 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,482 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,207 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,233 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,731 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,423 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,348 reads
Creating a deep hierarchy with FOR XML
I have two tables in an application that I support. One is called [Report], and the other is [ReportParameter].
--SAMPLE...
2011-01-27
19,198 reads
Blogs
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Why companies use Palantir and how we help implement it in the Czech Republic
Palantir is an American software platform that brings together business data from different sources...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Packing and Decoding Device Status Codes with LEFT_SHIFT() and RIGHT_SHIFT() in SQL Server
Comments posted to this topic are about the item Packing and Decoding Device Status...
SQL Server Audit Failures
Comments posted to this topic are about the item SQL Server Audit Failures
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers