June 29, 2011 2:00 PM
Posted by: Denny Cherry
SQL Excursions,
SQL ServerMy third SQL Excursions session I'd like to talk about is going to be about high availability. There are lots of high availability options for SQL Server, especially when SQL Server "Denali" is one of the high...
June 28, 2011 2:00 PM
Posted by: Denny Cherry
SQL Excursions,
SQL Server,
VirtualizationThe next session from SQL Excursions that I want to talk about is my session on virtualization. During this session, we will be talking about some best...
June 27, 2011 7:39 PM
Posted by: Denny Cherry
SQL Excursions,
SQL Server,
StorageAs SQL Excursions is getting closer, I wanted to talk a little about the sessions that I'll be presenting at the event which I'll be doing over this week. The sessions that I'll be presenting...
June 15, 2011 5:27 PM
Posted by: Denny Cherry
BI,
Encryption,
SQL PASS,
SQL PASS 2011,
SQL Server,
SQL Server 11,
SQL Server 2000,
SQL Server 2005,
SQL Server 2008,
SQL Server 2008 R2,
SQL Server 2012,
SSAS,
Stacia MisnerSo I've managed to trick the kind folks of the SQL PASS program committee once again this year. I've gotten two sessions accepted for the summit.
The first is a "regular session" which is the normal 75 minute community session during which I'll be presenting "Where should I be encrypting my...
June 14, 2011 2:21 AM
Posted by: Denny Cherry
Attack Prevention,
Consolidation,
SQL Server,
SQL Server 11One of the features which has been announced to be coming in SQL Server “Denali” is the “Contained Database” feature. The feature which I’m looking for the most from Contained Databases is the ability to create a user within the database without having to first create a login for...
June 9, 2011 3:00 PM
Posted by: Denny Cherry
SQL Server,
SQL Server 11,
Tech EdI know that Microsoft’s Tech Ed 2011 ended a couple of weeks ago, and that my recap is way late, but better late than never. It’s been a crazy few weeks with EMC World 2011, Tech Ed 2011 the next week, then a two day train trip to Seattle which was supposed to have WiFi but didn’t, then SQL...
June 7, 2011 9:00 PM
Posted by: Denny Cherry
Lock Pages,
sp_getapplock,
sp_releaseapplock,
sys.dm_tran_locks,
TransactionsAll to often developers need to force some locks on a table so that they can be sure that the records aren’t going to change between the time that they first look at the records and when the transaction is completed. The most common method that I’ve seen to do this involves at the top...
June 2, 2011 2:00 PM
Posted by: Denny Cherry
Community,
SQL ServerBesides the insanity? It's fun. If it wasn't, I wouldn't do it. God knows it isn't for the money.
Yeah the presentations can be a pain to come up with, and coming up with topics to present on is probably my least favorite part of doing all this. But sharing the information that I know, and...
May 30, 2011 2:00 PM
Posted by: Denny Cherry
SQL Server,
StorageI would probably make 2 RAID 10 RAID groups one for the data files, and one for the transaction log. Without knowing what percentage of data access will be read and what will be write I’m just guessing here. Depending on the load RAID 5 may work just fine for the data files.
Denny
