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 and let us know.

ColoradoSQL Bloggers

Tuesday, January 20, 2015 2:00:35 AM
SQL Server backups are a key part of any database administrator’s job and one of the first items that will get automated in an environment. In my career, I have seen a number of different approaches to this task, usually a combination of T-SQL and SQL Agent Jobs. When using these, you usually have two […]
Monday, January 19, 2015 11:00:00 PM
Tip # 2 – Check your Security Top 10 Tips for SQL Server Performance and Resiliency This article is Part 2 in a series on the Top 10 Most Common Mistakes: SQL Server Performance and Resiliency. Neglecting security is the second biggest mistake I frequently see impacting SQL Server’s performance. In case you have missed […]
Tuesday, January 13, 2015 4:51:16 AM
The T-SQL Tuesday question this month is from Robert Pearl and is a topic that is near and dear to me. The topic overall is keeping your SQL Server Healthy, and this is the primary function of my current job. The team I am on watch a number of servers for over 100 clients. This […]
Monday, January 12, 2015 1:42:11 AM
Just a quick update on some on going items that will hopefully be of some interest to you. SQL Saturday Albuquerque (358) and Phoenix (370) For the third year in a row, I’ll be down at SQL Saturday Albuquerque.  I love this event and the people who run it, and going to Albuquerque is always […]
Friday, December 19, 2014 9:46:24 AM
Today Microsoft announced some very big updates to Power BI that will make it more like the product I have been hoping for since it was first announced.

First off the new site has launched in Preview mode with lots of info on all of these new features.

Also today we got the Preview download of the Power BI Designer that allows for the design and viewing of Power BI solutions in a standalone application. Before you get too excited this first Preview release of the Power BI Designer only does Power Query and Power View functions, no Power Pivot or Power Map yet (hopefully those will be added in future releases). You can use existing Power Pivot models as a source, but you
will not be able to update those Power Pivot models until a future release. I think that this new application will finally give us the unified development environment we have been looking for to do Power BI solutions.

Also added today to Power BI is the Preview release of connecting to onsite SQL Server Analysis Services Tabular models. This is a Preview release as well, but can be accessed from the existing Power BI online tools and the new Power BI Designer.

Power BI Dashboards was also added to the feature list along with a few new visualizations (combo charts, fill maps, gauges, tree maps and funnel charts). A bunch of new data sources were also added with built-in support: Github, Salesforce, SendGrid, Zendesk, Dynamics CRM, and Marketo.

And the Power BI app for Apple iPad was announced that it would be available in the Apple AppStore sometime today (12/19). There was still not a link to go directly to the Apple AppStore as of late this afternoon, so this may not show up until after the new year since Apple is shutting down AppStore updates for the holidays very soon.

Reading between the lines a bit on all of this it looks like Power BI is being positioned as a full standalone application that will no longer require Excel 2010/2013, Office 365 or even SharePoint (on-prem or online). I think that this is exactly what Power BI needs to become a much more accepted application in the Enterprise and I for one am very excited about the possibilities now!
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 […]
Page 1 of 2 1 2 > >>