Get Some Cross Training Today
There's an IT skills gap in many companies, which is forcing managers to get creative. Steve Jones says now is the time to look for some cross training at work.
TSQL TestBits function for rapidly testing multiple switch settings
Are multiple binary switches becoming hard to manage? The TestBits function can help with that.
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.
Blogs
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers