SQL Server with Mr. Denny:

SQL Server


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


March 17, 2009  10:50 PM

Slide Decks and Sample code from Quest Day with the Experts



Posted by: Denny Cherry
Brent Ozar, In Person Events, Quest Software, Service Broker, SQLServerPedia.com

The slide decks and sample code that Brent and I presented with have been uploaded.  The recordings have to be...


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: