(Pinal Dave) As a part of my quick consultancy, I was contacted by a client who was having trouble where the application was not able to connect to SQL Server. We all joined the call and desktop sharing to learn more about the issue.

(Dallas Snider) I need to export data from the Hadoop Distributed File System (HDFS) to a SQL Server database table. How can I do this?

(Paul Turley) I recently needed to replicate all of the reports on one report server to a different server. I started downloading each report one at a time to a file system folder, moving them to the other machine and then uploading each RDL file.

(Jack Vamvas) A developer contacted me to explain how he was not able to script out tables from a database . He was surprised because he had the right on some databases within the SQL Server instance but not on other databases.

(Manoj Pandey) Have you ever been in a similar situation where your PROD database size is in GBs or TBs, and for a code-release validation or some performance-fix you need to restore it on an Dev or Test server? You know that taking backup & restore will take lot of time, but you have no other optio

(Pinal Dave) The era of innovation with SQL Server administration side of things keep happening, it is strange that a lot of us miss these capabilities getting added into the system. I have seen processes define the way how DBA’s work. In a lot of places, the processes, scripts and behaviors are bro

(Thomas LaRock) I’ve written before about how databases are like a car engine, and DBAs are like a car mechanic. That’s been the traditional view for production DBAs for, well, forever I think. And that analogy may have been true at one time, and may still be true for some DBAs.

(Arun Sirpal) We all know what the sqlservr.exe and its importance, but have you noticed the size difference of the .exe when comparing SQL Server 2008R2 to SQL Server 2012 onwards?

(Kenneth Fisher) I’ve been using sp_helptext for years. Honestly I probably end up using it at least once a day. But I was recently exposed to object_definition() which has a similar output. There are, however, a few differences.

(Sergey Gigoyan) According to database design best practices, a SQL Server table should not contain duplicate rows. During the database design process primary keys should be created to eliminate duplicate rows. However, sometimes we need to work with databases where these rules are not followed or