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...
April 14, 2011 2:00 PM
Posted by: Denny Cherry
SQL Server,
SQL Server 11,
SQL Server 2005,
SQL Server 2008,
SQL Server 2008 R2,
SQL Server 2012,
SQL Server Management StudioBy default SQL Server Management Studio will only show you 256 characters per column. The fix for this is pretty easy. You click on Tools > Options to being up the options menu. From there navigate to Query Results > SQL Server > Results To Text. Change the "Maximum number of...
March 25, 2011 2:05 PM
Posted by: Denny Cherry
In Person Events,
Manageability,
SQL Server,
SQL Server 11,
SQL Server 2012,
Tech Ed 2011,
Tech Ed North AmericaApparently someone at Microsoft has completely lost their mind. They have signed me up as a speaker for Tech Ed NA 2011. I'll be presenting a session titled 'What's New in Manageability for Microsoft SQL Server Code-Named "Denali"'.
This is a 300 level session so it will be full of all sorts...
February 7, 2011 2:00 PM
Posted by: Denny Cherry
Backup & recovery,
BACKUP DATABASE,
SQL Server,
SQL Server 11,
SQL Server 2000,
SQL Server 2005,
SQL Server 2008,
SQL Server 2008 R2,
SQL Server 2012Apparently people still haven't figured out that taking backups of SQL Server databases is actually a requirement of having a SQL Server database. There was a conversation recently on Twitter about yet another forum question where the OP talked about the crashed database that they had without any...
February 1, 2011 2:00 PM
Posted by: Denny Cherry
Data Encryption,
Encryption,
In Person Events,
Indexing,
SoCal Code Camp,
SQL Server,
SQL Server 11,
SQL Server 2012So this last weekend was the 13th SoCal Code Camp (the 6th at this location). I presented three different sessions at this code camp. My slide decks can be downloaded below.
January 24, 2011 11:20 PM
Posted by: Denny Cherry
AlwaysOn,
SQL PASS,
SQL Server,
SQL Server 11,
SQL Server 2012So it is time for another vote for the second category that I have a SQL Rally session submitted for. This time the vote is for the "Enterprise Database Administration & Deployment" track. I've got a session up titled "Using SQL...
December 6, 2010 2:00 PM
Posted by: Denny Cherry
SQL Server,
SQL Server 11,
SQL Server 2008 R2OK, now that I have your attention pretty much nothing has changed in Denali's Master Data Services. The install procedure is a bit different now but that is about it. To install the Denali version of MDS just run through the normal SQL Server installer. When you get to the service list page...
