Profile

Cover photo
Patrick Keisler
Works at Microsoft
Attended The University of North Carolina at Charlotte
Lives in Charlotte, NC
92 followers|1,198,213 views
AboutPostsPhotosYouTubeReviews

Stream

Patrick Keisler

Shared publicly  - 
 
PSSDiag Configuration Manager – A Companion for SQLNexus
Have you ever called Microsoft Customer Support for help with a SQL Server performance issue? The engineer will typically send you a self-extracting exe file with instructions to unzip the file on the server and run the pssdiag.cmd file to collect data whil...
1
1
Jared Karney's profile photo
Add a comment...

Patrick Keisler

Shared publicly  - 
 
Exams 70-457 & 70-458 - Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012
This past week I finally completed the 70-458 exam to upgrade my certification to MSCA: SQL Server 2012. I never thought it would take me over a year to pass two upgrade exams, but sometimes life just gets in the way. I will say this is probably the hardest...
3
1
Joakim Backman's profile photoabhishek srivastava's profile photoJared Karney's profile photo
2 comments
 
congrates
Add a comment...

Patrick Keisler

Shared publicly  - 
 
SQL Nexus Might Just Save Your Bacon
The year is 2015, and I’m still surprised by how many people have never heard of SQL Nexus; although it has been available since approximately 2008. SQL Nexus is a tool that that is designed to collect and analyze data to help you troubleshoot SQL Server pe...
The year is 2015, and I’m still surprised by how many people have never heard of SQL Nexus; although it has been available since approximately 2008. SQL Nexus is a tool that that is designed to collect and analyze data to hel...
1
Edy Wagner's profile photo
 
Thanks for this. I'll check it for sure 😊.
Add a comment...

Patrick Keisler

Shared publicly  - 
 
Get Out There and Challenge Yourself
It’s been almost five months since I posted my last article,
and so much has changed since then. I have a new job, a new house, a new
address, and of course a new mortgage. I had been working as a DBA for Wells Fargo Securities for
nearly 15 years when I de...
1
Add a comment...

Patrick Keisler

Shared publicly  - 
 
Monitor the Number of Deleted Rows in a Clustered Columnstore Index
In some of my previous posts , I have talked about how to create Columnstore indexes. Now I’d like to discuss one maintenance detail that you need to keep an eye on. I’m talking specifically about the number of “deleted rows” in a clustered Columnstore inde...
In some of my previous posts, I have talked about how to create Columnstore indexes. Now I’d like to discuss one maintenance detail that you need to keep an eye on. I’m talking specifically about the number of “deleted rows” ...
1
Add a comment...

Patrick Keisler

Shared publicly  - 
 
Columnstore Table Analyzer
As I’ve discussed in some of my previous posts , there are quite a few data types that cannot be part of a Columstore index. While there are fewer restrictions in SQL Server 2014, they still exist. I find myself constantly looking back at Books Online tryin...
As I’ve discussed in some of my previous posts, there are quite a few data types that cannot be part of a Columstore index. While there are fewer restrictions in SQL Server 2014, they still exist. I find myself constantly loo...
1
Add a comment...
In his circles
64 people
Have him in circles
92 people
Daryl Mccall's profile photo
Olivia Bagley's profile photo
Laurence Cross's profile photo
Doroto Ace's profile photo
Douglas Bentley's profile photo
Tim Mitchell's profile photo
Edy Wagner's profile photo
Boris Hristov's profile photo
Erik Schriber's profile photo

Patrick Keisler

Shared publicly  - 
 
Use Trace Flag 902 to Recover from a Cumulative Update Failure
Recently, I ran into a critical error while I was helping a customer troubleshoot an issue in SQL Server. That may not sound like a big deal, but we were installing Cumulative Update 6 for SQL Server 2012 SP2 to fix our initial problem when we encountered t...
1
Add a comment...

Patrick Keisler

Shared publicly  - 
 
Use PsPing When Working in Azure IaaS
Recently I’ve been learning more about how Azure functions and how it can help my customers. One of the best ways for me to learn about Azure was to build out my own environment using VMs, or Infrastructure as a Service (IaaS). All of that was easy; however...
Recently I’ve been learning more about how Azure functions and how it can help my customers. One of the best ways for me to learn about Azure was to build out my own environment using VMs, or Infrastructure as a Service (IaaS...
1
Add a comment...

Patrick Keisler

Shared publicly  - 
 
SQL Cruise Caribbean 2015 Recap
I wish I could just re-post my article from last year about
SQL Cruise and change the dates and pictures.The event is just that good. I still believe this is one of the more premier training events offered for SQL Server. The amount of 1-on-1 time you get w...
I wish I could just re-post my article from last year about SQL Cruise and change the dates and pictures.The event is just that good. I still believe this is one of the more premier training events offered for SQL Server. The...
1
Add a comment...

Patrick Keisler

Shared publicly  - 
 
PowerPoint Slides Available for Download
I promised that I would post the slide decks for my presentations, and now I have finally followed through on that promise. I have added a new Resources page that will have downloadable content available from blog articles and presentations
1
Add a comment...

Patrick Keisler

Shared publicly  - 
 
How to Edit Read-Only Non-clustered Columnstore Data
As I've discussed in some of my previous posts , creating a non-clustered Columnstore index will make the index as well as the base table read-only. Which means you can’t insert, update, or delete any data until your drop the index. This may seem like a hug...
As I've discussed in some of my previous posts, creating a non-clustered Columnstore index will make the index as well as the base table read-only. Which means you can’t insert, update, or delete any data until your drop the ...
1
Add a comment...

Patrick Keisler

Shared publicly  - 
 
Columnstore Memory Grant Issue
In a previous post about non-clustered columnstore indexes, I mentioned the creation of an index is a very memory intensive operation. Sometimes the memory grant needed exceeds what is currently available on your server. So what do you do about it? SQL Serv...
In a previous post about non-clustered columnstore indexes, I mentioned the creation of an index is a very memory intensive operation. Sometimes the memory grant needed exceeds what is currently available on your server. So w...
1
Add a comment...
People
In his circles
64 people
Have him in circles
92 people
Daryl Mccall's profile photo
Olivia Bagley's profile photo
Laurence Cross's profile photo
Doroto Ace's profile photo
Douglas Bentley's profile photo
Tim Mitchell's profile photo
Edy Wagner's profile photo
Boris Hristov's profile photo
Erik Schriber's profile photo
Work
Occupation
Senior SQL Premier Field Engineer at Microsoft
Employment
  • Microsoft
    Premier Field Engineer, 2014 - present
  • Wells Fargo Securities
    Technology Manager, 2010 - 2014
  • Wells Fargo Securities
    Senior Microsoft SQL Database Administrator, 2000 - 2014
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Charlotte, NC
Previously
Conover, NC - San Francisco, CA
Links
Story
Introduction
SQL Server DBA since 2000, husband since 2010, father since 2012, and Atlanta Braves fan since forever.
Bragging rights
SELECT * FROM users WHERE clue > 0
Education
  • The University of North Carolina at Charlotte
    BSBA - Management Information Systems, 1998
Basic Information
Gender
Male
Apps with Google+ Sign-in
  • Star Wars: Commander
Food: ExcellentDecor: ExcellentService: Very Good
Public - 2 years ago
reviewed 2 years ago
1 review
Map
Map
Map