Get SQL Server Training in the UK
Kalen Delaney has a series on internals and performance taking place in Hertfordshire soon. If you register today, you can still save 20%
SQL errors and other failures fixed from the trenches
Solve your SQL Server error, problem or installation failure with this advice. Learn how to fix SQL performance errors and suspect data recovery problems.
SQL Server Sanity: Maintain Healthy Transaction Logs for Easy Data Recovery
Learn how executing frequent backups and maintaining healthy transaction logs in SQL Server leads to quick recovery. Failing to do so can mean having to re-enter a lot of data.
Enough - Database Weekly (Oct. 20, 2008)
The loss of data is getting ridiculous. Steve Jones wants companies and government to do something about it.
Who Wants to Be Rich?
With all the concern over the economy lately, Steve Jones talks about about finances and tries to bring perspective to those of us in the real world.
Who Wants to Be Rich?
With all the concern over the economy lately, Steve Jones talks about about finances and tries to bring perspective to those of us in the real world.
SQL Server 2000 Useful Undocumented Stored Procedures
In this article, Alexander Chigrik looks at some useful undocumented stored procedures that shipped with SQL Server 2000.
The Financial Crisis
With the economy slowing the the world facing a financial crisis, Steve Jones polls the man on the street this Friday.
Who was that Affinity Masked Man?
Getting the number of processor cores that SQL Server is using is not as straitforward as it could be. Enter the affinity mask, bitwise operations and good old fashioned computer science.
Enough - Database Weekly (Oct. 20, 2008)
The loss of data is getting ridiculous. Steve Jones wants companies and government to do something about it.
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