SQL Saturday #107 - Houston
Come to a free day of SQL Server training in Houston, TX on Apr 21, 2012.
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.
The On-call Demands
This Friday Steve Jones asks about your on-call responsibilities and the load you face from after hours calls. If you're a DBA that doesn't work strictly 9-5 every week, let us know.
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.
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.
Treat the Database like Code
Steve Jones reminds us that our databases contain code, and as such, they ought to be under some type of version control.
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.
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.
My Little Friend
Today Steve Jones talks about his favorite feature in SSMS 2012 and why everyone should use it.
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.
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers