Joining the Friends of Redgate program 🎉
I’m super excited to announce that today I was notified that I will be joining the Friends of Redgate program! 🎉💃🎊
Articles by Andy
MS SQL Express 2016 on Amazon AWS: I Can Take Database Offline but Can’t Bring It Online
Question I can take databases offline (via GUI) but can’t bring them back online. The server details are as follow: RDBMS: MS SQL 2016 Express Host: Amazon AWS/RDS Free Tier Details/History of the Problem A few months ago, I created a db instance on Amazon … [Read More]
How to store real-time data to database
Question Here is my situation: I have a WebSocket connection that feeds me data real-time I have an async callback function that gets the data and inserts into a queue I have another thread that reads from the queue and stores it into the Postgres … [Read More]
Is it possible for master, tempdb, model and msdb to have a database_id other than 1,2,3,4 respectively?
Question SQL Server System Databases, as far as I know, always have those same IDs and I have seen lots of maintenance scripts on the internet relying on the predicate WHERE database_id > 4 to exclude them from the actions of the script. Also, if … [Read More]
Fastest way to shrink LOB data in SQL Server
Question We have a database of total size of 3886 GB. Out of which 778 GB is free. So total 3108 GB worth of data is present. Out of which 2458 GB is “LOB Data” and 400 GB is worth “Regular”. Since the database is … [Read More]
Job waiting on CXCONSUMER
Question We have got a procedure on SQL Server agent jobs and this job started to hang on transaction for many hours with wait stats CXCONSUMER and never complete. The problem is after we noticed that it was hanging we kill the job and started … [Read More]
Blocking with OBJECT_NAME()
As a DBA, you probably use the OBJECT_NAME() function quite a bit. I know I do. If you aren’t familiar with it, you can read the documentation if you want, but it’s a pretty straightforward function that converts object IDs into object names. I ran … [Read More]
Do triggers start to degrade in performance (or sometimes fail) on highly transactional tables?
Question How many transactions per second can SQL Server table triggers handle? If I had a highly transactional table that was inserted into 1,000 times a second, are insert triggers on that table reliable to fire every single time? asked 2019-12-21 by J.D. Answer are … [Read More]
What the heck is the dbcreator role?
Microsoft docs defines the dbcreator role as: Members of the dbcreator fixed server role can create, alter, drop, and restore any database. But what specific permissions are actually included in that role? If we scroll down in the docs just a little, we’ll see a … [Read More]
Testing as another user…without their password
As a DBA or SQL Developer, you’ve surely encountered a scenario where something worked for you, but not for another user. DBAs usually are part of the sysadmin role, or have a collection of powerful permissions. If I run code as myself, I will never … [Read More]