How to store real-time data to database

February 23, 2020 Andy 0

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]

Job waiting on CXCONSUMER

January 9, 2020 Andy 0

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()

December 24, 2019 Andy 0

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]

What the heck is the dbcreator role?

December 19, 2019 Andy 0

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]

I hate sp_estimate_data_compression_savings

December 17, 2019 Andy 0

If you’re working with compressed indexes, SQL Server provides a system stored procedure to help test the space savings of implementing data compression: sp_estimate_data_compression_savings. Starting in SQL Server 2019, it can even be used to estimate savings with columnstore. I really don’t like sp_estimate_data_compression_savings. In … [Read More]