SQL Server with Mr. Denny:

July, 2012


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 26, 2012  2:00 PM

Security Sessions at SQL PASS 2012

Posted by: Denny Cherry
Data Encryption, Data Loss, Data Security, Database, Database Administration, Database Design, Database security, Encryption, Security, SQL Injection, SQL PASS, SQL PASS 2012, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012

The SQL PASS session list for the SQL PASS 2012 Summit has been released.  This year there are 192 sessions being presented at the SQL PASS summit.  Last year at the 2011 summit there were only a couple of sessions...

July 23, 2012  2:00 PM

SQL Saturday 147 Precon (#sqlsat147)

Posted by: Denny Cherry
AlwaysOn, Availability Groups, SQL PASS, SQL PASS 2012, SQL Saturday, SQL Saturday 147, SQL Server

If you are planning on attending SQL Saturday 147 down in Recife Brazil you would check out my pre-con session being held on August 24th.  In this session I'll be talking about all of the High Availability options which are available for SQL Server...

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 16, 2012  2:00 PM

Stop Using SQL Logins

Posted by: Denny Cherry
Database security, Security, SQL Server

Hey vendors, consultants, clients, etc. STOP USING SQL LOGINS.  Now if the SQL Server you are using isn't attached to a Windows domain then fine, odds are you'll need a SQL Authentication login.  However if the machine is a member of the Windows domain then login to SQL Server using Windows...

July 12, 2012  2:00 PM

PBM, Replication and Stored Procedure Names

Posted by: Denny Cherry
Replication, SQL Server, SQL Server 2008 R2, SQL Server 2012, System Objects

One of the things that Policy Based management is really good at is making sure that people don't create stored procedures that start with "sp_".  However when the server that you are deploying the policies to is also being used for SQL Server replication this can get a little more complex seeing...

July 9, 2012  6:20 PM

Windows 2012 Dates Announced

Posted by: Denny Cherry
Microsoft Windows, SQL Server

It appears that Microsoft has released the dates for RTM (Release To Manufacturing) and GA (General Availability) for both the Windows 2012 Server and Client Operating Systems. Both the client and server with RTM the first week in August with the server OS will be available in September and the...

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

July 5, 2012  2:00 PM

Prepping the security for a data warehouse

Posted by: Denny Cherry
Active Directory, Database security, Permissions, SQL Server

So in an earlier blog post I talked about how I had to grant some users the ability to create indexes in a reporting server.  A couple of people have asked me how I created the domain...

July 2, 2012  2:00 PM

Giving users the ability to create indexes

Posted by: Denny Cherry
Index Performance, SQL Server

So I ran across a pretty interesting requirement when setting up a new reporting database server.  The end users who run queries against the databases on this server are pretty good at performance tuning their own queries so they wanted the ability to create indexes on the tables on the reporting...


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: