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

MidnightDBA at SQL Saturday Houston – May 10

Sean and I will be speaking at SQL Saturday Houston on May 10, at San Jacinto College – South Campus 13735 Beamer Rd. Building 12 Houston, TX 77089 We have three sessions between the two of us: T-SQL Code Sins, Jen DBA Career Roadmap, Sean and Jen DIY Performance Reporting,…

Read more

0 comments, 96 reads

Posted in SQL Awesomesauce on 14 April 2014

Heartbleed bug: immediate security threat for both IT, and consumer sites and services

“An encryption flaw called the Heartbleed bug is already being called one of the biggest security threats the Internet has ever seen. The bug has affected many popular websites and services — ones you might use every day, like Gmail and Facebook,” says this Mashable article. This thing MUST be…

Read more

0 comments, 222 reads

Posted in SQL Awesomesauce on 10 April 2014

Decree: Set your partition offset and block size – make SQL Server faster

If I’ve said it once, I’ve said it 1,024 times: your SQL data and log drives need a 1024 KB starting offset, and a 64 KB block size*. Your SQL data and log drives need a 1024 KB starting offset, and a 64 KB block size. If you read this…

Read more

3 comments, 126 reads

Posted in SQL Awesomesauce on 7 April 2014

GetLogSpace – table and stored procedure

We’ve talked before about how to get log space usage information in SQL Server.  After the 1,032nd time I re-wrote my custom query to also see the UNused log space, it occurs to me that this would be a nice thing to have on your server on a permanent basis.…

Read more

3 comments, 101 reads

Posted in SQL Awesomesauce on 31 March 2014

SQL Saturday Oklahoma City precon: Becoming an Enterprise DBA

We’ll be at OKC this summer for their SQL Saturday on August 23, and we’re presenting our precon “Becoming an Enterprise DBA” August 22!.  Get your early bird ticket by July 15, and save over 15%! Precon: Becoming an Enterprise DBA August 22, 2014, Norman Technology Center, Moore OK There’s…

Read more

0 comments, 120 reads

Posted in SQL Awesomesauce on 26 March 2014

The case for SQL Server 2012 Enterprise (vs. Standard) edition

In celebration of the impending SQL Server 2014 release, and in recognition that a large percentage of my clients are on that cusp of the Standard/Enterprise licensing decision for the currently available version…let’s talk about SQL Server 2012! Specifically, why Enterprise edition might be a huge advantage – or even…

Read more

5 comments, 188 reads

Posted in SQL Awesomesauce on 24 March 2014

InfoWorld Review: SQL Server 2014, by Sean McCown

InfoWorld Magazine (http://www.InfoWorld.com) has published a new article by MidnightSQL owner Sean McCown, “Review: SQL Server 2014 pushes the pedal to the metal”. The article announces the upcoming release of Microsoft SQL Server 2014 – due out on April 1, 2014 – and reviews some of the top new features.…

Read more

0 comments, 147 reads

Posted in SQL Awesomesauce on 20 March 2014

The problem with PASS Summit abstracts (and submissions and selection and notification and…)

The problem with the PASS Summit session submissions process is that people don’t know why they’re rejected. So say we all. Speaking at PASS I say with confidence “so say we all”, because of a massive Twitter conversation this morning on the topic. If you’re not familiar with it, the…

Read more

6 comments, 768 reads

Posted in SQL Awesomesauce on 19 March 2014

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, 237 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, 109 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, 179 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, 136 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

3 comments, 115 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, 191 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, 169 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, 116 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, 195 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

3 comments, 168 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, 172 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, 153 reads

Posted in SQL Awesomesauce on 13 January 2014

Older posts