Rename an Analysis Services Instance
This is just a short post for Friday. I have been working a fair amount with SSAS and the rest...
2012-01-20
5,599 reads
Blog Posts
S3OLV – Jan 2012 Meeting Recap
Last week (Jan 12, 2012), we held the user group meeting for the SQL Server Society of Las Vegas (a.k.a S3OLV or SSSOLV). Presenting at that meeting was Josh...
2012-01-20
17 reads
S3OLV – Jan 2012 Meeting Recap
Last week (Jan 12, 2012), we held the user group meeting for the SQL Server Society of Las Vegas (a.k.a...
2012-01-20
644 reads
SQL Cachestore flush
For each cleared cachestore in the plan cache SQL Server reports a message in the error logs , such as :
SQL...
2012-01-20
1,186 reads
The top 5 reasons to speak at SQL Rally
Have you been thinking about speaking at the upcoming SQL Rally in Dallas? If so, remember that the deadline for...
2012-01-20
751 reads
Unlimited Vacation
Unlimited Vacation sounds good, and maybe it works, but I wonder how much vacation people really take at Red Frog....
2012-01-20 (first published: 2012-01-12)
2,299 reads
Case Sensitive searches in T-SQL
I just ran into an issue with one of my applications where a SQL statement had updated a status code...
2012-01-19
2,864 reads
Dedicated Administrator Connection
Recently you may have read my article about some hidden functions in SQL Server. In that article you learned that those functions were in some DMOs and that you...
2012-01-19
11 reads
Dedicated Administrator Connection
Recently you may have read my article about some hidden functions in SQL Server. In that article you learned that...
2012-01-19
985 reads
How to let non-admin business users run replication agent jobs
This blog post is basic in nature but highlights a very real requirement that may arise when administering replication. Occasionally...
2012-01-19 (first published: 2012-01-13)
2,121 reads
Blogs
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
Forums
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Stairway to DAX and Power BI - Level 29: The DAX Combine & Aggregate Functions
Comments posted to this topic are about the item Stairway to DAX and Power...
AI Is Improving Security
Comments posted to this topic are about the item AI Is Improving Security
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers