SQL Server with Mr. Denny:

SQL Server


April 28, 2009  4:51 AM

Why should the DBA care about Network Firewalls?



Posted by: Denny Cherry
Networking, Security, SecurityFightClub, SQL Server

All to often I see people online asking some sort of question about connecting to their CoLo'ed SQL Server and they connect directly over the Internet.  This is nuts people.  If you can access your SQL Server via Management Studio from anywhere on the Internet so can people who would love to...

April 26, 2009  5:29 AM

SQL Server Standard Edition getting Lock Pages in Memory



Posted by: Denny Cherry
Bob Ward, Bug, Lock Pages, Microsoft CSS, SQL Server 2005, SQL Server 2008

Microsoft SQL Server 2005 and 2008 Standard edition will be getting the Lock Pages in Memory feature that SQL Server Enterprise Edition has had starting in SQL Server 2005.  This was announced by Bob Ward via the


April 20, 2009  11:00 AM

Yes DBAs you really do have to deal with licensing



Posted by: Denny Cherry
CALs, SQL Licensing

Probably one of the least fun things about being a DBA is having to deal with the licensing of SQL Server. Continued »


April 13, 2009  11:00 AM

Datacenter Migration In Progress



Posted by: Denny Cherry
Data Center Build, EMC, SQL Server, VMware

For those of you who know me, or have heard me talk at a Code Camp in the last year, you've heard me talk about a data center migration that I want to do from Rackspace in Texas to our own equipment in the LA area.  Well that day has finely come. Our current environment has served us well, but...


April 6, 2009  11:00 AM

My take on databases in the Cloud



Posted by: Denny Cherry
Amazon DB, Azure, Cloud Computing

I haven't made a decision on putting databases in the cloud.  I think Amazon and now Microsoft have the write idea for cloud databases.  Give people lots of options, use named value pars (AmazonDB or the old school Azure database) when it makes sence and use full blown RDBMS when it makes...


March 30, 2009  7:45 PM

SQL 2008 Clusters require treaking to make SQL Dumpter work



Posted by: Denny Cherry
Microsoft CSS, SQL Dumper, SQL Server 2008

If you don't already read the CSS teams blog, I suggest that you do.  A little while ago they posted a blog post about how the


March 29, 2009  12:05 AM

Viewing the domain groups that are used to get into SQL



Posted by: Denny Cherry
Extended Stored Procedure, Linchi Shea, T/SQL, xp_logininfo

Last week Linchi Shea wrote a posted a blog entry entitled "How does that AD user...

Bookmark and Share     0 Comments     RSS Feed     Email a friend


March 27, 2009  3:04 AM

Making SSMS Beep



Posted by: Denny Cherry
Colin Stasiuk, EarthLink, Ping, SQL Server Management Studio

Today I read a post from my good friend Colin Stasiuk (aka @BenchmarkIT) where he talked about


March 26, 2009  3:00 AM

So really, how many clustered indexes can I create on a table?



Posted by: Denny Cherry
Clustered Index, Index

This used to be a very easy question to answer as the answer was 1. However these days, with some creativity you can get some extra ones.

Bookmark and Share     0 Comments     RSS Feed     Email a friend


March 21, 2009  11:26 PM

What does the community want to see at PASS?



Posted by: Denny Cherry
In Person Events, PASS

So, as you may have heard the SQL PASS 2009 Call for Speakers has gone out.  I've submitted a couple of sessions already, but I was hoping to get some feedback from the community at large about what you think I should submit topics on. I've submitted a couple of SQL Service Broker sessions, as...