Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Monday Morning Mistakes: Not Setting Memory Limits

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… Read more

10 comments, 13,023 reads

Posted in SQL Chicken on 28 February 2012

Monday Morning Mistakes: SSIS Expressions Not Evaluating Correctly

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… Read more

9 comments, 2,281 reads

Posted in SQL Chicken on 13 February 2012

Monday Morning Mistakes: Remote Connectivity to SQL Server

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.… Read more

4 comments, 580 reads

Posted in SQL Chicken on 23 January 2012

Estimated Completion Time for Backups and Restores

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… Read more

1 comments, 5,244 reads

Posted in SQL Chicken on 30 December 2011

SQL University: Virtualization Basics

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… Read more

1 comments, 632 reads

Posted in SQL Chicken on 17 November 2011

SQL Server 2012: Business Intelligence Edition

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… Read more

0 comments, 1,511 reads

Posted in SQL Chicken on 3 November 2011

Deploying SSIS Packages with BIxPress

Same functionality but obvious differences

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… Read more

1 comments, 680 reads

Posted in SQL Chicken on 24 October 2011

We Are Community

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… Read more

3 comments, 384 reads

Posted in SQL Chicken on 19 October 2011

PASS Summit Keynote Day 1 Highlights

CLOUD! BIG DATA! EXCEL! CLOUD! CLOUD! Okay, recap done. Not really…sort of. In all honesty, while delivered in a fairly terrible fashion, there were some pretty big announcements made in today’s keynote. First let’s start with the one a lot of folks have been waiting on….

Official Names Revealed

The… Read more

0 comments, 451 reads

Posted in SQL Chicken on 13 October 2011

Expiring Databases and Policy-Based Management

Today on Twitter my friend Jes “Run Forrest Run” Schultz Borland (Blog | Twitter) asked the Community “How do you clean up your dev environments? Let DBs sit out there forever? Delete after X months? Other? This seemed like an interesting issue to tackle and me being the… Read more

0 comments, 626 reads

Posted in SQL Chicken on 6 October 2011

Small Business Hardware

[NOTE] My blog post scheduling-fu is weak, so this post didn’t go out Friday as planned. My apologies.

This is the final installment of our Small Business series. So far we talked about how to get the software, and we’ve talked about the different options of SQL Server available… Read more

2 comments, 696 reads

Posted in SQL Chicken on 26 September 2011

SQL University: SQL Server Editions for Small Businesses

In our last session we talked a little bit about the different options you have in regards to SQL Server in your environment. We talked about HOW to get the software but now we’re going to talk about what the different editions are and what they offer you. For a… Read more

0 comments, 561 reads

Posted in SQL Chicken on 21 September 2011

SQL University: Architecture for Small Businesses

Welcome back to SQL University! This week we’re going to be discussing architecture. In previous weeks we’ve discussed architecture at a high level (Capacity Planning Week) but this week we’re going to get a little more focused. SQL Server is used by businesses of all sizes from local… Read more

0 comments, 373 reads

Posted in SQL Chicken on 19 September 2011

SQLSaturday #85 Orlando: Pragmatic Works BI Pre-Con!

I’m very proud to announce that Pragmatic Works will be presenting a Business Intelligence Workshop pre-con for SQLSaturday #85 in Orlando on Friday September 23rd! In this session you’ll have not one, not two, not three but FOUR Pragmatic Works consultants walking you through how to develop a full business… Read more

1 comments, 342 reads

Posted in SQL Chicken on 27 July 2011

OMG I’m an MVP!

I can’t believe it, but I can finally say that I’m now officially a Microsoft SQL Server MVP! Last week I got the great news from my MVP lead, Ryan Bolz (Twitter) in…a peculiar way. Allow me to explain. Typically MVP renewals and new awardees are notified… Read more

5 comments, 347 reads

Posted in SQL Chicken on 25 July 2011

Second Chances: PASS Community Choice Sessions

Recently I found out that my PASS presentation submission ‘Policy-Based Management’ has a second chance to be accepted for the conference (which I’m really grateful for!) but I need your help! Please take a minute to head over to the Community Choice Sessions page and cast your vote (up to… Read more

0 comments, 312 reads

Posted in SQL Chicken on 18 July 2011

Make It Simple With Policy-Based Management

At work recently, I explained to a coworker the reasons and benefits of having databases in Simple mode in your development environment. Funnily enough, a few hours later, I see my friend Andie Letourneau (Blog | Twitter) posted a blog on how to adjust your recovery modes in… Read more

0 comments, 296 reads

Posted in SQL Chicken on 13 July 2011

Automating Web App Deployments with SSIS

This is just a quick note to let everyone know I’ve uploaded the project files from my Pragmatic Works webinar on Automating Web Application Deployments with SSIS. You can find the link on my Presentations page. If you missed the presentation you can view the recording of it here Read more

0 comments, 189 reads

Posted in SQL Chicken on 12 July 2011

SQL Server Denali CTP3: Policy Based Management

Whether you know it or not, Policy-Based Management is an integral part of the new release of SQL Server “Denali”. Did you know that the HADR feature actually leverages PBM for checks? Yup, that’s right folks. If you’re an administrator and you’re NOT using Policy-Based Management yet, I highly recommend… Read more

0 comments, 521 reads

Posted in SQL Chicken on 12 July 2011

LulzSec: Why You Should Care

Updating Resume is NOT Lulz

Wow, it’s been a crazy last couple of months with LulzSec running around doing what they do. Oh, what’s that? You’ve never heard of them? Well for many outside of IT this is probably the case. For those of us who ARE in IT… Read more

7 comments, 577 reads

Posted in SQL Chicken on 26 June 2011

Newer posts

Older posts