Skip to content

DataPerf Professionals

Helping Businesses Maximize the Value of their Data
  • Home
  • About Us
  • Services
  • Blog
  • Contact Us
  • FAQ

Blog

Find (So You Can Fix) those Troublesome Queries

January 8, 2021 admin Leave a comment

In January, for two different groups, I’m presenting this session. Here’s the abstract: Every expert has their own set of…

Continue Reading →

Posted in: Presentations

Sometimes that Extra Index is the Right One

April 29, 2020 admin 1 Comment

Sometimes it’s advantageous to add an index with the same key as another index on the same table.

Continue Reading →

Posted in: Database Administration Filed under: Database Administration, Database Performance, Indexes

Quickly Query Database and Log Size in T-SQL

April 16, 2020 admin 1 Comment

This query will quickly return database and log sizes for review, and adjustment as necessary.

Continue Reading →

Posted in: Database Administration, Transact-SQL Filed under: Database Administration, TSQL

T-SQL Tuesday #123 – Being Will Parker

February 11, 2020 admin

When I was young, I was impatient. Well, I still am, but I’ve gotten better at controlling it. That impatience…

Continue Reading →

Posted in: T-SQL Tuesday Filed under: Getting Along, Life Hacks, T-SQL Tuesday

Are You Ready? (session materials)

November 16, 2019 admin

A little over a week ago I presented this session at the PASS Summit 2019 in Seattle, Washington. I promised…

Continue Reading →

Posted in: Business Processes Filed under: Disaster Recovery, PASS Summit 2019, SQL Server

In an Emergency, Don’t Be a Test Pilot

October 6, 2019 admin

Yesterday I presented two sessions at the Pittsburgh SQL Saturday. The first was a session on using Service Broker to…

Continue Reading →

Posted in: Business Processes Filed under: Disaster Recovery

PASS Board – Should You Run?

September 22, 2019 admin

From January 2016 through December 2018 I had the privilege of serving on the PASS Board of Directors. I was…

Continue Reading →

Posted in: Uncategorized Filed under: #BoardElections, #Community, #NomCom, #PASS

Change Management – It’s Still Important

September 14, 2019 admin

Even small companies will benefit from a well defined change management process.

Continue Reading →

Posted in: Business Processes, Uncategorized Filed under: Change Management, Performance Baseline

Do You Know? What’s In Your Server Inventory

September 10, 2019 admin

Today, as part of 24 Hours of PASS – Summit Preview, I presented a new session demonstrating how to build…

Continue Reading →

Posted in: Uncategorized

Protect, Simplify, Automate

August 21, 2019 admin

Let’s talk about priorities. When I take on the role of the database administrator, I want to make sure both…

Continue Reading →

Posted in: Uncategorized

Post navigation

Page 1 of 3
1 2 3 Next →

RSS Allen White Blog

  • Buckeye Trail – Jan. 23, 2021
  • Buckeye Trail – Jan. 20, 2021
  • Buckeye Trail – Jan. 16, 2021

Contact Us

  • Email
    awhite@dataperfpro.com
Copyright © 2021 DataPerf Professionals — Lyrical WordPress theme by GoDaddy