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

Thursday, February 26, 2015 2:00:28 AM
Hopefully you’ve seen over the last two posts some basic techniques for automating and codifying your SQL Server builds.  There’s just two more items I want to cover here, questions you’re probably asking yourself already. The build script Let’s start with reviewing the whole build script to this point. While I wouldn’t recommend running this […]
Wednesday, February 25, 2015 2:00:51 AM
When last we left our heroes, we were discussing how best to go about building SQL Servers quickly and consistently using Powershell.  The thing is, we hadn’t quite gotten to the Powershell part yet and only really covered the build process plus installing SQL Server.  Let’s change that and move on to the next steps. […]
Tuesday, February 24, 2015 2:00:54 AM
Last week, my friend John Morehouse(@SQLrUs) and I had a bit of twitter banter about breaking and fixing things. Of course, my joke is usually “I have a script for that”, to which John replied: @Mike_Fal @IrishSQL @SQLEspresso You have a script that will fix a server after I physically beat it with a bat? […]
Friday, February 20, 2015 10:51:38 AM
I was recently doing some shopping at my local Best Buy, and I wandered through the computer section to see what they were currently selling (as I periodically like to do). While I was standing in the laptop area, a … Continue reading
Thursday, February 19, 2015 4:50:20 AM
Microsoft just posted an announcement on the Power BI blog that there is a new version of the Power BI Designer Preview today! Below is a summary of the updates:

  1. Performance improvements
  2. Dynamics CRM Online connector
  3. Navigator Dialog improvements:
  4. New Transformations:
    • Age and Subtract operations for Date/Time columns 
    • Aggregate Columns: Option to disable new columns’ prefix
  5. Field List improvements:
    • Expand/Collapse tables
    • Hide/Unhide fields
    • Optimized layout (spacing, margins, and fonts)
  6. Report Pages Navigation - Keyboarding support
  7. Lots of other bug fixes
For more details on each of these updates and a video demo of the updates, visit the blog post.

If you are already running the Power BI Designer Preview, just launch the app and it will detect the updated version and take you to the website to download it or just go to this link and download/install the latest version (does not update inside the app, requires you to run the new installer to update).

Looks like there are going to be some good updates to this Preview and at a fast pace as well!
Tuesday, February 17, 2015 2:00:20 AM
Managing SQL server logins, especially in the days of availability groups, can be quite the pain in the butt. Usually we’ll make use of scripts like sp_help_revlogin to manage this, copying logins en masse from one instance to another.  This works, but it’s pretty brute force and there might be logins you may not want […]
Monday, February 16, 2015 2:52:35 AM
I'll be traveling to Phoenix, AZ in less than 2 weeks to speak at SQLSaturday #370 on February 28th! Looking forward to going back to Phoenix again after making the trip down there a couple of years ago with the family for Phoenix Comicon (yes, I am one of those geeks that goes to Comic/Sci-Fi Conventions). Looks like I'll be able to meet up with a bunch of my Pragmatic Works friends as there is big group of them speaking along with a a few from the Colorado area as well and many others that I haven't seen since PASS Summit last year! I am currently scheduled to present "Change Data Capture (CDC) with SSIS" at 1:30pm in the Kachina room. If you are in the Phoenix area on February 28, please make sure you register for this great free event and stop by to see me! :)

Also, for anyone that is thinking about going to the PASS Business Analytics Conference on April 20-22 in Santa Clara, CA, you can use the discount code USSE27 at registration to save $150 off the current registration fee!
Tuesday, February 10, 2015 10:14:59 AM
This month’s T-SQL Tuesday is about how we manage database security, hosted by the ever effervescent Kenneth Fischer(@sqlstudent144). While I didn’t have a lot of time to work on this post, I wanted to share with you all a quick little nugget I used for one of my most recent presentations. So, default databases. This is […]
Tuesday, February 03, 2015 2:38:29 AM
Tip # 4 – Not having a Baseline Top 10 Tips for SQL Server Performance and Resiliency This article is part 4 in a series on the top 10 most common mistakes that I have seen impacting SQL Server Performance and Resiliency. This post is related to the most common errors I see and is […]
Tuesday, February 03, 2015 2:38:29 AM
Tip # 4 – Not having a Baseline Top 10 Tips for SQL Server Performance and Resiliency This article is part 4 in a series on the top 10 most common mistakes that I have seen impacting SQL Server Performance and Resiliency. This post is related to the most common errors I see and is […]
Page 1 of 3 1 2 3 > >>