Omaha BI/SQL User Group – What?
I recently received an email from this guy named John Morehouse (blog | twitter) about the Omaha SQL/BI User Group Meeting in...
2014-05-07
772 reads
Blog Posts
Searching SSIS Packages or searching XML In General
Today I'm posting a small script with a simple purpose. I wanted to search all of my SSIS packages in...
2014-05-07
786 reads
Secure Coding
I was looking recently for some sort of guideline that would help me ensure that code was securely written. I...
2014-05-07
840 reads
Size Matters: 2 Products to Accelerate SQL Traffic
I talked previously about network pipelines and how to get the most out of a fat network in the post...
2014-05-07
1,186 reads
Speaking at SQLBits 2014: PreCon on In-Memory OLTP and Security session
Sprecher auf der SQLBits 2014 zu In-Memory OLTP und Sicherheit
(DE)
Nachdem ich letztes Jahr das erste Mal als Teilnehmer auf...
2014-05-07
844 reads
SQLSaturday #308 Houston, TX Saturday May 10th
This will be the second SQLSaturday in Houston I have spoken at and I am excited about talking Execution Plans...
2014-05-07
458 reads
What’s Happening at the PASS Business Analytics Conference?
Watch below for live updates during the conference Stay tuned and you’ll find out what’s going on during this week...
2014-05-07
456 reads
Datatypes In Your Mind–Question Of The Day
My latest question Datatypes In Your Mind is live today and it’s generated quite the discussion. I wrote here about...
2014-05-06
470 reads
Filetable–Moving files programmatically
I’ve been playing with Filetable and I was asked an interesting question. Can I move files to a folder programmatically?
It’s...
2014-05-06
1,827 reads
Using a Filtered Index to Enforce Filtered Uniqueness
One of the advantages and uses of Filtered Indexes (introduced with SQL Server 2008) is to provide filtered uniqueness. Obviously...
2014-05-06 (first published: 2014-04-24)
2,168 reads
Blogs
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...
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
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