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
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
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
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
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
Microsoft's Bob Ward has updated his blog post about documenting SQL Server wait types, that came out of his work...
2009-12-21
913 reads
One thing that I think is very important for a successful DBA to be aware of is their hardware environment. ...
2009-12-21
1,280 reads
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
639 reads
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,987 reads
Here is the mid-December version of my diagnostic queries for SQL Server 2008. The idea here is to be able...
2009-12-16
974 reads
Endgadget has a post up about an upcoming 32nm Westmere family CPU called the Core i7-980X, which will have six...
2009-12-15
750 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Comments posted to this topic are about the item New SQL Server 2022 Functions
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers