PASS Update #63 (How Do We Rate)
A short update today, following up on an email to the Board from incoming VP of Finance Douglas McDowell who...
2011-08-25
793 reads
Building A New Storage Test Server
We’re Gonna Need A Bigger Boat
Not to sound too obvious, I test IO systems. That means from time to time...
2011-08-25
2,183 reads
Index Disabled and Index Rebuild
I received the following message from a Developer. The message was on a Test SQL Server
“NC_myIndex " on table "VeryLargeTable" (specified...
2011-08-25
1,808 reads
Reading SQL Error log
SQL Error log can be read from SQL Server's management studio. However, Management studio is too slow and definitely not...
2011-08-25
428 reads
SQLMCM Training – Day 17
Today Bob spoke about Auditing, SQLCLR, XML, and Spatial Data. Because I already know
these concepts very well, my study notes...
2011-08-25
679 reads
Learning Transactional Replication
I have been working on a new skill this week and that is implementing transactional replication. I am of course...
2011-08-24
704 reads
SQL Server – sp_help without arguments.
sp_help returns information about database objects and types.
@object_name argument is optional for sp_help. When executed without any argument it returns...
2011-08-24
2,503 reads
Interview with BI Expert Tim Mitchell
Tim Mitchell will be speaking at the SQLServerCentral.com track at SQL Server Connections, October 31-November 3, 2011, in Las Vegas,...
2011-08-24
795 reads
Microsoft Small Basic
This is a bit off-topic, but I wanted to mention a great tool for beginners to learn how to program. ...
2011-08-24
2,070 reads
Come Shake My Hand at PASS
Last year Andy Warren thought about trying to help first timer attendees at the PASS Summit with a little networking...
2011-08-24
1,746 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
A Worse Computer; A Better Car
Comments posted to this topic are about the item A Worse Computer; A Better...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers