Powershell + SMO Error Handling Tips
Allen White posted a helpful post on SMO error handling with Powershell. Actually the same concept equally applies to SMO...
2009-06-25
1,669 reads
Blog Posts
Better Know A SSIS Transform – The Sort Transform
This is part 2 of my 29 part series called Better Know A SSIS Transform. Hopefully you will find the...
2009-06-24
8,661 reads
Dell Mini – The Follow Up
Back in January I posted about purchasing a Dell Mini 9, wanting to see what how it worked and a...
2009-06-24
1,371 reads
SQL Server 2008 Encryption - Extensible Key Management
One of the new features with SQL Server 2008 is the addition of extensible key management, allowing hardware devices to...
2009-06-24
3,951 reads
What’s the Typical Resignation Notice Period for DBAs?
I was recently talking to a friend from the U.K about how much notice a DBA should give to their...
2009-06-24
2,007 reads
Why Do I Blog?
It's late, it's been a busy day, so why bother to spend 10 or 15 minutes at night jotting things...
2009-06-24
1,495 reads
Windows 7 Issues
I went to add a few things to the new Windows 7 desktop today, and of course I have installer...
2009-06-24
789 reads
Clear Ceases Operations
Saw this in email this morning, Clear has ceased operations after failing to negotiate with its senior creditor. I’ve written...
2009-06-23
624 reads
How to Identify Important Characteristics for a DBA Job Candidate
In the last year or so, there have been a lot of articles, blog entries,and forum posts on the kinds...
2009-06-23
3,051 reads
Paying for Content - SQL Server Knowledge
Someone asked me recently if I subscribed to any services to keep up with SQL Server content. Meaning did I...
2009-06-23
2,020 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