(Pinal Dave) One should be very careful while working with system objects in SQL Server. Below is one of the situation where some permissions were given on system objects which was causing SQL startup failure. I have written various blog on script upgrade mode of SQL Server.

(Kenneth Fisher) It’s that time again. Kennie Nybo Pontoppidan (b/t) is the host this month and has a fun topic for us.

(Manoj Pandey) How can I get the numbers of records affected in the Merge statement, INSERT,UPDATE,DELETE separately and store it in a variable so I can get it in the application side?

(Glenn Berry) Since the release of SQL Server 2016 Service Pack 1 on November 16, 2016, with many very useful programmability-related features that were previously only available in Enterprise Edition, it has become much more feasible for many organizations to purposely choose to use SQL Server 2016

(Rahul Mehta) In SQL Server Reporting Services (SSRS), a report sometimes has large text columns that can distort the overall view of the report results and make the report not as useful. In this tip we look at one way of solving this problem and still providing all of the details.

(Chris Webb) The recent release of Visio Online (which means most people with an Office 365 subscription can now see Visio diagrams in the browser) and updates for Visio Pro for Office 365 (the desktop version of Visio, needed for creating diagrams, available on subscription but annoyingly not inclu

(Melissa Coates) This is a quick post to share how we can use the coalesce operator in Azure DocumentDB (which is a schema-free, NoSQL database) to handle situations when the data structure varies from file to file. Varying data structure is a common issue in big data and analytics projects.

(Pinal Dave) In this blog post we are going to learn about Installation Error – The Specified Driver is Invalid.

(Kathi Kellenberger) Using a GUID as a primary key and or clustering key in SQL Server database tables is a subject for religious debate. Sure, they are unique, but they are also wide which makes your nonclustered indexes bigger as well. Some developers swear by them and will use nothing else.

(Carlos Victor) This sequence of scripts can help identify tables that are being blocked and quantify how many locks are happening in your database.