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

Liveblogging PASS Sumit Day 1 Keynote with Quentin Clark (#SQLPASS #Summit13)

Welcome to the live blog! Have some resources to start: Watch the keynote live here: http://www.passsummit.com  #sqlserver Take a look at the newly announced SQL Server 2014 CTP2 page, and download the bits! Unless you’re on conference wifi, in which case…wait. Get the SQL Server 2014 CTP2 datasheet here. From…

Read more

0 comments, 170 reads

Posted in SQL Awesomesauce on 16 October 2013

Next Week, in or out of Charlotte (#sqlpass #Summit13 #SQLHighTea #TooManyHashtags)

Welcome to Tuesday. We hope you enjoy your stay! Edit: We have been informed that today is actually Wednesday. We are looking into this, and will report back if a workaround or solution is found in a timely manner. -J Here’s a few notes for the ramp up to conference…

Read more

0 comments, 231 reads

Posted in SQL Awesomesauce on 9 October 2013

MidnightSQL Server Evaluation script, version 1.0

Server evaluations are a major part of my consulting business. I need to get up to speed very quickly on a server when I first start a project, and uncover the big potential issues. So, I started developing a set of scripts to help me gather and summarize that information…

Read more

3 comments, 339 reads

Posted in SQL Awesomesauce on 30 September 2013

Interviews with Great SQL People – Authors, MVPs, many more

I’m trying really hard to write a blog that goes over all the great #sqlpass interviews we’ve done, but work keeps happening. Pfft. If you didn’t know, we interview great folk at #sqlpass: @ItzikBenGan, @SQLRunr, @brianknight, @billramo, @GFritchey & more in 2009… Interviewed @mrdenny, @sirsql, @gfritchey, @way0utwest, @mark_AzureCAT at #sqlpass…

Read more

0 comments, 301 reads

Posted in SQL Awesomesauce on 27 September 2013

SQL Tip: Get Log Space with DBCC SQLPERF(LOGSPACE)

Every so often I’m reminded that the “basics” aren’t really basics. None of us go to take “How to be a Microsoft SQL Server DBA 101″ before our first gig. So for your perusal, use and enjoyment: here is the easiest way to get a report on log space usage:…

Read more

1 comments, 367 reads

Posted in SQL Awesomesauce on 19 September 2013

Hit Fast Forward: Converting and deploying DTS packages

This one is just a quick shout-out to Pragmatic Works, and to Sean. Pragmatic Works made DTS xChange, which I used to convert about 40 SQL Server 2000 DTS packages to SSIS. Seriously, I just had to run the thing, and update a few data connections.  YMMV, of course, but…

Read more

0 comments, 238 reads

Posted in SQL Awesomesauce on 19 September 2013

#TribalSQL: A new book by new voices in SQL Server

Two years ago, we were talking about how cool it would be to get a bunch of unpublished authors to write about what they thought was important about databases. You know, tribal knowledge. So we sent out a call for abstracts and got the ball rolling on one of the…

Read more

2 comments, 262 reads

Posted in SQL Awesomesauce on 17 September 2013

PASS Summit 2013 Schedule

Each year, I like to compile my own shortcut, cheat sheet version of the PASS Summit schedule. I’m not talking about the actual session schedule – we (will) have a perfectly good schedule builder on sqlpass.org, so that’s covered. I’m talking about social events, luncheons, keynotes, parties, special days…pretty much…

Read more

1 comments, 410 reads

Posted in SQL Awesomesauce on 10 September 2013

A Short Treatise on Studying (#mcmstudy)

So I’m studying a lot these days, and I find myself evaluating and reconsidering the theories of “study” that I’ve been picking up all the way back since grade school. Here is what seems to work best for me, whether I’m learning something new, or reviewing something I “know”: Develop/revise…

Read more

0 comments, 262 reads

Posted in SQL Awesomesauce on 9 September 2013

A Better Braindump (#mcm #mcmstudy)

I’m studying my butt off for the soon-to-be-deprecated Microsoft Certified Master cert’s lab – and the three unfinished prerequisite certs I’ve been putting off since 2008* – and I’m not using braindumps. I just wanted to brain dump HERE a bit. (And btw, you can follow my mid-study ramblings on…

Read more

0 comments, 323 reads

Posted in SQL Awesomesauce on 5 September 2013

Terminal #MCM – 30 days to go

We just finished the webshow last night, when one of our chatroom fellows – Nic Cain – told us that the MCM and MCA programs were dying. He almost immediately blogged the news: MS was canceling the Microsoft Certified Master and Microsoft Certified Architect programs, and it was all up…

Read more

6 comments, 277 reads

Posted in SQL Awesomesauce on 31 August 2013

“Unraveling Tangled Code” recording and downloads!

Last weekend I gave my “Unraveling Tangled Code” talk at SQL Saturday Oklahoma, and they were kind enough to record and post the session over on UserGroup.TV!  You can get the slide deck and demo code here. This session stemmed from the recurring nightmare that is undocumented, unsupported code that…

Read more

0 comments, 263 reads

Posted in SQL Awesomesauce on 30 August 2013

Authority as the Enemy: Notes on elections and perceptions in the tech community

Let’s hear a story. The story is true, but elements have been generalized and fictionalized for simplicity, and so’s not to call out any individuals. This story has happened several times, you see. Story Time A few years ago, an election was held for positions on the PASS* board. Several…

Read more

3 comments, 296 reads

Posted in SQL Awesomesauce on 23 August 2013

Social Media as News (and why it thrills me)

The other day I found myself in a discussion about media – print, broadcast, and social – and having to explain why I thought live coverage via social media, by individual eyewitnesses, is a wonderful thing. The room more or less agreed that print media is on the way out.…

Read more

0 comments, 256 reads

Posted in SQL Awesomesauce on 14 August 2013

Summer absences, upcoming appearances, and…

It’s summer here in the northern hemisphere, and in Texas we’re getting 100F-plus weather pretty consistently. This brain-frying weather may help to explain how I managed not to bother letting anyone here on the Interwebs know that we were taking most of July and some of August off from all…

Read more

0 comments, 232 reads

Posted in SQL Awesomesauce on 12 August 2013

TRY, CATCH, and Transactions

The T-SQL TRY/CATCH structure (“new” in SQL 2005!) is, as the professionals say, da bomb. It’s also underused and under-understood, so let’s talk about the basics. (Or, you can skip to the summary at the end.) A group of Transact-SQL statements can be enclosed in a TRY block. If an…

Read more

5 comments, 971 reads

Posted in SQL Awesomesauce on 20 June 2013

Why should we upgrade off of SQL Server 2000?

A good many companies still have servers chugging along on SQL Server 2000 (or even, as some of us noted on Twitter, SQL Server 7.0 and 6.5) . If you’re one of those companies, and you’ve never had a problem with it, why should you upgrade?1, stability: It’s completely out…

Read more

5 comments, 457 reads

Posted in SQL Awesomesauce on 13 June 2013

We’re speaking at PASS Summit 2013!

PASS liked our “Mouth Wide Shut” interviewing session from last year so much that they’ve decided to have us back for part two: Mouth Wide Shut: Interviews from the Other Side of the Table. This is our brand-spanking-new session for the interviewERs…those who question, vet, and rant about it afterward.…

Read more

0 comments, 225 reads

Posted in SQL Awesomesauce on 22 May 2013

My 2013 SQL Saturday Schedule!

I’ve finally gotten my gear together for (what I consider) the “speaking season”. Here are the SQL Saturdays that I’m speaking at, or that I’ve submitted to, or are considering submitting to! I’ll update this list as plans solidify: 5/18/2013 – Atlanta - Scheduled to speak. 8/3/2013 – Baton Rouge…

Read more

0 comments, 314 reads

Posted in SQL Awesomesauce on 16 May 2013

Use Powershell to find and punish – er, delete – rogue files

I like to know what’s on the drives that are supposed to be dedicated to data and log files. So I run a quick check of sys.master_files: SELECT LEFT(physical_name, 1) as Drive, SUM(size)*8/1024 as SizeMb FROM sys.master_files GROUP BY LEFT(physical_name, 1) ORDER BY Drive; And then I compare the numbers…

Read more

0 comments, 693 reads

Posted in SQL Awesomesauce on 13 May 2013

Newer posts

Older posts