(Andrew Pruski) In SQL Server 2014 SP2 an interesting new DBCC command was included, DBCC CLONEDATABASE

(Chris Webb) The Web.Contents() function in M is the key to getting data from web pages and web services, and has a number of useful – but badly documented – options that make it easier to construct urls for your web service calls.

(Thomas LaRock) The IT industry has a long-term memory disorder.

(Daniel Calbimonte) I noticed that in SQL Server 2012 and later versions it is possible to create SQL Server Integration Services (SSIS) parameters. What are SSIS parameters and how are they used?

(Nakul Vachhrajani) Database schema design involves defining the clustered keys (generally the primary key) on a table, and one of the main decisions to be taken is whether to use a clustered key based on a UNIQUEIDENTIFIER/ROWGUID or an INTEGER?

(Jen McCown) We’ve done this before, but we can go one better this time.

(Robert Sheldon) Although SQL Server for Linux removes the concern that adopting SQL Server forces you to also adopt the Windows platform, it could also provide a useful alternative platform, and a more obvious alternative to Oracle. There are, however, several obvious concerns as to how such a prod

(Manoj Pandey) The following four built-in database schemas cannot be dropped:

(Tibor Karaszi) You often see Page Life Expectancy referred to as an interesting performance monitor counter. And it can be! It indicates for how long a page is expected to stay in cache, from the time it was brought into cache.

(Manvendra Singh) Suppose you have a new requirement to change the failover mode from manual to automatic for a SQL Server Database Mirroring configuration. As we know the witness server is mandatory for automatic failover, so we need to add a witness server to the database mirroring configuration t