(Thomas LaRock) I like having a routine. Most people do, I suppose. There’s some comfort in knowing what lies ahead, what comes next. This is also true for when you need to restore the master database in SQL Server 2016.

(Andrew Jackson) Database backups are generated as part of the business continuity planning procedure. Disasters with server or its database are a common scenario that takes place every now and then lead to the loss of an enormous amount of data.

(Robert Sheldon) It is a good time to get familiar with Azure SQL Data Warehouse. The first objective must be to get data into it. SSIS is a good way to start, and it’s certainly worth gaining confidence with the ETL processes supported by SSIS before setting off in other directions.

(Pinal Dave) Last week I published below blog where I talked about a trace flag. Backup Randomly Failing with Error 112 (There is not enough space on the disk.) One of the readers commented, whether he needs to enable trace flag every time SQL Server is restarted?

(Rob Farley) Isn’t it great to have a new version of SQL Server available? This is something that only happens every couple of years, and this month we saw one reach General Availability.

(Siddharth Mehta) Reports are part of almost any IT ecosystem that generates, gathers and analyzes data. Typically when the scope of the budget approved for the IT expenditure is low, businesses start with low cost data management and reporting alternatives likes MS Access. As the volume of data kee

(Manoj Pandey) Today I came across a weird error as my colleague was trying to open SSMS (SQL Server Management Studio), and it was throwing following error:

(Pinal Dave) I have been playing around with SQL Server 2016 for a while now and I have seemed to have learnt a number of interesting options when playing around with the new version.

(Tim Smith) We’ve run into an issue where keeping records of row counts didn’t warn us about SQL Server replication stalling and we wanted to know if there were other approaches to solving this problem, especially related to transactions pending to be replicated.

(Kenneth Fisher) There is a highly useful system view called sys.master_files. If you’ve never encountered it before it returns a list of all files from all databases. It’s been somewhat frustrating to me that there is no similar master_objects, master_tables, master_indexes etc.