Apology
I’ve been somewhat light in my blogging of late. Unfortunately, I just haven’t hit any interesting or difficult problems lately...
2009-12-22
532 reads
SSIS - Single Package Deployment from BIDs
I have read several articles about deploying SSIS packages.Most focus on using the deployment wizard or simply copying the files...
2009-12-22
2,055 reads
Getting Your Blog Started
I realized that I haven’t written enough recently on this blog myself, being occupied with other projects for work. Recently...
2009-12-22
744 reads
Sql Server- Difference between Stored Procedure and Function
In Sql Server, both functions and stored procedures can be defined as the logically grouping of Sql statements formed to...
2009-12-22
2,180 reads
The Exceptional DBA’s Code of Conduct
This is a reprint of chapter 11 of my book, How to Become an Exceptional DBA, 2nd Edition, which is...
2009-12-21
732 reads
Give Your Employees Business Cards
I was reminded of this again recently during a class when the students exchanged cards and one student didn’t have...
2009-12-21
626 reads
A Busy/Accidental DBA’s Guide to Managing VLFs
Introduction
Properly managing VLFs can make or break the performance of your databases. There is a ton of information out there...
2009-12-21
875 reads
Two Tools For Discovering Hardware Information About Your Servers
One thing that I think is very important for a successful DBA to be aware of is their hardware environment. ...
2009-12-21
1,299 reads
Great Resource On SQL Server Wait Types
Microsoft's Bob Ward has updated his blog post about documenting SQL Server wait types, that came out of his work...
2009-12-21
926 reads
Webcast: SQL Server 2008 R2 Support for Up to 256 Logical Processors
If you are a low-level, bare-metal type of SQL Server geek, you will probably enjoy watching this 60 minute webcast...
2009-12-21
655 reads
Blogs
Monday Monitor Tips: The MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Forums
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Finding Bad Queries
Comments posted to this topic are about the item Finding Bad Queries