SQLSaturday Orlando 2021 – September Update
Just over 30 days until SQLSaturday Orlando and I’m using some vacation time today to catch up on event tasks. That’s deliberate on my part, I knew I was...
2021-09-28
7 reads
SQLSaturday Orlando 2021 – September Update
Just over 30 days until SQLSaturday Orlando and I’m using some vacation time today to catch up on event tasks. That’s deliberate on my part, I knew I was...
2021-09-28
71 reads
Audit Columns
One of the easiest ways to collect information about table activity is to add a series of audit columns to ... Continue reading
2021-10-11 (first published: 2021-09-28)
514 reads
Daily Coping 28 Sep 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-09-28
30 reads
Book Review: Lights Out
I have always been interested in GE since I was a kid. My best friend in high school had a parent that worked for the company for a bit...
2021-09-27
48 reads
A Successful Blogger on Making the Switch
For Kyla Marie Charles, switching to WordPress.com opened up possibilities for her website and brand that she never thought was possible.
2021-09-27
46 reads
Login Timeouts
I was recently approached at work about a company that was seeing tons of timeouts in SQL Server. I was asked how to troubleshoot this. There are lots of...
2021-09-27
7 reads
Login Timeouts
I was recently approached at work about a company that was seeing tons of timeouts in SQL Server. I was asked how to troubleshoot this. There are lots of...
2021-10-06 (first published: 2021-09-27)
580 reads
Wednesday Webinar with Pavilion – SQL Server Performance
I’m thrilled to announce a new webinar with Pavilion Data for this Wednesday, September 29, 2021, at 10:00am Pacific time entitled “Achieve 3x SQL Server Performance While Doubling VM...
2021-09-27
106 reads
Daily Coping 27 Sep 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-09-27
45 reads
Blogs
How I Troubleshoot a Slow SQL Server Live
No two SQL Server environments are alike. A fix that resolves a performance issue...
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Monday Monitor Tips: The MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Forums
Test topic for spam filtering
A new thread for testing the spam filter. Adding a link: https://www.bbc.co.uk/weather
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...