I've been playing around with the new Microsoft service, currently in preview and it's time to show off what it can do. Have you ever struggled with a database performance problem or ever struggled to ...

Got a MSSQL script for backing up all databases on a server. It basically backs up all but the TEMP db. But what I want to do is exclude just two of the databases from being backed up. So I've got ...

In part 1, we looked at generating T-SQL style code. In part 2, let's get this thing to run! Last time, I showed how a single SELECT statement can be built to create an executable string of T-SQL.

Data plays a vital role in any successful business. Protect­ing this data is mission-critical, and it falls to database administrators (DBAs) to organize, maintain, and secure it. The most effective ...

How to quickly back up and restore a database with phpMyAdmin Your email has been sent If a web-based GUI is better suited to your admin skills, Jack Wallen wants to show you how to back up and ...

The DocAve SQL Restore Controller comes as an independent module within the DocAve platform. It provides full fidelity restore of items, site and site collections within SharePoint for data both live ...

This week, I again had the opportunity to be on the Virtumania podcast with Rich Brambley, Marc Farley and a special SQL server guest, http://www.brentozar.com/ Brent ...