Statistics IO parser in Ruby & Python
Here I am working on tuning a rather large stored procedure; old school. I have statistics IO and showplan turned on....
2011-06-10
669 reads
Stored procedures vs. Do-It-At-Application-Layer-At-All-Costs
Many years back when ASP 2.0 (not ASP.NET) was used as primary server language for web application on Microsoft platform,...
2011-06-10
764 reads
Easier way to view SQL Server job history
Ever get a timeout error when using the “View History” for a SQL Server Agent job? I find this happens...
2011-06-10
4,388 reads
Microsoft TechDays 2011 in Kosova, Prishtina
It's late but I need to say some words about our local tech event, it is the only one that...
2011-06-10
1,998 reads
Book Review: Make the Impossible Possible: One Man”s Crusade to Inspire Others to Dream Bigger and Achieve the Extraordinary
I finished reading Make the Impossible Possible: One Man”s Crusade to Inspire Others to Dream Bigger and Achieve the Extraordinary...
2011-06-10
795 reads
Re-blog – June 3-June 9
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-06-10
553 reads
How Query execute
*This is my Opinion Whenever you execute any query…. Everything will be on Memory unless data is not available from...
2011-06-10
480 reads
June Meeting - Data Architecture VC
June Meeting - Data Architecture VC
Data Architecture VC presents Karen López:
Subject:You've Just Inherited a Data Model: Now What?Start Time:Thursday, June 16,...
2011-06-10
697 reads
Slides & samples from my DevConnections sessions
As announced in both of my SQL Server sessions at DevConnections in Karlsruhe/Germany
you can find here the slides & samples for...
2011-06-10
902 reads
Database Table Documentation with a Data Dictionary
Why table and column documentation is useful and some SQL for setting up the data dictionary tables.
At Boston Public Schools,...
2011-06-10
1,933 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