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,149 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
732 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
960 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,067 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,453 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
697 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,373 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,298 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,699 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,561 reads
Blogs
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
dataMinds Saturday 2026 – Slides
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
Forums
AllocationType as ROW_OVERFLOW_DATA
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
is it true we cant debug c# scripts in ssis anymore under vs
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Question of the Day
Missing the Jaro Winkler Distance
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers