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

Archives: March 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, 156 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, 181 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, 286 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, 226 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, 899 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, 364 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, 167 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, 242 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, 197 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, 195 reads

Posted in SQL Awesomesauce on 3 March 2014