Skip to content
DataPerf Professionals
Helping Businesses Maximize the Value of their Data
  • Home
  • About Us
  • Services
  • Blog
  • Contact Us
  • FAQ

Month: February 2018

In PowerShell ADO.NET is Still Your Friend

February 28, 2018 admin 3 Comments

A colleague of mine recently asked me the best way to run queries against SQL Server from PowerShell. The scenario…

Continue Reading →

Posted in: PowerShell

Why I’m Running for the PASS Board of Directors

February 25, 2018 admin

As I see it, there are three phases to your involvement in the PASS Summit. Attend the Summit to learn…

Continue Reading →

Posted in: PASS

The PASS Summit Has Been Very Very Good to Me

admin

In my blog post last March (http://www.sqlpass.org/Community/PASSBlog/tabid/1476/entryid/789/Portfolio-Update-PASS-Programs.aspx) I mentioned that my first PASS Summit was in 2003 in Seattle. I’ve…

Continue Reading →

Posted in: PASS

Tribal Awards Winner

admin

Yesterday I received the news that I was the winner of the Tribal Awards in the category of Best Free…

Continue Reading →

Posted in: PowerShell

Developing New Speakers

admin

There’s a lot of discussion about the process of bringing new speakers to a level that allows them to be…

Continue Reading →

Posted in: Speaking

Why Your Abstract Wasn’t Selected

admin

We’re anxiously waiting to hear from PASS which sessions were selected for the 2014 Summit in November.  It’s a big…

Continue Reading →

Posted in: PASS, Speaking

Search For a Query in RDL Files with PowerShell

admin

In tracking down poorly performing queries for clients I often encounter the query text in a trace file I’ve captured,…

Continue Reading →

Posted in: PowerShell

Scanning the Error Log with PowerShell

admin

One of the most important things you can do as a DBA is to keep tabs on the errors reported…

Continue Reading →

Posted in: Database Administration, PowerShell

Set and Verify the Retention Value for Change Data Capture

admin

Last summer I set up Change Data Capture for a client to track changes to their application database to apply…

Continue Reading →

Posted in: Database Administration

Performance Data Gathering

admin

As a DBA, one of the things I struggled with was gathering all my important system information in one place,…

Continue Reading →

Posted in: Database Administration, PowerShell

Post navigation

Page 1 of 2
1 2 Next →

Recent Posts

  • T-SQL Tuesday #150 – The Start of my Technical Career
  • Buckeye Trail – Jan. 23, 2021
  • Buckeye Trail – Jan. 20, 2021

Recent Comments

  • Sarah Dutkiewicz on Towpath Trail – Sept. 30, 2020
  • Allen on Buckeye Trail – Nov 27, 2020
  • When a Non-Clustered Index on Clustered Columns Makes Sense – Curated SQL on Sometimes that Extra Index is the Right One

Archives

  • May 2022
  • January 2021
  • April 2020
  • February 2020
  • November 2019
  • October 2019
  • September 2019
  • August 2019
  • June 2019
  • March 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018

RSS Unknown Feed

Contact Us

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