(Pinal Dave) Today the progress made in technology is astounding and beyond our imaginations, but still there are clients who can’t move to higher, latest and greatest version of SQL so easily. They are still stuck with SQL 2005 and SQL 2008 SQL servers.

(Jack Vamvas) Extended stored procedures are used by developers to create routines. One of the main benefits of extended stored procedures is the ability to make them appear as regular stored procedures.

(Grant Fritchey) The syntax for creating a table logically follows many of the same steps that you did when using the GUI, but it will all be done with the statements. This script will exactly replicate everything that you did with the GUI:

(Brien Posey) You can create SQL Server databases manually, but knowing how to do a scripted database setup is valuable. Here are the steps involved in executing a create database script.

(NEERAJ Sharma) This is the second part on the topic fragmentation in SQL Server, which majorly focus on read problems with fragmentations.

(Pinal Dave) While preparing for a demo for an upcoming session, I came across an error which I didn’t see earlier. Here is the error in the UI and it is related to Backup Log Operation.

(Hannes du Preez) Getting a user that has deleted rows with SQL is a multi-part process.

(Chris Webb) Over the past few weeks I’ve spent some time playing around with Power BI custom data connectors and while I don’t have anything to share publicly yet (other people are way ahead of me in this respect – see the work of Igor Cotruta, Miguel Escobar and Kasper de Jonge among others) I hav

(Kenneth Fisher) I’m working on a project right now and it’s going to require me not only to refresh my SSIS skills a bit but learn a few things that are only available with the latest tools. So everyone ready for a few SSIS posts? Good. Me too!

(_Jo.Pi_)In a customer scenario we saw a query against system views related to always on taking a fairly long time.