Monday Morning Mistakes: Connecting to Wrong Environments

Posted on

Today’s Monday Morning Mistake issue is another painfully common one that we all run into at some point. You’ve got some new code given to you by a developer that’s supposed to be ran against QA (because you’re a good DBA and you don’t grant developers access to anything outside of Development). Part of the […]

BIxPress 3.5–Now With More Awesome!

Posted on

Pragmatic Works has now released version 3.5 of the award-winning BIxPress software! For those not familiar with BIxPress it’s a tool that helps you develop SSIS/SSAS solutions faster, easily/quickly deploy SSIS packages, monitor performance SSIS packages and much, much more! So what’s new with 3.5? In addition to now having SQL Server 2012 support (SSIS), […]

You sure do got a 'purty motherboard...

SQL Server 2012: Biggest Little Core-house

Posted on

Now that SQL Server 2012 is generally available to the public, many companies are looking at the new platform and trying to figure out how to move to it and take advantage of all the new cool features. Unfortunately, some folks haven’t noticed/been aware of some of the fine print that came along with this […]

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 […]

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) […]

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 […]

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 […]

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 […]

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, […]

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 […]