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 […]
Atlanta SQL Saturday PreCon
At the upcoming SQL Saturday in Atlanta, GA I have the honor of delivering a precon on database security which has several seats still available. This precon is a full day session where we will be talking about all the security best practices. Signing up for the precon is pretty simple, just do to the […]