Upcoming Speaking Events
I will be the inaugural speaker for the Northern Colorado Database Professionals on September 17, in Loveland, CO. I will...
2012-08-28
2,022 reads
Blog Posts
At Startup SSMS setting
I came across this handy dandy little setting earlier this year. It was well hidden from me, by which I...
2012-08-27
664 reads
Create a SQL Server Reporting Services (SSRS) Catalog Report in 15 Minutes
One big question I have gotten often is “I need data, what kind of reports do you have?” It is...
2012-08-27
471 reads
Five Applicants for the PASS Board
If you haven’t reviewed the list, head to the PASS Election Page. One incumbent, two appointees, one previous candidate, and...
2012-08-27
568 reads
Parallel Data Warehouse (PDW) How-To: Avoid ShuffleMove and PartitionMove Operations
There are a couple process hungry operations that can be avoided when developing or migrating T-SQL queries into Microsoft’s Parallel Data Warehouse (PDW) environment. With proper planning and attention to...
2012-08-27
88 reads
Parallel Data Warehouse (PDW) How-To: Avoid ShuffleMove and PartitionMove Operations
There are a couple process hungry operations that can be avoided when developing or migrating T-SQL queries into Microsoft’s Parallel Data...
2012-08-27
3,898 reads
PASS Election Season
Did you know that it’s election season for PASS? Did you know that you can pose questions to the potential...
2012-08-27
619 reads
Re-Using Phone Numbers at the Office
I’ve been with my current client for just over a year and I still get calls for the previous occupant...
2012-08-27
702 reads
SQL Saturday 125 OKC
This weekend I traveled three hours north to Oklahoma City to participate in SQL Saturday 125, the second annual event...
2012-08-27
399 reads
SQL Saturday 125 OKC
This weekend I traveled three hours north to Oklahoma City to participate in SQL Saturday 125, the second annual event...
2012-08-27
822 reads
Blogs
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Monday Monitor Tips: The MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
Forums
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Finding Bad Queries
Comments posted to this topic are about the item Finding Bad Queries