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

This Week in Awesome – Running at PASS, Cookie Jail, SQL Sats, Breakfast

If you’re in Seattle the week of November 2 – say, for example, you’re attending the PASS Summit that week - consider signing up for the #SQLLongRun:  “We’ll do a minimum of 11 miles. Why? Because we can.” There is now a locking, time-release cookie jar. I should….I should probably…

Read more

0 comments, 80 reads

Posted in SQL Awesomesauce on 30 July 2014

The Week in Awesome – Plugins, Cars, Food, and France

This week in awesome: Denny Cherry – our own @mrdenny – has created a Password Vault WordPress plugin. That looks seriously cool. Google has created a prototype of a totally self-driving car. It looks like a toy, but feels like the future. As long as we’re talking about cars, go…

Read more

0 comments, 152 reads

Posted in SQL Awesomesauce on 30 May 2014

Applied SQL: Orphan a user, fix orphaned users (sp_FixOrphanedUsers)

Ever heard of orphaned users? It’s a database user account, disconnected from its associated login. You typically get this when you take a database backup, and restore it to a different server. Microsoft provides us with the ever helpful sp_change_users_login to find and repair orphaned users, but even so, it’s…

Read more

2 comments, 298 reads

Posted in SQL Awesomesauce on 5 May 2014

Video: Designing Stored Procedure Solutions

My new session for 2014, “Designing Stored Procedure Solutions”, is now up on the Sessions page: abstract, video, and code! This month, I gave this session at the Oklahoma City SQL Server User Group‘s 5 year anniversary, and at the Alaska SQL User Group, to thousands and thousands* of attendees…

Read more

1 comments, 734 reads

Posted in SQL Awesomesauce on 28 April 2014

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, 147 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, 304 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, 252 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, 145 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, 168 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, 268 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, 208 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, 877 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, 337 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, 154 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, 228 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, 187 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, 172 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, 244 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, 217 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, 159 reads

Posted in SQL Awesomesauce on 10 February 2014

Older posts