They Took Our Name!!
I’ve heard imitation is a form of flattery, and I guess that’s true. Today I got an up close and...
2010-02-05
375 reads
Blog Posts
Detecting and Troubleshooting Non-Yielding Worker Threads in SQL Server 2005/2008
I had a little bit of excitement with one of my production servers couple of days ago, that I thought...
2010-02-04
3,084 reads
February Question: What is one of your best practices for making full backups and transactions log backups of your production databases?
Post your responses to the above SQL Aloha Question of the Month in the comments section below (at www.bradmcgehee.com if...
2010-02-04
575 reads
I think it’s a hole
The other day I was trying to help someone that had removed the BUILTIN/Administrators logins from their instance without first...
2010-02-04
817 reads
oPASS Meeting Reminder – February 9, 2010
Our next meeting is February 9, 2010, We’ve got Ronald Dameron coming to speak this month on Database Hardening using...
2010-02-04
325 reads
PASS Update #23
January has been a slow month for me as far as PASS involvement, I show about 10 hours logged for...
2010-02-04
446 reads
Searching for Objects or Text Strings Using SQL Search
As a DBA, at one time or another, you will need to quickly find an object within a database, such...
2010-02-04
4,262 reads
SQL Server Default Trace
The default trace in SQL Server is something I have been experimenting with lately. It is a feature included in...
2010-02-04
3,870 reads
SQLSaturday #42 Announced!
Dave Schutz will be leading the first ever SQLSaturday in Columbus, OH on June 5, 2010 at the Fawcett Center...
2010-02-04
333 reads
SSIS Alpha Splits using the CODEPOINT() Function
A relatively common requirement in ETL processing is to break records into disparate outputs based on an alphabetical split on...
2010-02-04
4,408 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers