Home > IT Blogs > SQL Server with Mr. Denny/

SQL Server with Mr. Denny:

April, 2009

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

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

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

  Bookmark and Share     1 Comment     RSS Feed     Email a friend

April 23, 2009  11:00 AM

New SQL Server 2008 MCTS Certification Book



Posted by: Denny Cherry
Book, Certifications

There's a new SQL Server 2008 MCTS Certification book on the market.  It is "The Real MCTS SQL Server 2008 Exam 70-432 Database Implementation and...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

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 »

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

April 16, 2009  11:00 AM

Setting up Visual Studio 2005 to use more than 2 Gigs of RAM



Posted by: Denny Cherry
Steve Harman, Visual Studio 2005

One of my developers came to me asking me to add more RAM to the c++ build server.  However the machine was already at 2 Gigs so I wasn't sure if adding more RAM wouldn't help.  Turns out that VS 2005 doesn't support AWE so adding more RAM wasn't going to be of much help.  Until I found a post...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

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

  Bookmark and Share     1 Comment     RSS Feed     Email a friend

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

  Bookmark and Share     6 Comments     RSS Feed     Email a friend

April 2, 2009  11:00 AM

Me and Twitter



Posted by: Denny Cherry
Social Commentary, Twitter

Personally I don't get most of the social networking sites / products / whatever you want to call them. Continued »

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

1