Powershell to Script out SQL Server Objects using a CMS list
I’ve recently decided I’ve got to get with the times and started dabbling with Powershell. Up until now i’ve not...
2011-09-19
2,232 reads
Database Snapshot as a Reporting Solution – Some Realtime Issues and Answers
One of Our production database is used by lots of Reporting users. Mirroring is enabled on this database. But no one is...
2011-09-19
6,838 reads
Have end users who need an introduction to SQL Server book?
At the beginning of this year, my introductory text to SQL Server, appropriately titled Introduction to SQL Server, became available for sale....
2011-09-19
1,335 reads
Find the largest tables in a database (II)
I once wrote a post to find the largest tables in a database, and now after studying PowerShell, I feel...
2011-09-18
2,042 reads
Overcome update conflict in P2P replication
When we have Peer to Peer (P2P) replication in place on SQL Server 2008, probably we would see a conflict...
2011-09-18
1,774 reads
PASS First Timers Guide and Schedule
Hi there ho there everybody! I am now a Big SisterFearless Leader of a group of PASS Summit first timers!...
2011-09-17
777 reads
PASS First Timers Guide
Hi there ho there everybody! I am now a Big SisterFearless Leader of a group of PASS Summit first timers!...
2011-09-17
637 reads
Beyonders
It has been a looooong time since I wrote a little book review. It’s nice to take time out with a little fantasy to ease and please the brain....
2011-09-16
7 reads
Beyonders
It has been a looooong time since I wrote a little book review. It’s nice to take time out with...
2011-09-16
557 reads
Ways to save money on Microsoft Software
If you are a developer and are on your own, or working for a company that does not have an...
2011-09-16
958 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
Learn From History
Comments posted to this topic are about the item Learn From History
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...
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