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

Minion Reindex arrives this Friday!

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 sites. The Bottom Line Your databases need index maintenance for…

Read more

0 comments, 58 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, 139 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, 210 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, 170 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, 299 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, 171 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, 191 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, 356 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, 799 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, 167 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, 335 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, 322 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, 172 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, 211 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, 336 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, 252 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, 932 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, 399 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, 187 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, 267 reads

Posted in SQL Awesomesauce on 14 March 2014

Older posts