Don’t Make Dumb Mistakes by Duplicating Indexes
Just today, I was reviewing the indexing of a database used by a third-party application. As part of my review,...
2009-04-15
2,424 reads
Blog Posts
Full Text Catalog Scripting "Gotcha" in SSMS 2008
With every new version of SQL Server comes a set of deprecated features. Usually Microsoft gives fair warning that these...
2009-04-15
582 reads
Last Call for Speakers for SQLSaturday #7 in Birmingham on May 30
I just had a call with John Baldwin who is leading the effort in Birmingham and there plenty of action...
2009-04-15
303 reads
Learn How to Use the SQL Server 2008 Transact-SQL Debugger
Bill Ramos, a SQL Server Product Manager, has written a three part series on how to use the SQL Server...
2009-04-15
856 reads
Microsoft Releases Updated White Paper on Troubleshooting SQL Server 2008 Performance
Microsoft has finally updated their classis Troubleshooting SQL Server Performance white paper for SQL Server 2008, which is available at:
Troubleshooting...
2009-04-15
1,244 reads
Portland, OR Code Camp Set for May 30, 2009
The Portland Code Camp will be held at Reed College on Saturday, May 30, 2009. This free event will include...
2009-04-15
419 reads
Pragmatic Works Foundation Class
This week I've been extremely busy working on the new Pragmatic Works Foundation class, which is the brainchild of Brian...
2009-04-15
704 reads
Richmond, VA Code Camp to be Held April 25
The Richmond Code Camp 2009.1, will be held on Saturday 25, 2009 at the J. Sargeant Reynolds Community College in...
2009-04-15
636 reads
Starting Conversations - Part 2
A week or so ago I posted a note about reading How to Start a Conversation and Make Friends (worth...
2009-04-15
380 reads
Tax Day
A reminder of one of the downsides of working is today: Tax Day. In the US, income tax filing is...
2009-04-15
866 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