SQL Server

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

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

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

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

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 the simple recovery model doesn't use the transaction log.  More specifically they think that it's there because it has to be there, but that SQL...

Recommended reading from mrdenny for April 26, 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.

• What is 360° view of a Customer?

Write about what you care about. If you do the page views will happen.

Ask any SEO "expert" and they'll tell you to write stuff that'll get you lots of page views, to use key words to lure people in.  The problem with this approach is that you end up not writing about the stuff that people want to read week over week, month over month. Now getting people to show...

Recommended reading from mrdenny for April 19, 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.

• Understanding When Statistics Will...

Advertising != Engaging

Some people just really don't get social media. Recently a twitter account which belongs to a SQL Server training company who based on their website is a legit company. In what I can assume was supposed to be an advertising campaign they completely ruined their social media standing, and in 7...

Recommended reading from mrdenny for April 12, 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.

• Uneven query executions with parallelism

Using your US Phone in Europe Without Going Broke

There are lots of horror stories of people going to Europe on vacation or on business and coming home to massive cell phone bills. Even if you know that you are going to be paying a lot it's really easy to end up with a few hundred dollar international roaming cell phone bill. There are thankfully...