TSQL TestBits function for rapidly testing multiple switch settings
Are multiple binary switches becoming hard to manage? The TestBits function can help with that.
2012-04-09
4,226 reads
Articles
SQL Saturday #107 - Houston
Come to a free day of SQL Server training in Houston, TX on Apr 21, 2012.
2012-04-09
1,737 reads
Verify SQL Server Stored Procedures are the same on multiple servers
I have a stored procedure I push down to all of my servers that does a custom backup job and I want to make sure all servers have the same stored procedure. Is there some way to check without going to each server and reviewing the stored procedure? Check out this to find out.
2012-04-09
4,522 reads
Bin Packing Problems: The SQL
The 'bin packing' problem isn't just a fascination for computer scientists, but comes up in a whole range of real-world applications. It isn't that easy to come up with a practical, set oriented solution in SQL that gives a near-optimal result.
2012-04-06
2,537 reads
CLR Integration in SQL
Learn how to build a CLR function that can be used to perform string manipulations that might be rather complex in T-SQL.
2012-04-05
8,158 reads
A Few Cool Things You Can Identify Using the Default Trace
If you are running an instance of SQL Server 2005 and above then most likely that instance is running the default trace. This default trace is a canned Profiler server side trace that automatically starts up when SQL Server starts. In this article Greg Larsen explains more about the default trace and shows you how to glean some event information from the trace files created by this background trace process.
2012-04-05
3,916 reads
Basics of XML and SQL Server, Part 5: Generate/Transmit XML with SSIS
This SSIS package generates XML invoice documents from data stored in SQL Server, then FTPs and/or Emails them to clients.
2012-04-04
6,839 reads
Red Gate Software’s SQL Monitor 3.0 gives users the power of custom metrics
Red Gate Software has released Version 3.0 of SQL Monitor, a performance monitoring and alerting tool.
2012-04-04
998 reads
SQL Saturday #111 - Atlanta
A free day of SQL Server training in Atlanta, GA on Apr 14, 2012. Sign up today if you will be in the area.
2012-04-04
1,511 reads
Using Friendly Names for SQL Servers via DNS
Wouldn't it be great if your HR folks only had to put in HR-SQL.mydomain.com for the database connection in their reports? They wouldn't have to remember it was on server Nile and they certainly wouldn't have to change their reports if you migrated their database from the Nile server to the server named Danube. In DNS there are two easy ways to do this.
2012-04-04
3,036 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers