T-SQL Tuesday #070 – The Enterprise

Invitation and roundup from Jen McCown.

Here is your invitation for T-SQL Tuesday #70, and the topic is:

Strategies for managing an enterprise

We define “enterprise” in a number of ways, but I tend to default to two definitions: “the things I’m in charge of” and “anything I don’t want to do manually”.  In other words, you don’t need a large shop to have yourself an enterprise. Of course, feel free to modify the definition to what works for you.

So. How do you manage an enterprise? Grand strategies? Tips and tricks? Techno hacks? Do tell.

T-SQL Tuesday #062 – HealthySQL

Invitation and Roundup from Robert Pearl.

So, let’s get this blog party started, and kick off our international Healthy SQL campaign. Let’s spread the word to anyone and everyone managing a SQL Server Database infrastructure of the necessity to perform regular health checks on each SQL Server and repeat often.  The purpose here is to get database professionals, to ensure that all their SQL Servers are healthy, and can pass a health check. It also means that you can prove this (to heaven forbid, auditors), and back it up with documentation.

If you want to excel in your career as a data professional or DBA, then you need to be concerned about your companies’ SQLFitness.  Therefore, I am inviting all of you, to blog about your T-SQL Resolution, and describe what it is that you will do this year to make sure your SQL Servers are healthy and fit.  Now, it’s ok to ponder Healthy SQL in the abstract, but we’re looking for some technical tips on things a DBA should do to keep your SQL Servers performing well.

It could be something as simple as implementing a new monitoring software or script, updating all your SQL Servers to the latest version or service pack, setting up maintenance and optimization jobs, HA/DR, creating a performance baseline, capturing performance stats, (ie: DMV automation scripts, or MDW), a checklist ,etc.  Sky is the limit, as long as you can contribute something to the SQLCommunity that can be used in the effort to ensure SQL Fitness.

T-SQL Tuesday #040 – Files and Filegroups

Invitation and roundup from Jen McCown.

Hold on! I already hear some of you shouting, “Boooooring!!!”  You don’t have to write a file and filegroup primer, if you don’t want to. Get creative, get tangential! Some of my suggestions:

  • Maybe you’d like to talk about partitioning indexes or tables across filegroups
  • Or performance benefits (still!) of assigning tables to specific drives, via filegroups
  • Or FILESTREAM, specifically (hey, that’s something that requires a specialized filegroup!)
  • Or some horrible misuse of filegroups you’ve seen once  (we always love a SQL horror story)
  • Or, if you have a mind, a file and filegroup backup/restore primer! (Why not? I’m not the only one who loves basics.)
So talk to us, tell us all of your file and filegroup lore!

T-SQL Tuesday #33 – Trick Shot

Invitation and roundup from Mike Fal.

For a while, I was in an amateur pool league.  No, not the one involving water and swimming, but where you try to sink balls into pockets.  It was a lot of fun and is a challenge both for your motor skills as well as your strategy.  I still shoot from time to time, as well as hang out with my old pool buddies.

One thing guys would get into is trick shots.  Two and three rail bank shots, masse shots, or jumping the cue ball to hit the target.  Most of these shots weren’t tournament legal, but they were fun to try and nice to impress the ladies.  More than that, they were a tool to teach you the physics of your pool game.  You could see how throw and English could affect your shot, or how balls would behave after impact.

Just like so many other things I do in my life, the trick shot lessons translate over to SQL Server.  How many times have we built something neat or puzzled out a particular bit of logic that, while it may not have been particularly useful, taught us about how SQL Server behaves.  This month’s T-SQL Tuesday is all about this and the assignment is two-fold:

  1. Show us a cool trick or process you developed, maybe a DMV you used or some reporting logic you created.  It doesn’t have to be useful, just something that you thought was pretty neat.
  2. Tell us what you learned from this trick.  Is it something about an oddity in SSRS?  Maybe with the query processor?  Whatever you did, tell us how it gave you insight in to how SQL Server works.

T-SQL Tuesday #015 – Automation in SQL Server

Invitation and Summary from Pat Wright.

Having taken part in several T-SQL Tuesday’s I decided I would finally put my name in to host one.  I figured it would be a good way to lose my sanity learn some great ideas from this wonderful SQL community.  I figured that since many of you out there set a goal this year to blog more and to learn Powershell then this Topic should help in both of those goals.    So the topic I have chosen for this month is Automation!   It can be Automation with T-SQL or with Powershell or a mix of both.  Give us your best tips/tricks and ideas for making our lives easier through Automation.  Now here are all the details you’ll need for a successful T-SQL Tuesday post!