Daily Coping 29 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-29
42 reads
Blog Posts
Removing a Deleted Column from a Data Masker Masking Set
Data Masker for SQL Server is a great tool ensuring the data you use in non-production environments is compliant with any regulations by obfuscating and changing sensitive data. This...
2021-09-29 (first published: 2021-09-20)
202 reads
System-versioned ledger tables: the next step
In the first post of this series, we learned about a new type of system-versioned table that also works at the database level and introduces a mechanism that demonstrates...
2021-09-29
63 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
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
#PowershellBasics: Running a .sql script file.
As with all programming tasks there are a number of ways to do something, this is just one that I ... Continue reading
2021-09-27 (first published: 2021-09-16)
557 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
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
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...