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

Breaking: SQL Server 2014 RTM in two weeks

Today, MSDN and TechNet are reporting that SQL Server 2014 will be available on April 1, 2014. Thanks to @MariaZakourdaev, who posted the news early this morning on Twitter: So exiting!!! On April 1st SQL 2014 will be available!! — Zakourdaev Maria (@MariaZakourdaev) March 18, 2014 This release looks like…

Read more

2 comments, 427 reads

Posted in SQL Awesomesauce on 18 March 2014

Tip: COLLATE for “Cannot resolve collation conflict” error

Some data professionals are VERY well versed with collation, and some never ever have to touch the concept. That second group tends works in shops that leave everything on default.  A huge portion of my career has been spent as a member of that “Custom collation? What custom collation?” crowd,…

Read more

2 comments, 205 reads

Posted in SQL Awesomesauce on 17 March 2014

SQL for Everybody

I read a terribly excited blog this morning by a guy who had just discovered Alt-F1 in SSMS. (If you don’t know, it runs sp_help on the highlighted object.)  My very, very first instinct – I’m ashamed to say – was to think “Who doesn’t know about that?” That’s not…

Read more

0 comments, 281 reads

Posted in SQL Awesomesauce on 14 March 2014

Bad Ideas: Alert Storming

Fellow DBA: There are so many alerts! It takes me a long time to get through them all. How do you filter through them? Me: That’s called “alert storming”, and it’s bad for that exact reason. Alerts are like money: People always seem to have way too little, or way…

Read more

0 comments, 231 reads

Posted in SQL Awesomesauce on 10 March 2014

Configure static or dynamic IP and DNS with Powershell

I work in a lot of different offices and conference venues, in addition to my home office. At home, I need a static DNS server address; everywhere else, it has to be dynamic. Tired of the click-click-clickety-click it takes to set, unset, and reset my network adapter settings, I went…

Read more

5 comments, 241 reads

Posted in SQL Awesomesauce on 3 March 2014

Expiration dates: SQL Server 2008 and 2008 R2

SQL Server is a software product, right? And software has a history of having bugs, getting updates, and having support for when things go wrong. If you’re not already aware, now is a good time to become aware that: SQL Server has an expiration date Okay, officially it’s not an…

Read more

1 comments, 278 reads

Posted in SQL Awesomesauce on 24 February 2014

Home Workspace: Standing Desk

Ever since I worked in an office with adjustable standing desks, I’ve been thinking about getting a standing desk for the home office.  The thing is, they’re a little expensive. Last month, inspired by Buck Woody’s most recent stand-up desk setup, I finally put together a beautiful standing desk for…

Read more

0 comments, 249 reads

Posted in SQL Awesomesauce on 17 February 2014

What’s the CPU usage on the server? Use #Powershell!!

We have here an easy, handy-dandy way to find out how much CPU is in use on your server. Of course you can find out by opening up task manager, or by running perfmon, but that’s not really the point. We want something quick and easy. We want something we…

Read more

0 comments, 207 reads

Posted in SQL Awesomesauce on 10 February 2014

Blockades and ladders to learning new tech

It’s been a long time since I’ve been a true newbie to a technology. There are plenty of things I don’t use, don’t know, wouldn’t be able to do for a job, of course. But as a professional and a consultant, most of what you do is at least remotely…

Read more

4 comments, 286 reads

Posted in SQL Awesomesauce on 3 February 2014

Applied SQL: LIKE ‘whatever’

Today let’s play around with the LIKE operator. Like, totally. Like, Introduction Like “determines whether a specific character string matches a specified pattern. A pattern can include regular characters and wildcard characters.” That makes it pretty darn useful, say, when we’re searching for all product reviews with the word “worst”…

Read more

4 comments, 272 reads

Posted in SQL Awesomesauce on 27 January 2014

Tip: Jobs without a scheduled run

It’s awfully comforting to see all those backup and maintenance jobs in your SQL Agent list, isn’t it? It’d be a shame if, you know, they never ran. Where do we keep our job information? In MSDB tables: Your jobs are listed in dbo.sysjobs. Schedules are in dbo.sysschedules. The table…

Read more

2 comments, 246 reads

Posted in SQL Awesomesauce on 22 January 2014

Protesting government web surveillance: Feb 11 Blackout

We at the MidnightDBA compound* believe firmly in the right to privacy, and so have watched with dismay over the last few years as online privacy has taken a giant, flaming nosedive into the land of Big Brother Is Actually a Thing Now. As always, I am heartened and pleased…

Read more

0 comments, 204 reads

Posted in SQL Awesomesauce on 13 January 2014

Applied SQL: Find and replace using regular expressions in SSMS

Regular expressions are searches on steroids, the wildcats of the wildcard world*.  Even if you  never ever write CLR, regex (as it’s affectionately known) can be useful to you today, right now. Open a new query window in SQL Server Management Studio. Type “xyz”, hit enter twice, and type “xyz”…

Read more

2 comments, 395 reads

Posted in SQL Awesomesauce on 10 January 2014

Clarity in T-SQL: Adjoining Socks

One of my children is very literal, a true pedantic. “Is there any homework you need to do?” “No.” “Really? Show me your homework sheet. … Why does it say ‘book report due’ for tomorrow?” “Because the report is due tomorrow.” [Deep breath.] “So why did you JUST tell me…

Read more

0 comments, 270 reads

Posted in SQL Awesomesauce on 4 January 2014

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, 222 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, 270 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, 275 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, 270 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, 210 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, 259 reads

Posted in SQL Awesomesauce on 22 November 2013

Newer posts

Older posts