SQL Karaoke 2018 at the PASS Summit 2018 is live

Published On: 2018-08-27By:

Another excellent PASS Summit is almost here. And with the PASS Summit comes the SQL Karaoke party. And once again DCAC is hosting this great event which will let us all ring in the PASS Summit in style.  We have two fabulous sponsors for the event this year, with our great friends at SentryOne and SIOS sponsoring the event.

Just like in years past, this is the PASS Summit party you don’t want to miss. We’ll have the live band playing all your favorite tunes for you to sing to, soda, beer, wine and well drinks for those with a wristband and a cash bar for those that don’t get a wristband.

The party starts at 9:30 pm and rocks until 1:30 am giving you plenty of time for a nap before the keynote begins on Wednesday.

Be sure to bring your Eventbrite ticket to the door to get your wristband, as well as Photo ID (drivers license or Passport) to get to get into the bar). And come and have a great time.

The PASS Summit Summit code of conduct will be in effect at this event.

You’ll find the link to the party here, so get registered.

Just like in prior years, you should register for EITHER the cash bar or the open bar. The open bar includes beer, wine, and well drinks. For the cash bar, you’ll be paying for your drinks.  So get signed up, and we’ll see you at the party.

Denny

The post SQL Karaoke 2018 at the PASS Summit 2018 is live appeared first on SQL Server with Mr. Denny.

Database Maintenance and ColumnStore Indexes

Published On: 2018-08-20By:

Recently on Twitter I saw a question about what index maintenance you should be doing on your ColumnStore Indexes when it comes to maintenance.  As I looked through DCAC’s blog posts I realized that none of us had blogged about this topic before.

The reason for this is pretty basic, there’s really nothing to do when it comes to maintenance on a ColumnStore index.

Normally we do maintenance on indexes to reduce fragmentation, but there’s no fragmentation on ColumnStore indexes as the data isn’t stored on the table in a sort order.  Data pages that aren’t needed anymore are removed automatically (the same with dictionary pages).  The other big thing that index maintenance does, it update statistics on indexes. Well, there are no statistics on ColumnStore indexes, so there are no statistics to maintain. Why aren’t their statistics? Because every operation is a scan of a ColumnStore index.  Since everything is a scan, there’s no need for statistics.

Denny

The post Database Maintenance and ColumnStore Indexes appeared first on SQL Server with Mr. Denny.

Why Profiler For Life?

Published On: 2018-08-13By:

I admit it, I still use SQL Profiler. I always have, and I will for the foreseeable future. My reasons are pretty simple.

  1. When it comes to troubleshooting I can spin up a Profiler session must faster than an Extended Events session.
  2. Usually, I’m troubleshooting something as a one-off. so having my session isn’t really something I care about.
  3. I usually can’t bring scripts into my client’s servers to setup Extended Events, so I have to go create everything manually. (See #1)
  4. Done correctly with filtering, there’s no risk of a production outage using Profiler.
  5. If I could bring in scripts to set up an Extended Events session (see #3) I’d have to modify the session which I can do faster in profiler than in Extended Events.

Should you be using Extended Events? Probably. Odds are you got a full-time job somewhere, so extended events sessions are going to make more sense for you as you can run them against your servers and easily jump on and see what the server is doing.

What would it take get me to use Extended Event sessions instead of Profiler? Speed. Whatever GUI Microsoft creates for Extended Events needs to be just as responsive as the Profiler GUI, and the data that is returned needs to be returned by Extended Events just as quickly as data is returned from Profiler.

Denny

The post Why Profiler For Life? appeared first on SQL Server with Mr. Denny.

Get some behind the scenes information on PASS Summit Speaker Idol

Published On: 2018-08-06By:

If you’ve been thinking about submitting for the PASS Summit 2018 Speaker Idol, but you aren’t sure that it’s for you, we can solve that problem.  On

https://www.flickr.com/photos/oskay/8668965783

August 30th, 2018 at 1600 UTC (4 pm) join myself, Karen Lopez, and Joey D’Antoni at the PASS Professional Development Virtual Chapter as we talk about Speaker Idol at the PASS summit.  You can register for the session on the PASS Professional Development VC website. We look forward to seeing everyone at the webcast.

 

Denny

The post Get some behind the scenes information on PASS Summit Speaker Idol appeared first on SQL Server with Mr. Denny.

1 2 3 4 5 333

Video

Globally Recognized Expertise

As Microsoft MVP’s and Partners as well as VMware experts, we are summoned by companies all over the world to fine-tune and problem-solve the most difficult architecture, infrastructure and network challenges.

And sometimes we’re asked to share what we did, at events like Microsoft’s PASS Summit 2015.