SQL Server – Understanding ‘Agent XPs’ Server Configuration Option
Today we got an escalation where on one of the servers ‘Agent XPs’ was in a disabled state. And when...
2012-09-19
432 reads
Lenovo–Three Strikes
Last Friday Lenovo told me my new laptop would ship this Monday, or “much much sooner”. Monday I called to...
2012-09-19
812 reads
SQL Server Quickie #3 – Allocation Units
Today I have uploaded my 3rd SQL Server Quickie to YouTube. In this episode I’m talking about Allocation Units in...
2012-09-18
613 reads
SQL Server Quickie #3 – Allocation Units
Today
I have uploaded my 3rd SQL Server Quickie to YouTube. In this episode I'm talking
about Allocation Units in SQL Server....
2012-09-18
1,589 reads
Max Text Replication Size – When you might have to care about this number !
One of the advanced Server level options for SQL Server is Max Text Replication Size and this is really not a common...
2012-09-24 (first published: 2012-09-18)
6,915 reads
24 Hours of PASS: Hosting Rod Colledge–BI in Sharepoint
The Virtual Chapters of PASS are asked to host sessions during this Fall’s 24 Hours of PASS preview for the...
2012-09-18
1,001 reads
SQL Server: Part 1 : Approaching Database Server Performance Issues
When you work as DBA, many people will approach you with a complaint like "Application is taking ages to load...
2012-09-18
1,415 reads
Funny results from OPTIMIZE FOR AD HOC WORKLOADS
I recently turned on OPTIMIZE FOR AD HOC WORKLOADS for the first time on one of my servers. When I...
2012-09-18
1,377 reads
SQL Saturday #149 and CodeMastery–Minnesota Events
We are less than two weeks away from SQL Saturday #149 in Minneapolis on September 29, 2012 with two preconference...
2012-09-18
529 reads
SQL in the City – US 2012 Tour
Last year I had the pleasure of speaking at two SQL in the City events: London and Los Angeles. It...
2012-09-18
1,391 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Trigger isn't working
Hi, I have a trigger, that works fine elsewhere but is not working at...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers