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,161 reads
Glenn Berry
Microsoft Creates Server and Cloud Division
Microsoft announced today that they are reorganizing and combining the existing Windows Server and Solutions Group and the Windows Azure...
2009-12-09
739 reads
Old DBA Trick To Confirm SQL Server Connectivity
“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
975 reads
Microsoft Certified Master: SQL Server 2008 Pre-reading List
Via Twitter, I stumbled upon a link to this newly updated pdf from Joseph Sack and David Ikeda who are...
2009-12-08
1,077 reads
Microsoft Student Career Portal
Microsoft Learning has put up a new Microsoft Student Career Portal that gives advice and links to resources on how...
2009-12-07
1,469 reads
Micron Real SSD C300
Endgadget recently had a post up about the Micron Real SSD C300 family of SATA 6Gbps SSDs that will be...
2009-12-04
711 reads
Fun With SQL Azure
Pinal Dave had a helpful post a few days ago about how to setup and configure SQL Azure. You will...
2009-12-03
1,381 reads
Using Resource Monitor In Windows Server 2008 to Look at I/O Performance for SQL Server 2008
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,312 reads
More News About AMD’s 2010/2011 Server Roadmap
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,711 reads
Teaching SQL Server 2008 Class at University of Denver – University College
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,569 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers