The Optimizer Isn’t As Smart As You Might Want It To Be
A little while back I got one of those phone calls. You know the one, the lovely 6am phone call about random performance problems. There were two problems that night. One which I’ll talk about later in another post, the second one which I want to talk about today. The query that was having problems […]
Recommended reading from mrdenny for May 17, 2013
This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week. Common Table Expressions (CTEs), Window Functions, and Views How big of a risk is BYOD? How can I get that user out of my table quickly Unemployed Chinese Graduates Say No Thanks […]
Error Handeling and DBCC CHECKDB
A client that I’ve been working at for a while needed to start doing DBCC CHECKDBs on their production server. We hadn’t been for a little while due to maintenance window constraints on their old production server. Now that we’ve scaled the application across 6 different servers we can now do DBCC CHECKDB on the […]
Two Factor Authentication Shouldn’t Depend on One Factor
Bank of America has decided to implement two factor authentication on their website when doing specific things like adding a remote account to transfer money to, or when doing a wire transfer (basically anything where money is going to leave the account). So far this sounds like an excellent plan. The second factor is that […]