What perms does a user need to create a table variable?
This came up because a user had db_owner perms and it was only reading from a database and creating a table variable from it. I created a new user...
2021-04-05
27 reads
Get the schema of a temp table
I wanted to find out what data types SQL Server auditing was using, so I put the auditing file results into a temp table and executed tempdb..sp_help on that...
2021-04-04
1,013 reads
The production database just went down! What do I do?
A few of my colleagues can relate with the title of this article, they might have experienced an issue with the database in production. Dear colleague, you are not...
2021-04-09 (first published: 2021-04-03)
944 reads
Daily Coping 2 Apr 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-04-02
20 reads
The SQL Saturday Foundation Board of Directors
I’m pleased to announce that I have selected an initial board of directors for the SQL Saturday Foundation. I’m honored to be a part of this group: Andy Warren ...
2021-04-09 (first published: 2021-04-02)
253 reads
VMware Improves In-Guest Time Synchronization with 7.0 U1
I just found out that VMware has updated their in-guest time synchronization with the 7.0 Update 1 release. Previously, we had to manually disable some of the advanced time...
2021-04-08 (first published: 2021-04-01)
255 reads
Daily Coping 1 Apr 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-04-01
32 reads
Easy SSIS Package Compare
I’ve been asking for a way to compare SSIS packages for a long time, and finally Redgate has released an early access version. Years ago we had an internal...
2021-04-01
114 reads
Azure SQL – Saving Costs
When moving to a cloud model for your database stack no doubt you will be involved in a costing exercise. The good news is if you have Software Assurance...
2021-04-01
37 reads
Easy SSIS Package Compare
I’ve been asking for a way to compare SSIS packages for a long time, and finally Redgate has released an early access version. Years ago we had an internal version, but the visual comparison format was a problem. Really, we couldn’t decide how to actually compare packages on screen in a way that makes sense for users.
2021-04-01
919 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
does anyone used https://github.com/ktaranov/sqlserver-kit
Could you please let me know if anyone is used https://github.com/ktaranov/sqlserver-kit github for deployment...
How Can Database Performance Improve the Overall Website Experience?
I’ve been looking into ways to improve the connection between a website and its...
When And How to Automate?
Comments posted to this topic are about the item When And How to Automate?
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers