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

Create a clustered index and a primary key on existing tables

It’s the simple things in life that can trip people up. I find that creating primary keys and clustered indexes on existing tables is one that newish DBAs tend to trip up on, and so (like I do), I shall blog about it so there’s a nice, clear, explicit reference…

Read more

0 comments, 149 reads

Posted in SQL Awesomesauce on 15 December 2014

Just an idea: Bare Bones SQL

I’m reading Andy Warren’s excellent essay “Thoughts on raising funds and spending funds for PASS chapters”, and it’s bringing together a bunch of long-stewed thoughts. Simply: What if there’s room for “Bare Bones” SQL user groups? The bare bones basics of Bare Bones SQL For those who don’t want to…

Read more

13 comments, 300 reads

Posted in SQL Awesomesauce on 13 November 2014

Session: Introduction to Powershell Cmdlets for DBAs

I’ve given my new Powershell Cmdlets for DBAs session a handful of times now, and just realized I haven’t blogged about it! Download the session recording here Download the code file here Abstract: You’ve been hearing about this newfangled craze, and it’s time to learn exactly why it’s called POWERshell.…

Read more

1 comments, 231 reads

Posted in SQL Awesomesauce on 28 October 2014

Minion Reindex is here

We released Minion Reindex by MidnightDBA unto the world, accompanied by a press release on SQLServerCentral.com, and people have responded so incredibly positively. We’re quite literally thrilled. Webinar Today! Before I get to anything else: set up an alert for our Minion Reindex Intro Webinar TODAY (Monday, October 27, 2014)…

Read more

0 comments, 220 reads

Posted in SQL Awesomesauce on 27 October 2014

Minion Reindex arrives this Friday!

Edit: Minion Reindex has arrived, and it’s getting fantastic notes! The MidnightDBA team is announcing the release of a new, free index maintenance solution for SQL Server: Minion Reindex by MidnightDBA.  We designed Minion Reindex to solve all of the reindexing headaches we’ve experienced at dozens and dozens of client…

Read more

0 comments, 285 reads

Posted in SQL Awesomesauce on 20 October 2014

PASS Summit 2014: Recommendations and Invitations (#sqlpass #Summit14)

The first week of November, we’ll be at the PASS Summit inSeattle, WA.  This is the highlight of most SQL Server speakers’ years…a sort of educational, Christmassy nerdfest, with a feel of a class reunion mixed in. We have a lot of fun, and so I’d like to draw your…

Read more

1 comments, 182 reads

Posted in SQL Awesomesauce on 10 October 2014

Tip: Concatenate rows with XML, or COALESCE

Edit: I went and changed the first query without paying close enough attention. I’ve fixed the explanation and the query. Concatenate rows with XML I still reference my Forgotten T-SQL Cheat Sheet, especially for the XML trick that turns a set of rows into a list. The T-SQL Cheat Sheet…

Read more

1 comments, 249 reads

Posted in SQL Awesomesauce on 8 October 2014

Wendy Pastrick and Grant Fritchey: Optimists in Action #passvotes

If I had a favorite kind of politician, it would be the kind that, when asked a question, sighs tiredly, and then regains their gleam of manic optimism as they begin to speak about the path ahead. Given that, my two favorite politicians right now are Wendy Pastrick and Grant…

Read more

1 comments, 197 reads

Posted in SQL Awesomesauce on 19 September 2014

Tip: RECOVERY_PENDING is not the same as RECOVERING

I’ve seen this mistake more than once, from DBAs with a middling to fair amount of experience. So it bears repeating. RECOVERY_PENDING is very different from RECOVERING. Definitions RECOVERING means that things are happening, and all may be well. “Database is being recovered. The recovering process is a transient state;…

Read more

1 comments, 326 reads

Posted in SQL Awesomesauce on 8 September 2014

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, 196 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, 218 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, 401 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, 834 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, 192 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, 355 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, 379 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, 209 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, 230 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, 404 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, 276 reads

Posted in SQL Awesomesauce on 20 March 2014

Older posts