Save a step: Using Computed Columns in a Table Variable (or Temp Table)
One of the databases that I support reports all money values in both the local currency and US Dollars. Very...
2011-10-28
15,201 reads
Understanding Kerberos, Part III
Welcome back to both our Kerberos coverage and to another topic for SQL University's Security and Auditing Week. In today's...
2011-10-28
16,599 reads
A Thought on Career Decisions
One of the many conversations I had at the PASS Summit was about whether to pursue Direction A or Direction...
2011-10-28
644 reads
Refresh QA Database with Manual Scripts
Couple of week back Megha Sharma send me an email with a document attached, this document is all about how...
2011-10-27
704 reads
Presenting at SQL Saturday #87
On Saturday, October 29, 2011 at 2:45 pm, I’ll be presenting “Table Vars and Temp Tables – What you NEED to...
2011-10-27
702 reads
SQL University: SQL Agent Jobs That Run at SQL Agent Start
Welcome to Security week at SQL University. I apologize for the late start. However, if you want to do some...
2011-10-27
2,959 reads
Buckets for Disaster Recovery
Disaster recovery can be a huge project at any company. Considering the ways in which you build a plan that...
2011-10-26
1,339 reads
Dimensional Modeling Financial Data in SSAS
Part 1 – Parent Child Hierarchies and Pseudo GL Accounts
This post is born out of some real life lessons that I...
2011-10-26
5,530 reads
Watch those VARCHAR(MAX) columns, and ONLINE index rebuilds
G’day,
I’ve noted a few instances lately of cases where VARCHAR(MAX) columns have been used unnecessarily, when a small value (for a...
2011-10-26
14,437 reads
Miss TechEd Australia 2011? No problem, all videos are online
As you may know, the TechEd in the U.S. is not the only one. There have been many all over the...
2011-10-26
857 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