Change SQL Server stored procedures with batch editing

Learn how to change a group of SQL Server stored procedures (SPs) that perform tasks in your databases. Edit SQL Server SPs at one time with these steps.

Determining SQL Server database storage requirements

Determine accurate storage requirements for a SQL Server database with these methods. Calculate how to set storage requirements for a database application.

Becoming A DBA, Part 2

Buck Woody discusses the hard-earned knowledge and experience that you'll need to gain in order to stand out as a and professional and exceptional DBA.

Generate Scripts to Compare Tables

Generate the scripts that will allow you to compare tables pass/fail.

Becoming A DBA, Part 1

Buck Woody examines examines some of the decisions you'll need to make when embarking on your DBA career, and some the character traits and skills that will help you succeed and progress.

Get record count for a specific database

This will sum all of the records of a specified database, excluding the 'sysdiagrams' table.

Differential Backups

Differential Backups Internals

Describes how data changes for differential backups are recorded using dbcc page

Moving the tempdb database

Moving the tempdb database in SQL Server is a simple process but does require the service to be restarted.

Fixing Orphaned Users

Migrating databases between production, test, development and train servers is something that a DBA needs to deal with constantly. During migration, one of the inevitable issues we need to deal with is concept of Orphaned Users.