SQL Server Community

SQL Server Blog

Denny Cherry
Follow /7 Jun 2017 at 5:00pm / SQL Server Blog

Azure Import Export Services – Notes from the field

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 terabytes of data into Azure by using the Azure Import...
360 0 /
Denny Cherry
Follow /24 May 2017 at 8:00pm / SQL Server Blog

Should I build a 1×6 VM or a 6×1 VM?

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 other hardware-y things here for...
418 0 /
Denny Cherry
Follow /26 Apr 2017 at 5:00pm / SQL Server Blog

Partitioned Tables and ColumnStore

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 issues as well if you aren’t very...
430 0 /
Arun Sirpal
Follow /22 Mar 2017 at 1:00pm / SQL Server Blog

My path from a junior to a senior DBA

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. Time … Continue reading →
728 0 /
Pinal Dave
Follow /21 Mar 2017 at 1:30am / SQL Server Blog

SQL SERVER – DBCC SHRINKFILE: Page 1:26423878 Could not be Moved Because it is a Work Table Page – TempDB Files

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 initial size itself was huge and when they tried to shrink...
543 0 /