SQL Server with Mr. Denny:

SQL


October 2, 2012  2:37 PM

The Hotel Excelsior Dubrovnik needs to actually provide what they offer



Posted by: Denny Cherry
Hotel Excelsior Dubrovnik, SQL, Travel

So for the last couple of weeks Kris and I have had the pleasure of being in Croatia, first for a SQL Conference second to spend a few days on vacation for our 13th Wedding Anniversary. The SQL conference in Zagreb was great, I don't have a single complaint about the hotel, the conference, the...

August 29, 2012  9:00 AM

Creating PDF Files From Any Application



Posted by: Denny Cherry
PDF, SQL

These days creating PDF files is getting easier and easier, especially when you are using a Microsoft Office application like Word, Excel, PowerPoint, etc. to create the initial document.  However all too often you want to create a PDF file from another application like Firefox, Chrome, IE,...


August 9, 2012  2:00 PM

Second Edition of Securing SQL Server now longer available for pre-order. It’s Shipping! (repost)



Posted by: Denny Cherry
AlwaysOn, Availability Groups, Azure, Data Loss, Data Security, Database Administration, Database security, Microsoft Windows, Security, SQL, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, Storage

In case you missed the blog post over on securingsqlserver.com, I wanted to repost it here... I'm afraid that I've got some bad news.  You can no longer pre-order


August 2, 2012  4:00 PM

Sensitive Data Must Be Encrypted



Posted by: Denny Cherry
Data Encryption, Data Loss, Data Security, Database Administration, Database Design, Database security, Encryption, Exploit, Hashing, Security, SQL, SQL Server

The title of this post pretty much says it all.  If you store sensitive data in a database you have to work under the assumption that someone is going to try and break into the system and steal that data.  Thinking otherwise simply isn’t responsible as the developer and/or administrator of the...


July 30, 2012  4:00 PM

Why is SQL Injection still a problem?



Posted by: Denny Cherry
Data Loss, Data Security, Database Administration, Database security, Exploit, Security, SQL, SQL Server

SQL Injection is probably the most popular attack vector for hackers when they attempt to break into databases.  The reason for this is that it is so easy for an attacker to gain access to the system, and typically to get pretty high level permissions to a database engine so that they can then...


July 19, 2012  2:00 PM

Making Technical Writing Easier



Posted by: Denny Cherry
Microsoft Word, SQL, SQL Server, Writing

Those of us that have worked on books have probably all run across the same problem at one time or another.  When you are going through the book writing process, you always end up going back and wanting to add a code example, or a screenshot somewhere in the middle of the chapter, and you then...


July 5, 2012  6:31 PM

VMworld needs to provide more feedback to session submitters



Posted by: Denny Cherry
Database, SQL, SQL Server, Tech Ed, vCenter, Virtualization, VMware, VMworld, VMworld 2012, vSphere 5.0

I've submitted a lot of sessions to a lot of conferences over the years.  And while the feedback from some of the conferences is a little cryptic thanks to the review team only having access to canned responses, it'll do.  Now personally I'd love to get specific feedback saying exactly why my...


February 6, 2012  2:00 PM

Drying Out a Wet Laptop



Posted by: Denny Cherry
Distaster Recovery, Laptop, SQL, SQL Server

The other day I had a VERY unpleasant situation happen.  I managed to dump a basically full 64oz (1.8 liter) cup of iced tea all over my desk.  In theory this shouldn't be a problem but it landed right on top of one of my laptops.  Thankfully the laptop was off but it was plugged in when this...


December 28, 2009  11:00 AM

How to convert a standalone instance to a clustered instance



Posted by: Denny Cherry
Clustering, SQL

This question has come up a couple of times on various forums on the Inter-webs so I figured I'd write up something a little more in-depth than I'd be able to do on a forum. There's no way to easily flip a standalone SQL Server instance to a clustered instance.  However moving a standalone...


December 17, 2009  11:00 AM

CXPacket isn’t the cause, it is a symptom



Posted by: Denny Cherry
SQL

All to often when people deal with parallel queries they see that some threads of the query have a wait type of CXPacket so they assume that the parallel execution plan is causing a problem, but it probably isn’t.