Short Circuit Events
I introduced the importance about predicate order previously. I recommend either reading that article for the first time or reading...
2015-10-26
608 reads
Blog Posts
SQL Server – Columnstore Index creation error: A columnstore index cannot have INCLUDED columns
Hi friends, in my previous blog we learnt that sparse column cannot be part of columnstore index. In this blog...
2015-10-26
615 reads
SQL Server Database Source Control using VSO Git
For a while now, I have ensured that the source code of new projects that I have undertaken (in both...
2015-10-26
239 reads
Things You Need To Know about Nolock
Nolock is not the Satan, but no an angel too
Surfing the web you will find articles saying that Nolock is...
2015-10-26
487 reads
Too Big To Be Visible - SQL Server vs. Oracle data in SSRS reporting
[2015-Oct-20] A sourcing system failed to return correct results (returned value was a very high figure with double digit number...
2015-10-26 (first published: 2015-10-20)
2,281 reads
Be Cautious About Invoke-SqlCmd Bug
With PowerShell becoming more popular in daily DBA work, I’d like to mention one huge ugly bug I recently encountered...
2015-10-25
2,021 reads
Be Cautious About Invoke-SqlCmd Bug
With PowerShell becoming more popular in daily DBA work, I’d like to mention one huge ugly bug I recently encountered...
2015-10-25
363 reads
Hekaton Part 9: Things Hash Indexes can't do
Last few posts have explored hash indexes in depth. This one will deal with the limitations on Hash Indexes. What...
2015-10-25
406 reads
So Long Seattle and Thanks for all the Fish!
I’ve had some good times in the Seattle area. I’ve lived in the Seattle are since 1987 and graduated high...
2015-10-25
571 reads
Counting Events
This article will show how to implement an XEvent Session that employs the use of the event_counter target that is used for counting events. IN addition, you will be...
2015-10-23
10 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers