Blog Feed Info

This page provides an aggregate of feeds from Colorado SQL community members that blog about SQL Server.  If you live in Colorado and would like your fieed listed, please send us an email at info@coloradosql.org and let us know.

ColoradoSQL Bloggers

Tuesday, December 09, 2014 10:17:03 AM
Have you heard and understand why processing a ‘select * from any table’ can be negative on the performance impact? While I was doing some demo prep for my upcoming PASS Summit Pre-Conference I saw this behavior at its worst. Before we jump into why this is such a negative impact on your performance I […]
Sunday, December 07, 2014 9:19:52 AM
For my first speaking event of 2015 I'll be presenting "Capture Change and Apply It with CDC & SSIS" at SQLSaturday #362 in Austin, TX on January 31st @ 9am. Looking forward to going to a city that I have wanted to visit for many years and going back to the area where I was born (Fort Hood, TX). My family moved from Texas when I was only a few weeks old as my Dad completed his service in the Army and went back into the private sector. I'm going to be flying in early on Friday, January 30 so that I can do some sight seeing for the day.

If you are going to be in the Austin area, it would be great to see you! To register for SQLSaturday #362, just click on this link and I'll see you there!
Thursday, December 04, 2014 2:00:15 AM
One of the commonly referenced blogs out there is Kimberly Tripp’s(@KimberlyLTripp) seminal post on Virtual Log Files.  If you haven’t read it yet, I highly recommend it.  It provides a good description of one of those quirks with your log files and how you should manage it. Of course, while folks are familiar with this, it’s […]
Wednesday, November 26, 2014 5:43:01 AM
Sometimes managing multiple file groups and the amount of data that is in them can cause a few logistic issues. Recently I found myself needing to know what tables are in what file groups and what the sizes of those tables are. With the database the size it is and the number of objects that […]
Thursday, November 20, 2014 4:11:16 AM
Last post I gave the rundown of Desired State Configuration and how it worked, but I skipped over the “secret sauce” around SQL Server. Of course, that was the tease to get you to come back for this week’s post.  Let’s dig in to the process and see how we can use DSC to install […]
Saturday, November 15, 2014 10:52:13 AM

PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please note that in order to attend one of these event, you must register. Please register soon as seating is limited, and let friends and colleagues know about the event. Most events are free, however a nominal fee may be charged so that lunch may be provided (not pizza).

The post PASS SQL Saturday Events: December 2014 appeared first on DawaBI.

Tuesday, November 11, 2014 4:17:00 AM
As a DBA, I’m always concerned with consistency in my environments.  From maintenance to code deploy, I want things to be done the same way every single time.  Usually this is a process question, making sure that you harness the power of check lists and repeatable steps.  You then make it better by wrapping your […]
Sunday, November 09, 2014 10:00:20 AM
I'm back home after an amazing week in Seattle for PASS Summit 2014. Love visiting Seattle, especially when there are lots of #SQLFamily there to enjoy it with!

I got into Seattle on Sunday afternoon via train from Portland. Was the first Amtrak train that I have ever been on and was a nice relaxing ride from Seattle to Portland. I guess I thought that I would see more of the coast on the train, didn't realize that it was going more inland, still some great scenary.

The week itself went by really fast with PASS meetings on Tuesday and the conference itself starting on Wednesday. My presentation on SSDT, "What Version of SSDT do I Need?" was on Wednesday afternoon, so it was good that I got that over with early in the week. I presented this session in the first set of Lightning Talk sessions with Brent Ozar, Luke Jian, Mark Vaillancourt, Tim Radney and Craig Purnell. Was great to share the spotlight with all of these speakers in a full room and we got through all of our presentations with time for questions at the end! Tim, Craig and I were all in the same Lightning Talk session at PASS Summit 2013 as well.

Below is the updated version of my slides, with a change to the table of SSDT versions, correcting a small oversight on my part.


With the presentation out of the way I was able to enjoy the other sessions and parties throughout the week and see as many of my #SQLFamily as possible. Overall the week went very well and I'm already looking forward to PASS Summit 2015 back in Seattle on October 27 - 30!

Thanks again to everyone that attended my session and I'm looking forward to an even better 2015!
Thursday, November 06, 2014 5:44:15 AM
On November 5, 2014, I had the pleasure of presenting Analyzing I/O Subsystem Performance at the PASS 2014 Summit in Seattle. I was in room 6C, coming on after Conor Cunningham’s presentation on Query Store. People seemed to like the … Continue reading
Saturday, October 25, 2014 7:04:33 AM
Next week I'll be leaving for SQLSaturday #337 Oregon and PASS Summit 2014 where I will be speaking at both!

SQLSaturday #337 Oregon will be my first trip to Portland, so I'm looking forward to seeing a new city and speaking to the Oregon SQL Server community. My session will be "Date and Time Dimensions for Every Day and Time in No Time" at 1:15pm in Room 204 (keep your eye on the schedule page or Guidebook just in case it changes). I love giving this Date Dimension talk as it is something that every Data Warehouse needs and everyone hates setting them up, so I help with a single script and some advice. If you are going to be in the Portland area on Saturday, November 1st, please make sure you register and I'll see you next Saturday!

After SQLSaturday #337 I'll take the Amtrak from Portland to Seattle on Sunday for my favorite conference, PASS Summit 2014! PASS Summit is a yearly SQL Server conference that has thousands of SQL Server professionals and speakers from across the world. For the second PASS Summit in a row I'll be presenting a session. After attending this amazing conference yearly since 2007 I have become very involved in the SQL Server community and love that I now get to be part of speakers/volunteers that make this event great. I'll be presenting "What Version of SSDT do I Need?" at 3pm on Wednesday, November 5th in Room 606. I'll also be volunteering at the PASS Community Zone, so make sure to stop by and say hi!

Looking forward to seeing everyone in Portland and Seattle in a week and hanging out with my #SQLFamily at both events!
Page 1 of 2 1 2 > >>