Listing Page

One of my clients recently had the need to upload tens of terabytes of data into Azure Blob Storage. This gave us the perfect opportunity to use the Azure Import Export service to get these several te...

This sort of question comes up a lot.  And there’s a lot of it-depends built into the answer, so I’ll try and break this down a little bit for you.  Be warned, we’re going to be talking about NUMA and...

ColumnStore indexes are all the rage with data warehouses. They’re fast, they’re new(ish) and they solve all sorts of problems when dealing with massive amounts of data.  However they can cause some i...

A non-technical post but something I have been asked about few times so I thought that I would put pen to paper and tell you about my journey on becoming a senior DBA. You might find it fun to read. T...

This blog is an outcome of an email communication with my client. The issue was that they were having big tempdb files. They had multiple files and of uneven size. As soon as they restart SQL, the ini...

TDE (Transparent Data Encryption) encrypts the data files at rest but don’t forget that it also encrypts your backup file too. I fancied looking inside the MDF and a backup of my database before enabl...

Padding zeroes to an integer is often required during data migrations and integrations. Here is the approach I use in such data conversions. Read the complete post at feedproxy.google.com/…/...

Just another day while doing performance tuning engagement, Senior DBA of the organization and I both noticed that one of the SP sp_readrequest  is continuously listed as long running SP. Well, the go...

Question: How to Find How Many Rows Each Query Returned Along with Execution Plan? Answer:During my performance tuning consultancy engagement, this is one of the most asked questions. Everyone wants ...

If you work with a product for a long time, you would start loving it. I have worked with many other RDBMS, but my love to SQL Server will never die. The amount of information available in logs is ver...