SQL Server 2005 - Hacking password Encryption
Part 2 of this article discusses how to hack/de-cipher the data that has been encrypted by passphrase.
2008-01-10
4,751 reads
Articles
A Little Variety - MP3
Do we really need to corner the market for our particular business? Steve Jones talks about the need to grow your business at the expense of others.
2008-01-09
578 reads
A Little Variety - WMV
Do we really need to corner the market for our particular business? Steve Jones talks about the need to grow your business at the expense of others.
2008-01-09
336 reads
Basic SQL Server security principles you can't afford to miss
Learn how using basic SQL Server security practices of least privilege, delegated administration and separation of duties will protect SQL Server databases.
2008-01-09
3,806 reads
Myths - iPod
Every profession has its share of myths about how it works. IT might have more than its share and Steve Jones comments on a few of them.
2008-01-09
49 reads
Myths - MP3
Every profession has its share of myths about how it works. IT might have more than its share and Steve Jones comments on a few of them.
2008-01-09
583 reads
Myths - WMV
Every profession has its share of myths about how it works. IT might have more than its share and Steve Jones comments on a few of them.
2008-01-09
52 reads
Test Data Generation with Data Dude
The Visual Studio 2005 Team Edition for Database Professionals (a.k.a Data Dude) was released somewhere around December 2006 helping many Database Administrators and Database Developers. The release was huge for us, because it addresses many issues faced by us.
2008-01-09
3,641 reads
The Backup Myth - WMV
Running backups is enough for disaster recovery, right? That's a myth that could get you into trouble. Steve Jones explains there's more that's needed.
2008-01-09
305 reads
First Look: SQL Server 2005 SP2 CTP
Service Pack 2 for SQL Server 2005 is not quite here, but Wayne Fillis brings us a look at what you can expect if you install the CTP version that is available now.
2008-01-08 (first published: 2007-01-09)
11,451 reads
Blogs
Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python
Most apps that call an LLM send every request to the same model. That...
Advice I Like: Responsibility
By Steve Jones
“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...
Power BI Performance in 2026: A Practical Guide to Faster Semantic Models and Reports
By James Serra
Originally published April 2022; substantially updated July 2026. This post is a complete replacement...
Forums
Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL
Hello everyone , I am planning to migrate a database from SQL Server 2014...
SQL Agent Job Automated Change Capture Process
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Another Model, More Data Loss
Comments posted to this topic are about the item Another Model, More Data Loss
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers