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,157 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
570 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
592 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
473 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
923 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
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
645 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
5,039 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
980 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
757 reads
Blogs
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Forums
how to write this query?
Hi everyone I asked this earlier but the desired outcome is a bit different...
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers