Dale Kelly

Dale has been in the computer industry since the late 80searly 90s. He started working full time in IT in 1999 as a Systems Analyst. In that role he was learning and working with Oracle and did some development work. In 2001 Dale started a new job as the IT department in a software development company. In addition to my database administration duties I also took care of the network administration, server administration, user support and of course administration for all databases. In this role I was primarily working with SQL Server. In 2009 I started my current position as a Sr. Database Administrator for SQL Server administering 26 servers.

Articles: 5

Database Administration

SQL Server Physical Database File Size Report

One of my SQL servers has a database that grows very rapidly (1 GB per week). I needed an easy way to monitor the growth of this database. I also needed an easy way to monitor all my servers for growth trending. In a previous tip I covered the process I u

Dale Kelly
August 21, 2012

Monitoring

Use PowerShell to gather SQL Server database physical file sizes

Dale Kelly
May 23, 2012

Reporting Services Migration

Migrate SSRS to New Server by Moving ReportServer Database

In this article we walk through the steps that Microsoft recommends for moving Reporting Services to a new server.

Dale Kelly
May 18, 2012

Reporting Services Migration

Migrating SQL Reporting Services to a new server

I have some SQL Server 2005 Reporting Servers that have many reports, data sources and subscriptions loaded on them. My company is in the process of moving from SQL 2005 to SQL 2008 and 2008 R2. I need to move all the objects off the 2005 Reporting Server

Dale Kelly
March 19, 2012

Scripts

Script to Find and Drop All Orphaned Users in All SQL Server Databases

In this tip we look at a script that identifies all orphaned users for all databases on a SQL Server instance. The script can both identify and drop the orphaned users.

Dale Kelly
February 10, 2012