SQL Server with Mr. Denny:

SQL


July 23, 2012  2:00 PM

SQL Saturday 147 Precon (#sqlsat147)

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

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

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

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

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

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

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

One of the things that Policy Based management is really good at is making sure that people don't create stored...


July 9, 2012  6:20 PM

Windows 2012 Dates Announced

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

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

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

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

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

So in an earlier


July 2, 2012  2:00 PM

Giving users the ability to create indexes

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

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


June 28, 2012  2:00 PM

What do I do with Standard Edition SQL Servers using Mirroring

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

With the release of SQL Server 2012 many of the people who are using Standard Edition and Database Mirroring are quite nervous about what their HA options are going to be moving forward, and rightfully so as Microsoft has been pretty silent on this specific topic.  Let me see if I can't calm your...


June 25, 2012  2:00 PM

Moving huge amounts of data between data centers

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

Every once and a while I get the fun project of moving a data center from one location to another, often from a Managed Service Provider to either a CoLo facility or to another Managed Service Provider.  When I'm doing this the data sizes typically aren't small.  In the case of my current project...


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: