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

Parameterization – A quick note on a CSS SQL article

I just finished reading an excellent CSS article, How Simple Parameterization works, which is well written and well worth a look. In short, it outlines a customer performance issue caused by a change in the query plan – from parameterized to unparameterized – and a few considerations on resolving it.…

Read more

0 comments, 241 reads

Posted in SQL Awesomesauce on 18 December 2013

Scalzi’s Law of Cleverness, as applied to resumes

John Scalzi (blog, Twitter) – science fiction writer, Hugo award winner, philosopher, and blogger extraordinaire – has an adage that I wish to formally declare a law, in my power as a rather less prolific blogger and a fellow human being. Scalzi’s Law goes like this: The failure mode of…

Read more

0 comments, 288 reads

Posted in SQL Awesomesauce on 16 December 2013

What a DBA wants for Christmas

In the first few years of ITBookworm.com, we made sure to make up holiday lists of the most awesome gadgets and software that we’d reviewed that year. In recent years, we’ve focused more and more on MidnightDBA, and now on MidnightSQL consulting, leaving us a lot less time for reviewing…

Read more

2 comments, 297 reads

Posted in SQL Awesomesauce on 12 December 2013

Be a Brilliant DBA

John Sanson (b|t) recently asked a bunch of us, “If you could give a DBA just one piece of advice, what would it be?”  This post is my answer! This, and other articles like it, is available as a downloadable FREE e-book – DBA Jumpstart - at http://www.johnsansom.com/dba-jumpstart/ Grab your…

Read more

3 comments, 287 reads

Posted in SQL Awesomesauce on 10 December 2013

#TribalAwards with RedGate!

You know what? You’re doing a good job. You’re reading blogs, and that’s generally the sign of a person wanting to learn more about their craft. Well done, you. (And doubly well done for reading my blog, with also shows that you’re intelligent, attractive, and many other positive things.) You…

Read more

0 comments, 230 reads

Posted in SQL Awesomesauce on 9 December 2013

It sure would be grand to have interesting interviews

Coincidentally, in a week of debate and thinking and writing on IT interviews and candidates, XKCD has gifted us with something beautiful: a comic about an interview more interesting than any I’ve ever heard. Enjoy. Happy Friday, Jen McCown http://www.MidnightDBA.com/Jen

Read more

0 comments, 279 reads

Posted in SQL Awesomesauce on 22 November 2013

What should a candidate know about your company?

I had a great comment (Ryan McCauley’s) on yesterday’s post that led to a great conversation on Twitter. The comment mentioned a phone screen candidate that was turned down out of hand, because the guy didn’t know what the company did. I personally think that what a candidate (especially in…

Read more

6 comments, 1,493 reads

Posted in SQL Awesomesauce on 19 November 2013

How to Fail a Phone Screen

It’s funny to me how easy it is to fail a phone screen – both as the interviewer, and as the interviewee – especially considering the fact that the purpose of a phone screen is to determine whether a candidate is worth bringing in for an interview.  That’s a pretty…

Read more

6 comments, 3,444 reads

Posted in SQL Awesomesauce on 18 November 2013

Compare tables to find missing rows

Let’s talk about the case where you want to compare tables to see what’s missing. We might be comparing a list of orders to an imported set of data in a staging table. Or, we’re identifying customers in the database that aren’t on the call list. Whatever the application, finding…

Read more

3 comments, 434 reads

Posted in SQL Awesomesauce on 14 November 2013

Quick note: Redgate SQL Data Compare using the command line

I’ve been working on an automated data compare process for one client.  I’ve been struggling a little with odd hangups and errors with the SQL Data Compare command line interface, but one particular StackOverflow post solved my final problem. So here’s the final solution: Create a data compare project using…

Read more

0 comments, 504 reads

Posted in SQL Awesomesauce on 22 October 2013

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, 197 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, 255 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, 412 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, 368 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, 405 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, 260 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, 286 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, 479 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, 297 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, 348 reads

Posted in SQL Awesomesauce on 5 September 2013

Newer posts

Older posts