I’ve Got A “SQLSat” In Kalamazoo
Last night I received an e-mail letting me know that I’ll be presenting at SQL Saturday #84 in Kalamazoo, MI. ...
2011-07-22
537 reads
Dynamically generate current Year, Month or Date member with MDX
MDX can be extended with Visual Basic functions like the FORMAT() and NOW() functions to dynamically generate the current year, month or...
2011-07-22
2,548 reads
Visual Studio vNext
“vNext” is the codename Microsoft has chosen for the next version of the Visual Studio.
A big feature is improving the application lifecycle management...
2011-07-22
728 reads
SQLSkills Immersion training in London
Just short of the winter solstice, I bailed out of a freezing cold Johannesburg for warmer climates; well, actually for...
2011-07-22
1,262 reads
Re-blog – July 15-July 21
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Oddly enough,...
2011-07-22
627 reads
SSRS: Dynamic Data Sources
I have been building dashboard using Reporting Services (SSRS) for a client of mine. The dashboard is going to be...
2011-07-22
7,964 reads
Bad Admins: Stealing the SQL Server Service Account
This is part of a series of tips on how bad/rogue admins can get access to the data in your...
2011-07-22
1,375 reads
Conditionally summing up values in a dataset in SSRS
Recently I had situation wherein I had to conditionally sum up a data set and display the value in a...
2011-07-22
18,001 reads
Partial name matching in SQL Server 2011 “Denali”
While playing with SQL Server 2011 “Denali”, I’ve accidentally found out that it has slightly enhanced intellisense in SSMS. There...
2011-07-21
1,390 reads
Cursor in sql server
Sometimes our application required a database object which allows manipulation of data from a set of rows on row by row basic...
2011-07-21
2,693 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