(Pinal Dave) With mirroring gone as deprecated feature, I have tried to keep away from exploring into what has been happening in this space.

(Niladri Biswas) Stored Procedure optimization is an art mixed with some techniques and needs lots of patience with an eye for detail at every aspect.

(Manoj Pandey) Redundancy in Database systems occurs with various insert, update, and delete anomalies.

(Ghanesh Prasad) I have Excel files I need to read using SQL Server Integration Services (SSIS), but the first few rows in the file are just information about the data and these rows should be ignored. How can I read data from an Excel file starting from the nth row in SQL Server Integration Service

(Jon Gallant) I built a stateless Azure Service Fabric service and later realized I would need a stateful service. Rather than try to comb through docs to see what the conversion looked like, I created a brand new stateless service and another stateful service and diff’d them.

(Steve Endow) Back in 2014, the venerable Tim Wappat wrote an excellent blog post on the DEX_ROW_TS field that exists in some Dynamics GP tables.

(Niladri Biswas) Stored Procedure optimization is an art mixed with some techniques and needs lots of patience with an eye for detail at every aspect.

(Sandeep Chanda) The Azure Batch service is now available for general use. It is a fully managed service hosted in Azure that lets you configure scheduled jobs and supports performing compute resource management for other cloud based services.

(Pinal Dave) New versions bring new learning. To keep myself up-to-date, I have downloaded RC0 (release candidate zero) for SQL Server 2016 and while installing SQL Server I was surprised to see the feature list.

(Dave Ballantyne) I’ve been developing T-SQL for about 20 years now and almost since day one there has been functionality that , IMO, has been missing. That is grouped string concatenation (ie forming a delimited string ) and string split ( breaking up a delimited string).