SQL Server with Mr. Denny:

May, 2013

1

May 28, 2013  4:27 PM

Extra Bytes Per Row With AlwaysOn Availability Groups



Posted by: Denny Cherry
AlwaysOn, Database Administration, Execution Plans, Index, Index Performance, Index Seek, Indexing, SQL Server, SQL Server 2012

One of things to keep in mind with SQL Server 2012 AlwaysOn Availability Groups is that when the availability group has readable secondary replicas any...

May 24, 2013  5:04 PM

Recommended reading from mrdenny for May 24, 2013



Posted by: Denny Cherry
SQL Server, Top 10

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.

Bookmark and Share     0 Comments     RSS Feed     Email a friend


May 22, 2013  2:00 PM

The Optimizer Isn’t As Smart As You Might Want It To Be



Posted by: Denny Cherry
Database, Database Design, Index Performance, Performance, Performance Problems, Problems, SELECT statement, SQL Server, SQL Server 2008 R2, Stored Procedures, T/SQL, Tables

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...


May 17, 2013  5:04 PM

Recommended reading from mrdenny for May 17, 2013



Posted by: Denny Cherry
SQL Server, Top 10

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.

Bookmark and Share     0 Comments     RSS Feed     Email a friend


May 15, 2013  2:00 PM

Error Handeling and DBCC CHECKDB



Posted by: Denny Cherry
Database Administration, Error Message, ERRORLOG, SQL Server, SQL Server stored procedures, Stored Procedures

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...


May 5, 2013  2:38 PM

Two Factor Authentication Shouldn’t Depend on One Factor



Posted by: Denny Cherry
Bank of America, Data Security, Security, Social Commentary, SQL, SQL Server, Technology, Two Factor Authentication

Bank of America has decided to implement two factor authentication on their website when doing specific things like adding a remote...


May 3, 2013  10:25 AM

Atlanta SQL Saturday PreCon



Posted by: Denny Cherry
In Person Events, SQL, SQL PASS, SQL Server, T/SQL

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...


May 1, 2013  2:00 PM

I’m using simple recovery, so the log file isn’t important right?



Posted by: Denny Cherry
Bulk Logged Recovery Model, Database Administration, Full Recovery Model, Manageability, Recovery Model, Simple Recovery Model, SQL Server, Storage, Transaction Log

One of the big myths of SQL Server resolves around the transaction log, and how it's used with the simple recovery model. Many people think that...


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: