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,146 reads
Glenn Berry
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
566 reads
Cumulative Update 17 For SQL Server 2005 SP2
Microsoft has announced the release of CU17 for SQL Server 2005 SP2, which is Build 3356. The link to request...
2009-12-21
590 reads
Cumulative Update 7 For SQL Server 2005 SP3
Microsoft has announced the release of CU7 for SQL Server 2005 SP3, which is Build 4273. The link to request...
2009-12-21
468 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
915 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,285 reads
Webcast: SQL Server 2008 R2 Support for Up to 256 Logical Processors
If you are a low-level, bare-metal type of SQL Server geek, you will probably enjoy watching this 60 minute webcast...
2009-12-21
640 reads
How to Copy Query Results From SQL Server 2005/2008 into Excel
I often work with DBAs who need to copy the results of a T-SQL query from SQL Server Management Studio...
2009-12-17
4,998 reads
Updated SQL Server 2008 Diagnostic Queries
Here is the mid-December version of my diagnostic queries for SQL Server 2008. The idea here is to be able...
2009-12-16
977 reads
More Information about Intel Desktop CPU Roadmap
Endgadget has a post up about an upcoming 32nm Westmere family CPU called the Core i7-980X, which will have six...
2009-12-15
751 reads
Blogs
Sic Transit Gloria Community
When Covid took out the PASS organization, I had someone say to me, “Well,...
DATEADD Truncates the Number Parameter: #SQLNewBlogger
By Steve Jones
This was an interesting thing I saw in a Question of the Day submission....
Our SQL Server is Slow! What Do I Do First?
By Kevin3NF
Don’t Panic! It’s a vague but common complaint, frequently with no additional details. Before...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
SQL Server Maintenance Plan Feedback
Hi I set this up today. I wanted to get some feedback. I have...
More Supply Chain Attacks
Comments posted to this topic are about the item More Supply Chain Attacks
Question of the Day
Counting Bits IV
What do these two selects return?
SELECT BIT_COUNT (CAST (-1 as smallint)) , BIT_COUNT (CAST (-1 as bigint))See possible answers