SQL Server with Mr. Denny:

SQL


February 12, 2014  2:00 PM

How Much Is That Query Costing?



Posted by: Denny Cherry
Database Administration, Execution Plans, Indexing, SQL, SQL Server

When we think about the cost of the query we typically think about the cost which SQL Server assigns to execute the query. However when we look at performance tuning queries there is another cost that we need to think about. This additional cost is the cost to the company while the query is...

February 5, 2014  2:00 PM

I Want This Project Done Properly, Done Quickly, and Done Cheap



Posted by: Denny Cherry
Consulting, Social Commentary, SQL, SQL Server

This is the standard requirement that I get from a lot of clients. Sadly those three requests aren't going to go well together. In IT (and really in anything) you have to pick two:

  • Done Properly
  • Done Fast
  • Done Cheap


January 29, 2014  10:42 PM

eForensics Magazine SQL Server Issue



Posted by: Denny Cherry
SQL, SQL Server

The digital magazine "eForensics Magazine" has put together their 1st issue talking specifically about SQL Server security.  There are articles written by a bunch of SQL Server experts...


January 22, 2014  7:00 PM

Changing your Password on Windows 2012 via RDP



Posted by: Denny Cherry
Change Password, Data Security, Microsoft Windows, Security, SQL, SQL Server, Windows 2012, Windows 2012 R2

I ran into a problem at a client recently that I'm shocked that I haven't run across before. I...


January 15, 2014  2:00 PM

Fixing TempDB database problems when starting SQL using a minimum config



Posted by: Denny Cherry
Data Loss, Database, Database Administration, SQL, SQL Server, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, T/SQL, TempDB

So the other day I typo'ed something. Usually this isn't that big a deal, but in this case when fixing tempdb for a customer I told SQL to put two logical files into the same physical file. I was able to get it to let me do this because I first added the files, then realized that I had put them...


January 3, 2014  2:00 PM

Recommended Reading from mrdenny for January 3, 2014



Posted by: Denny Cherry
SQL, 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.


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: