How to Read the Results of SELECT @@VERSION in SQL Server
The simple query SELECT @@VERSION can quickly tell you quite a bit about a SQL Server installation (and the underlying...
2010-01-07
4,116 reads
Glenn Berry
Early Reviews of New Intel 32nm Desktop and Mobile CPUs
Well, now that the holidays are over and the Consumer Electronics Show (CES) is nearly upon us, we are starting...
2010-01-04
629 reads
Denver SQL Server User’s Group Meeting on January 21
The Denver SQL Server User’s Group will be having their January meeting on Thursday, January 21, 2010. The meeting will...
2010-01-03
342 reads
A Small Collection of I/O Specific DMV Queries
It is pretty common for large, busy SQL Server implementations to run into I/O pressure or bottlenecks, especially since many...
2009-12-30
4,223 reads
Windows ReadyBoost in Windows 7
Perhaps you heard of or actually tried Windows ReadyBoost in Windows Vista, and were (like me) disappointed with the results?...
2009-12-29
3,095 reads
Fun With DBCC FREEPROCCACHE
Nearly anytime you see the command DBCC FREEPROCCACHE mentioned in a blog post, magazine article or book, you get some...
2009-12-28
21,272 reads
How To Get a Count of SQL Connections BY IP Address
These queries (which work on both SQL Server 2005 and 2008) are very handy if you want to know who...
2009-12-28
5,156 reads
Should You Get a Netbook Computer?
On Monday, Intel officially announced the next generation Atom processors (aka Pineview) that are part of the new Pine Trail...
2009-12-23
570 reads
Two Tools For Discovering Hardware Information About Your Servers
One thing that I think is very important for a successful DBA to be aware of is their hardware environment. ...
2009-12-21
1,293 reads
Great Resource On SQL Server Wait Types
Microsoft's Bob Ward has updated his blog post about documenting SQL Server wait types, that came out of his work...
2009-12-21
922 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
FARE Labs Pvt Ltd is a reliable laboratory for evaluating cosmetics and personal
A well-known laboratory with NABL certification, FARE LABS Pvt Ltd, provides thorough testing and...
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...
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