SQL Server Wait Type Repository
Microsoft’s Bob Ward has a good post up on the CSS SQL Server Engineers blog about an upcoming web page...
2009-11-08
1,341 reads
Glenn Berry
Worldwide Operating System Market Share for October 2009
Ars Technica has a good post up showing that Windows 7, (which has been out for two weeks) has already...
2009-11-07
1,455 reads
SQL Server 2008 R2 Running on “Big Iron”
During the opening keynote on Tuesday at the PASS Summit in Seattle, Microsoft’s Bob Muglia showed a demonstration of a...
2009-11-05
1,169 reads
New Pricing and Editions For SQL Server 2008 R2
Mary-Jo Foley recently posted about some announcements about SQL Server 2008 R2 out of the PASS Summit. There will be...
2009-11-05
1,028 reads
Day 1 At SQL PASS in Seattle
Today was my big, somewhat stressful day at the PASS summit in Seattle. I gave two, 75-minute Community session presentations,...
2009-11-04
1,441 reads
SQL Server 2008 Diagnostic Information Queries
Here is the script that I used in my Dr. DMV presentation this afternoon at PASS. It is a set...
2009-11-04
1,649 reads
Basic iFTS Monitoring Queries
This is one of the scripts that I will be using for my presentation “Tips and Tricks for Using SQL...
2009-11-03
1,482 reads
Minor Setup Issue with SQL Server 2008 or SQL Server 2008 R2 on Windows 7
Microsoft’s Peter Saddow, who is a Program Manager on the SQL Server Setup team has a post in the SQL...
2009-11-02
427 reads
Two Very Important Configuration Settings For SQL Server 2005/2008
Two settings that I always enable when I install SQL Server 2005 or 2008 on an x64 production database server...
2009-11-01
5,911 reads
Suggested Max Memory Settings for SQL Server 2005/2008
It is pretty important to make sure you set the Max Server memory setting for SQL Server 2005/2008 to something...
2009-10-29
253,683 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers