Some SQL Server 2005/2008 Monitoring Stored Procedures
Here is a collection of five stored procedures that are very useful for monitoring the overall health of a SQL...
2009-12-11
1,142 reads
Here is a collection of five stored procedures that are very useful for monitoring the overall health of a SQL...
2009-12-11
1,142 reads
Microsoft announced today that they are reorganizing and combining the existing Windows Server and Solutions Group and the Windows Azure...
2009-12-09
728 reads
“What’s wrong with the database?" or “I can’t connect to SQL Server” How many times have you heard phrases like...
2009-12-09
948 reads
Via Twitter, I stumbled upon a link to this newly updated pdf from Joseph Sack and David Ikeda who are...
2009-12-08
1,060 reads
Microsoft Learning has put up a new Microsoft Student Career Portal that gives advice and links to resources on how...
2009-12-07
1,448 reads
Endgadget recently had a post up about the Micron Real SSD C300 family of SATA 6Gbps SSDs that will be...
2009-12-04
690 reads
Pinal Dave had a helpful post a few days ago about how to setup and configure SQL Azure. You will...
2009-12-03
1,367 reads
One quick and dirty tool that I like to use to monitor I/O performance at the file level is Resource...
2009-12-01
2,256 reads
AnandTech IT has an interesting post up that looks at the roadmap for AMD in the server arena for 2010/2011....
2009-11-30
1,690 reads
I will be teaching ICT 4461 SQL Server with Lab starting Tuesday, January 5, 2010. This will be an on-campus...
2009-11-30
1,555 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