SQLSaturday #85 is Tomorrow!
It’s 7am on Friday and I can’t wait for the day to end, head home to change and then go...
2011-09-23
606 reads
PASS 2011 Countdown – 3 Weeks To Go
Another week down and there are now 3-weeks until this year’s PASS Summit. Take a moment and register now if...
2011-09-23
677 reads
Performance Monitor Counters for SQL Server performance testing
I posted “Window Perfmon scripting, SQL Server perfmon and how to perfmon” which refers to a performance monitor counters.
The perfmon counters...
2011-09-23
3,435 reads
This field is missing from the returned result set from the data source.
This warning
The dataset ‘dataset1' contains a definition for the Field ‘column1'. This field is missing from the returned result set...
2011-09-23
8,387 reads
CU 16 for SQL Server 2008 SP1
Microsoft has recently released a Cumulative Update (CU) # 16 for SQL Server 2008 SP1 which contains hotfixes which were resolved...
2011-09-23
454 reads
Using Unary Operators to control Analysis Services hierarchy aggregations
Analysis Services hierarchy aggregations can be easily controlled using unary operators. For example, in accounting there are GL accounts that...
2011-09-23
2,250 reads
SSIS version in SQL Server
Integration Services is the management interface for SSIS packages. SQL Server uses the “MsDtsSrvr.exe” for executing packages
To highlight the point,...
2011-09-22
1,078 reads
Miss 24 Hours of PASS ? No problem, all videos are online
All the videos for the sessions at 24 Hours of PASS are available for free. Check the session schedule for...
2011-09-22
565 reads
Replacing a SQL Cursor with SSIS
On a forum post recently the questions was asked how to replace a cursor with an SSIS package. This can...
2011-09-22
1,374 reads
SQLSaturday #85 - Orlando, Florida - September 24, 2011
Fortunately, SQLSaturday#85 stands in a class by itself - it's the only SQLSaturday scheduled this upcoming weekend in sunny Orlando, Florida.
Home...
2011-09-22
1,214 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