Profile

Cover photo
Patrick Keisler
Works at Microsoft
Attended The University of North Carolina at Charlotte
Lives in Charlotte, NC
81 followers|939,217 views
AboutPostsPhotosYouTubeReviews

Stream

 
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...
 
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  - 
 
Comparison of Columnstore Compression
SQL Server 2012 introduced non-clustered columnstore indexes, and SQL Server 2014 gave us clustered columnstore indexes. Both share the same technology for performance boosts, and they both share the same algorithms for compression. However, the compression...
SQL Server 2012 introduced non-clustered columnstore indexes, and SQL Server 2014 gave us clustered columnstore indexes. Both share the same technology for performance boosts, and they both share the same algorithms for compr...
1
Add a comment...

Patrick Keisler

Shared publicly  - 
 
The system_health Extended Event Session
When I first started poking around in SQL Server 2012, I
noticed an extended event session called “system_health” was created by default. It
took me a few months before I really dug into the session details to see what
it was capturing. But once I did, I wa...
When I first started poking around in SQL Server 2012, I noticed an extended event session called “system_health” was created by default. It took me a few months before I really dug into the session details to see what it was...
1
Add a comment...

Patrick Keisler

Shared publicly  - 
 
My Experience Aboard SQL Cruise 2014
Where do I begin? First let me say, WOW what an experience! How it All Began When I first heard about SQL Cruise way back in 2012, I thought the idea of hosting training sessions aboard a cruise ship was a swell idea. However, talking my wife into going wit...
1
Add a comment...
Have him in circles
81 people
Anson Tin's profile photo
Mike Walsh's profile photo
Aaron Romeo's profile photo
Vakul Khullar's profile photo
Mordechai Danielov's profile photo
Nemanja Popovic's profile photo
Jason Brimhall's profile photo
Sridhar Boypati's profile photo
Michael Tayler's profile photo

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 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...

Patrick Keisler

Shared publicly  - 
 
What is a Non-Clustered Columnstore Index?
First introduced in SQL Server 2012, the Columnstore index is a
new in-memory feature that allows for the creation of indexes that are stored
in a column-wise fashion. It is targeted for data warehouses and can improve
query performance by 10 to 100x. A col...
First introduced in SQL Server 2012, the Columnstore index is a new in-memory feature that allows for the creation of indexes that are stored in a column-wise fashion. It is targeted for data warehouses and can improve query ...
1
Add a comment...

Patrick Keisler

Shared publicly  - 
 
How Long is that SQL Command Going to Take?
Have you ever needed to restore a large database while someone is standing over your shoulder asking “How long is that going to take"? If that hasn't happened to you yet, then it’s only a matter of time. Let’s throw out all the reasons why you need to do th...
1
Add a comment...
People
Have him in circles
81 people
Anson Tin's profile photo
Mike Walsh's profile photo
Aaron Romeo's profile photo
Vakul Khullar's profile photo
Mordechai Danielov's profile photo
Nemanja Popovic's profile photo
Jason Brimhall's profile photo
Sridhar Boypati's profile photo
Michael Tayler'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
Food: ExcellentDecor: ExcellentService: Very Good
Public - 2 years ago
reviewed 2 years ago
1 review
Map
Map
Map