Red errors in the results pane
Most DBAs have seen those nice clear red errors in the results pane. And I’m sure most DBAs have noticed...
2012-12-27 (first published: 2012-12-19)
2,094 reads
Kenneth Fisher
Where is my backup?
We recently added responsibility for ~80 more servers to our team. This means that my team-mates and I are working...
2012-12-19 (first published: 2012-12-12)
2,028 reads
Generating multiple SQL statements from a query
Dynamic SQL is one of my favorite tools in the DBA toolbox. I’m big on automation and dynamic SQL can...
2012-12-17
1,136 reads
Logins vs Users
Logins are not Users. It’s a pretty easy concept but one that seems to give a lot of people problems....
2012-12-12 (first published: 2012-12-03)
3,659 reads
Copying Connection Managers in SSIS
Did you know you can copy and paste connection managers in SSIS? While I haven’t found this a huge benefit...
2012-12-10
1,546 reads
Creating an empty table from a SELECT statement
I’m in the middle of reading a good book on DMVs, “SQL Server DMVs in Action” http://www.manning.com/stirk by Ian W....
2012-11-30 (first published: 2012-11-26)
4,612 reads
CTEs beyond SELECT
The other day I was writing a query to pull some DMV information and I ended up using several CTEs...
2012-11-20
1,973 reads
Looping through multiple servers in SSIS Part 3
Over the last couple of weeks I’ve set up a SSIS package that will loop through a group of servers...
2012-11-15
2,799 reads
2012-11-15
2,046 reads
Looping through multiple servers in SSIS part 2
Last week I posted a quick example of looping through multiple servers using SSIS and being in a bit of...
2012-11-12 (first published: 2012-11-09)
2,777 reads
Blogs
SQL Training Black Friday Deals
By Brian Kelley
If you're looking for particular "Black Friday" deals, here is what I've seen advertised...
Dry-run xp_delete_file Before Actually Deleting Files?
By SQLPals
Dry-run xp_delete_file Before Actually Deleting Files? xp_delete_file doesn’t really have a...
Happy Thanksgiving! (USA Holiday)
By Brian Kelley
In the United States, today is Thanksgiving. The intent behind the holiday is to...
Forums
FinOps - the new name for performance tuning
Comments posted to this topic are about the item FinOps - the new name...
Which Object Definitions Are Available?
Comments posted to this topic are about the item Which Object Definitions Are Available?
What's Your Theme Music?
Comments posted to this topic are about the item What's Your Theme Music?
Question of the Day
Which Object Definitions Are Available?
For which of these object types can I get the code when I run the OBJECT_DEFINITION() function in SQL Server 2025? (choose 3)
See possible answers