One of the most important aspects of SQL Server administration and maintenance is the ability to review and changing the existing configuration of the server. In Part 01 of this tutorial series, I had mentioned that one of the key responsibilities of...

SQL Azure is a cloud-based service from Microsoft that uses a special version of SQL Server as its backend. SQL Azure helps to ease provisioning and deployment of multiple databases. Developers do not have to install, setup, patch or manage any software...

A problem that has plagued SQL Server for a long time is that a database is not very portable. Sure, you can backup or detach a database and restore or attach it elsewhere, but when you do that, you are missing a lot of the pieces that make that database...

SQL Server 2012 has a number of new T-SQL features. Listed below are all of the new features, along with the best links I have found that describe each feature: WITH RESULT SETS, OFFSET AND FETCH, THROW, SEQUENCE: See New T-SQL Features in SQL Server...

A useful command for DB2 DBAs is the LIST UTILITIES command. It displays the list of active utilities. Examples of usage include : BACKUPS, RESTORES, performance issue, progress of RUNSTATS [db2usr1@server1 ~]$ db2 list utilities show detail ID = 36708...

A DB2 Incremental Restore recovery strategy requires: a) The full backup image b) 0 or more incremental backup c) The days logs The db2ckrst utility parses the history file and allows you to source the relevant backup images. Method 1 - Automatic Restore...