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,138 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
466 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
914 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,281 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,988 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
975 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
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...