My first PowerShell Script to Move Folders
I just had my first encounter with having to write a PowerShell script. The request seemed pretty harmless when I...
2011-07-15
2,079 reads
SQL Server “Denali”: Installing SSAS Multidimensional vs Tabular Mode
As I play with the recently released CTP3 of SQL Server Denali, I wanted to point something out about installing SSAS, since...
2011-07-15
1,929 reads
Android Game: Slice-It
The eternal challenge with games, and free/cheap software in general, is knowing what’s out there, especially since you don’t always...
2011-07-15
665 reads
Re-blog – July 8-July 14
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-07-15
758 reads
Tracking table changes seamlessly with Change Data Capture (CDC)
I am going to describe quite forgotten feature in SQL Server 2008. It is Change Data Capture (CDC) – powerful feature...
2011-07-15
2,596 reads
SQL Saturday 89 Pre-Con
Why am I attending Kevin Kline’s pre-con on “Troubleshooting & Performance Tuning Microsoft SQL Server 2008 R2” at SQL Saturday #89...
2011-07-14
616 reads
How to move the TempDB Database
Note that TempDB is recreated every time SQL starts. Why is this important? It means we don’t have to move the...
2011-07-14
753 reads
SQL Server 2008 R2 Service Pack 1 Released
Microsoft has released the final build of SQL Server 2008 R2 SP1. It includes fixes from SQL Server 2008 R2 RTM Cumulative Updates 1 through...
2011-07-14
1,352 reads
Office Work
I have been working at home for over 8 years, sharing an office with my wife for most of that...
2011-07-14
1,748 reads
Profiled on SQLPeople
I’m late posting it, but I was featured on SQLPeople for June 27th. It’s a project Andy Leonard has going...
2011-07-14
528 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