Updatable Subscriptions Removed in SQL Server 2012
After spending some time looking at SQL Server 2012 CTP3, it appears as if Transactional Publication with Updatable Subscriptions will...
2011-10-29
2,005 reads
Updatable Subscriptions Deprecated in SQL Server 2012
After spending some time looking at SQL Server 2012 CTP3, it appears as if Transactional Publication with Updatable Subscriptions will...
2011-10-29
4,040 reads
How to hide Calculated Members in MDX SSAS
With some calculated members in MDX it only makes sense to see the calculation if a certain Hierarchy is used....
2011-10-28
2,525 reads
PASS Summit 2001 In Review…WOW!!!
It has been a couple of weeks and I have had time to get back in the groove at a...
2011-10-28
1,704 reads
SQL Server Analysis Services Performance Guide published
Another must read white-paper: Analysis Services 2008 R2 Performance Guide.
This white paper describes how business intelligence developers can apply query...
2011-10-28
2,524 reads
Displaying blank sub report
Recently I had to convert a stand alone report into a sub-report. That report was very simple… it had two...
2011-10-28
1,045 reads
Play the Bob Ross Game
I was in a meeting a few weeks ago, deadlines looming and everyone feeling the stress some. We hit a...
2011-10-28
799 reads
Convert comma separated string to table and vice versa
I know that this subject has been blogged about numerous times but I thought I'd post an alternative way of...
2011-10-28
9,341 reads
I/O Error On TempDB
I was running a DBCC CHECKDB on a database when I got an error that says:
Msg 0, Level 11, State...
2011-10-28
1,980 reads
Webinar on SQL Server Security on November 3, 2011
I have the privilege of being able to give a webinar next Thursday, November 3, at 11 AM EDT. It...
2011-10-28
1,010 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