Pass 2015 – First Impressions
It’s Pass 2015 this week and I’m attending (seriously I’m unbelievably chuffed)! As they’ll be a shedload of blogs about...
2015-10-27
511 reads
Blog Posts
Pass 2015 – First Impressions
It’s Pass 2015 this week and I’m attending (seriously I’m unbelievably chuffed)! As they’ll be a shedload of blogs about...
2015-10-27
295 reads
SQL New Blogger Challenge: Looking back… and a new challenge!
A little over six months ago, I suggested the SQL New Blogger Challenge. I thought that maybe a few people...
2015-10-27
452 reads
Using Extended Events to Detect Connection Pooling
What is connection pooling? Lets start with a definition from MSDN.
Connecting to a data source can be time consuming. To...
2015-10-27 (first published: 2015-10-20)
5,183 reads
Extended Events Intro
Extended Events is supposed to be taking over for most of Profiler and server-side tracing functionality, but there were people...
2015-10-26
1,600 reads
Finding and keeping your #SQLPassion
I consider myself lucky. I fell into a job that I truly enjoy, something that I do for fun even...
2015-10-26
491 reads
Networking Tonight at the YardHouse in Seattle
I’m heading over to the Yardhouse (4th and Pike) as soon as SQL in the City is finished and should...
2015-10-26
560 reads
Networking Tonight at the YardHouse in Seattle
I’m heading over to the Yardhouse (4th and Pike) as soon as SQL in the City is finished and should...
2015-10-26
406 reads
Of clustered indexes and ordering
There is a particularly irritating and persistent belief that indexes (usually it’s the clustered that gets picked on) are always...
2015-10-26 (first published: 2015-10-20)
2,830 reads
Short Circuit Events
The predicate order is critical. Having the wrong order can result in not trapping the desired events. I cover the critical nature of predicates in the aforementioned article. At...
2015-10-26
8 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