Where are my 32-bit Perfmon Counters?
I have run into this before, but not in this same way, so I decided it would be worth writing...
2014-05-05 (first published: 2014-04-23)
3,406 reads
Nebraska SQL from @DBA_ANDY
Why does my Failover Cluster Instance Keep Failing Back and Forth?
A few months ago I was paged by a client because their SQL Server Failover Cluster Instance (FCI) was experiencing...
2014-04-25 (first published: 2014-04-17)
8,097 reads
I Know I Shouldn't Shrink My Log file, BUT...
As a managed services DBA, I frequently have to clean up after other people's mistakes. (Come to think of it,...
2014-04-03
1,966 reads
We Are Hiring!
My employer Ntirety (a division of HOSTING) is currently looking for multiple SQL Server DBA's. As you have probably seen...
2014-03-31
1,218 reads
Backup Checksums and Trace Flag 3023
One of the items I always flag when performing a health check on a server is whether backups are being...
2014-03-28 (first published: 2014-03-25)
3,596 reads
Error 701 - Insufficient System Memory - Now what?
This story begins, as so many often do, with a few key elements:1) A client who experienced a problem on...
2014-03-26 (first published: 2014-03-20)
9,522 reads
A New Day at #Ntirety
We - the rank-and-file employees at Ntirety - received word yesterday that we had been acquired by Hosting, a cloud and network...
2014-03-18
581 reads
Why Did My Job Fail Anyway?
One of my biggest pet peeves when I check a new SQL Server for a client is the fact that...
2014-03-12
1,050 reads
Working From Home
I have been working 100% from home for almost four months now, and one of my former coworkers recently hit...
2014-02-22
524 reads
T-SQL Tuesday #051: Always Hedge Your Bets
It's time for T-SQL Tuesday again and this month's host is my former co-worker, the @SQLRNNR himself, Jason Brimhall. Jason's...
2014-02-11
715 reads
Blogs
SQL Server 2025 RegEx and AI
By Steve Jones
One of the language changes in SQL Server 2025 that I’ve seen a lot...
T-SQL Tuesday #192: SQL Server 2025 Backup Changes
By Steve Jones
I hosted this month, but I decided to put my own entry in as...
Why Databases Still Fascinate Me
By Chris Yates
I get asked a lot about why or how I began working with databases...
Forums
Getting the Object Code
Comments posted to this topic are about the item Getting the Object Code
T-SQL in SQL Server 2025: Concatenating Strings
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Being Mindful of Design Time
Comments posted to this topic are about the item Being Mindful of Design Time
Question of the Day
Getting the Object Code
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'dbo.uspGetBillofMaterials')) AS [Object Definition]; GOSee possible answers