How Many Objects Can Own Pages in a Mixed Extent
I saw an exchange on Twitter this past weekend on the #sqlhelp hash tag about how pages are allocated for...
2015-09-14
662 reads
Robert Davis
- Interests: Poker, computers, reading/writing horror fiction
Oklahoma City User Group Presentation Files
Earlier this week, I got the opportunity to present online for the Oklahoma City SQL Server User Group on SQL...
2015-07-15
722 reads
Error Creating Remote Distributor When Creating a Local Distributor
Recently, I was working on a Peer-to-peer replication automation project. When I switched from my local test servers to some...
2015-04-16
753 reads
T-SQL Tuesday #65 – Overcoming Variable Limitations in SQLCmd Mode
It’s time again for that T-SQL blog party T-SQL Tuesday, and this month’s host is Mike Donnelly (blog|@SQLMD). If you...
2015-04-14
701 reads
Patching Master Data Services
I recently installed my first deployment of Master Data Services (MDS). I installed the SQL Server 2014 (Enterprise Edition) MDS...
2015-04-13
842 reads
Performance Counters: Why It Depends
When you’re working through some vague performance issues (e.g., “SQL Server seems slow today”), one of the common things to...
2014-08-18
1,255 reads
Speaking at SQL PASS Summit 2014
I am honored to be selected to deliver 2 sessions at the SQL PASS Summit 2014. I will be delivering...
2014-06-29
1,321 reads
Size Matters: 2 Products to Accelerate SQL Traffic
I talked previously about network pipelines and how to get the most out of a fat network in the post...
2014-05-07
1,187 reads
Why is Your SQL Server Slow? All-for-one and One-for-all
I have one more thing I want to talk about regarding the conversation I had recently with my friends and...
2014-02-14
1,115 reads
Why is Your SQL Server Slow? Here’s a Hint
I was talking recently with my friends and former colleagues at Idera about the things that slow down SQL Server....
2014-02-11
1,087 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
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