Pragmatic Works Software for MVPs

Posted on

This is just a quick post to remind folks who are current Microsoft MVPs that Pragmatic Works offers NFR licenses of its software! This NFR offer includes: BIxPress – Audit, Notify, Deploy and Manage SSIS Packages BIDocumenter – One Stop Documentation Solution for SQL Server, SSAS, SSRS and SSIS Task Factory – Collection of high […]

Share

STOP! Consolidate and Listen

Posted on

I just wrapped up my 24 Hours of PASS session on consolidation. A big THANK YOU again to everyone in attendance, who kindly put up with my horrendous rapping “skills”! As promised, below is the link to the slide deck. In the presenter’s notes you’ll find some good links and resources for consolidation. Download link: STOP_Consolidate_and_Listen_24HOP (ZIP file) […]

Share

Monday Morning Mistakes: Not Setting Memory Limits

Posted on

Welcome back to another addition of Monday Morning Mistakes series. Today’s issue is one I tend to run into quite often with clients and is an important topic to know about as a database administrator. Without further ado, let’s get to our issue Issue You have SQL Server database engine installed on a system with […]

Share

Monday Morning Mistakes: SSIS Expressions Not Evaluating Correctly

Posted on

SSIS Expressions Expressions in SSIS are great. They allow you to create dynamic values for all sorts of stuff like variables, connection strings, properties for almost anything, etc. One huge issue that tends to trip up a lot of folks, especially those new to SSIS, is the evaluation of those expressions when using variables. The […]

Share

Monday Morning Mistakes: Remote Connectivity to SQL Server

Posted on

Inspired by common emails and questions I  see, I figured I’d do a series of blog posts on common mistakes folks make with SQL Server called Monday Morning Mistakes (or #sqlM3 for short, since we all love quick hashtags these days). These are meant as quick fixes, nothing too comprehensive. Also since I just made […]

Share

Estimated Completion Time for Backups and Restores

Posted on

I’m in the middle of a database migration and thought I’d quickly share a script I threw together to show estimated time of completion for a database restore in progress on SQL Server. The script will also show you estimated time for database backups to complete as well. Please don’t take this script as gospel, […]

Share

SQL University: Virtualization Basics

Posted on

This week we’re going to talk about a topic that has been gaining steam in the last few years and as it has it has started impacting database administrator’s worlds more and more: virtualization. Why do I make this statement? Well since the economy currently sucks, shops are finding ways to consolidate and make their […]

Share

SQL Server 2012: Business Intelligence Edition

Posted on

Well this was quite the little surprise this morning. Microsoft announced a new edition to the SQL Server lineup for 2012 – Business Intelligence edition. In addition to a new edition (funnily I don’t see Datacenter in that lineup) we also have a new licensing scheme for SQL Server. In SQL 2012 it looks like […]

Share

Deploying SSIS Packages with BIxPress

Posted on

If you’ve worked with SSIS for any amount of time, you may quickly come to find that the native way of deploying packages can be…cumbersome. The native tools, while helpful, aren’t exactly the most intuitive to setup or use. This post will show you how you can quickly and easily deploy and configure packages using […]

Share

We Are Community

Posted on

Today I was planning on writing a summary post of PASS Summit experience but something happened last night that caused me to change up the queue for blog posts and quite frankly bothered me. Today I’d like to address a few things regarding the Community, behavior within it and just general thoughts about stuff. I […]

Share