Local Community Events & User Groups from Around Town....
Staying true to the meaning of SQL Community with respect to local chapters and user groups, I wanted to bring you...
2012-01-20
1,585 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
The Hockey Team to Represent a Truly Bilingual City: Let’s Give Cunneyworth The Proper Chance He Deserves to Lead the Canadiens to a Stanley Cup Someday as Al McNeil Did in 1971
The Media in Quebec has opened up 2012 with a continuation of what it wishes to disseminate, or more probably,...
2012-01-19
3,095 reads
Introducing “X on XMLA”
XMLA or XML for Analysis is used in SQL Server Analysis Services and other multidimensional data systems to manage the...
2012-01-19
549 reads
RECONFIGURE can flush the procedure cache
I ran across this KB article the other day, which lists a few ways in which performance is affected by...
2012-01-24 (first published: 2012-01-19)
2,203 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,859 reads
SSRS Tip: Hide a tablix if no rows returned
I have a tablix in an SSRS report, populated by a query that might or might not return any rows. ...
2012-01-19
2,202 reads
Session Code – Extending Reporting Services with Custom Code
This is my wish list of things I’d like to cover in todays session at 11 AM EST https://www1.gotomeeting.com/register/935071481 but...
2012-01-19
3,533 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
Blogs
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...
How to Measure AI Value: A 6-Branch AI Maturity Model for Use Cases and Agents
Your AI is busy. But do you know what it's worth? Most companies can...
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