SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

TSQL Tuesday #75 Round Up Redux

Okay so I already posted a round up post for this month. You can see it here. Tonight one of the participants, Rob Farley (Blog | Twitter) made me aware of the fact that I missed a HUGE opportunity in making the round up in a Power… Read more

0 comments, 380 reads

Posted in SQL Chicken on 24 February 2016

T-SQL Tuesday #75: Round Up

This month I challenged the blogging community to share their own creations in Power BI. We got a ton of great entries this month, thank you everyone who participated! My overarching goal for this month’s topic was to get folks who may not normally play in the BI space… Read more

4 comments, 1,449 reads

Posted in SQL Chicken on 22 February 2016

T-SQL Tuesday #75: Jump into Power BI

So this month I’ve decided to bring every participant in this blog series kicking and screaming into the BI world. Power BI, if you haven’t heard or seen it yet, is Microsoft’s analytics and visualization solution. This month I challenged everyone to create their own Power BI report and share… Read more

10 comments, 1,918 reads

Posted in SQL Chicken on 17 February 2016

T-SQL Tuesday #75 Invitation: Jump into Power BI!

Hello everyone and welcome to this month’s T-SQL Tuesday. This month’s topic is all about Power BI! If you’re reading this and thinking “crap, I’m not a BI person!”, don’t you fret. My intention is to make folks who normally don’t use BI on a day to day basis… Read more

28 comments, 475 reads

Posted in SQL Chicken on 8 February 2016

Using Bookmarks in SQL Server Management Studio

In SQL Server one way we optimize code is by adding indexes. Indexes help queries by essentially letting the engine know “hey, here’s the fast way to get directly to the data you want”. The alternative is doing full table scans to read all the data, which sucks.

When reviewing…

Read more

2 comments, 7,338 reads

Posted in SQL Chicken on 6 November 2014

EPM Framework v4 Released!

The Enterprise Policy Management Framework (EPMF) team is proud to announce the updated release of “Enterprise Policy Management Framework 4.0 for project EPMFramework. This is a major release with lots of performance tweaks and

The EPM Framework 4.0 includes the following updates:

  • For enhanced support of large environments
    • Reviewed database…

Read more

3 comments, 1,065 reads

Posted in SQL Chicken on 19 September 2014

So Long and Thanks For All The Fish

Not to try and steal Satya Nadella’s thunder today at WPC but I’ve got some exciting news of my own to share. I’m excited to say that I’ll be fulfilling a lifelong dream and going to work for Microsoft!

Every Beginning Has an End

This news is kind of a… Read more

11 comments, 341 reads

Posted in SQL Chicken on 16 July 2014

T-SQL Tuesday #48 Roundup

A big thanks to everyone who participated in this month’s T-SQL Tuesday (link) blog party. This month’s topic was to give your thoughts on Cloud. Lots of interesting reads after the break.

Below are links to everyone who participated this month. If I missed your ping back or tweet, please… Read more

2 comments, 748 reads

Posted in SQL Chicken on 19 November 2013

T-SQL Tuesday: Head in the Clouds

This month’s T-SQL Tuesday is hosted by yours truly. Our topic this month is simply the Cloud. If you work in IT there’s approximately zero chance that you’ve managed to avoid this word in some respect. Has your manager asked you to look into what cloud solutions can do… Read more

7 comments, 862 reads

Posted in SQL Chicken on 12 November 2013

T-SQL Tuesday #48– Cloud Atlas

Welcome to this month’s (November 2013) edition of T-SQL Tuesday. For those not familiar this is rotating blog party that was started by Adam Machanic (@AdamMachanic | blog) back in 2009. Want to catch up on all the fun to date? Check out this nice archive (link)… Read more

23 comments, 640 reads

Posted in SQL Chicken on 5 November 2013

Upcoming Presentations

Just a quick note to let you know about a few upcoming presentations I’ll be doing. This week I’ll be presenting remotely for the Washington DC PASS User Group, PASSDC (event link). I’ll be presenting “Do More With Less: Consolidate and Virtualize“. Since all the stuff… Read more

1 comments, 585 reads

Posted in SQL Chicken on 11 June 2013

Internet Security Advice For The Family

Constant Vigilance!

For today’s post I’m channeling my inner Brian Kelley (Blog | Twitter) and talking about security, in particular Internet security. The post today is actually an email exchange between myself and my younger sister. She asked me for some general advice and I wrote a long… Read more

3 comments, 912 reads

Posted in SQL Chicken on 28 May 2013

Business Objects on Linux and SQL Server

This is just a quick post to share a lesson learned while I was on an engagement where the client’s reporting environment was using SAP Business Objects (BO)running on Linux for reporting. We were doing a test to move the underlying data warehouse from another database platform to SQL Server… Read more

2 comments, 891 reads

Posted in SQL Chicken on 23 May 2013

Speaking at PASS Summit 2013!

I’m happy to officially announce that I’ll be presenting at this year’s PASS Summit in Charlotte, NC! I’ll be presenting my talk “What is a BI DBA?” as a Spotlight Session (90 minutes). This is the second time I’ll have presented at the Summit and I’m honored and beyond excited… Read more

2 comments, 524 reads

Posted in SQL Chicken on 22 May 2013

Magnify SQL Text with SSMS 2012

This is just a quick tip to help with folks who present SQL code at events such as SQL Saturday. While most presenters use tools like ZoomIt (which if you present, please please learn to use this wonderful, free tool) sometimes it can get nauseating for attendees to watch you… Read more

5 comments, 749 reads

Posted in SQL Chicken on 16 May 2013

SQLSaturday #209 – Rochester

Welcome to the Roc!

Just a quick note that I’ll be presenting this weekend, Saturday May 11th, at SQLSaturday in Rochester, NY. Exciting to return to Central New York as I graduated right down the road at Syracuse University. Go Orange!?If you’re in the area come on down,… Read more

0 comments, 744 reads

Posted in SQL Chicken on 8 May 2013

Necromancing the Chicken

First off, I’m sorry this space has been dead for so long. I’m sure I’ve dropped off many an RSS reader (as well as SQLRockstar’s Rankings) due to inactivity. Well, it’s high time I get back on the blogging wagon! So what’s happened since the last post (YIKES!) in… Read more

1 comments, 805 reads

Posted in SQL Chicken on 16 April 2013

24 Hours of PASS Fall 2012

Do you like training? Do you like FREE training? Then make sure you check out the 24 Hours of PASS event that starts today at 12:00 GMT. If you miss the events of the day, no worries, the recordings will be up within a few weeks.

Check out the great… Read more

0 comments, 1,229 reads

Posted in SQL Chicken on 20 September 2012

How To Prevent SELECT * The Evil Way

SELECT * FROM…when administrators see that from developer code, we generally tend to cringe. Why? In a nutshell, it’s terrible on a few fronts. First, typically that SELECT * FROM that gets written (a lot of the times) lacks a WHERE clause. What’s the problem? Well, that pulls back every… Read more

10 comments, 1,750 reads

Posted in SQL Chicken on 27 July 2012

Identify and Alert for Long-Running Agent Jobs

Being a DBA is like being a train conductor. One of the biggest responsibilities is making sure all jobs are running as expected, or making sure “all the trains are running on time” so to speak. As my partner-in-crime Devin Knight (Blog | Twitter) posted earlier, we… Read more

10 comments, 9,674 reads

Posted in SQL Chicken on 9 July 2012

Older posts