Informational | Randall Neth - BI, SQL, & SharePoint

SQL Server Denali CTP1 Available

By Randall Neth, on November 10th, 2010%

Microsoft has just announced that SQL Server “Denali” CTP1 is available for download at http://www.microsoft.com/sqlserver/en/us/product-info/future-editions.aspx. Many great things here that I have been looking forward to especially the ‘SQL Server Always On’ which has availability groups and support for multiple secondaries.

“Denali” BOL: http://msdn.microsoft.com/en-us/library/ms130214(SQL.110).aspx

Kansas City IT Professionals (KCITP) Posting

By admin, on October 30th, 2010%

Michael Gelphman, the founder of Kansas City IT Professionals (KCITP) interviewed me recently to discuss the Microsoft Certified Master (MCM) program and the interview was just posted here http://www.kcitp.com/2010/10/29/member-highlight-randall-neth/.

KCITP Home Page: http://www.kcitp.com

Microsoft MCM Information: http://www.microsoft.com/learning/en/us/certification/master.aspx

SQL Saturday #53

By Randall Neth, on July 29th, 2010%

I have just submitted a session to speak at SQL Saturday on October 2 in Kansas City, MO. I plan on speaking on the Microsoft Certified Master (MCM) program. Essentially covering the entire experience from applying for, what you learn, what is expected of you, instructors, relationships built, and pretty much everything in between. I also plan on submitting some other topics just trying to narrow down the selection, leaning towars SAN/Storage design, virtualizing SQL, and/or Effective DataWarehouse design.

Information on the event can be found here: http://www.sqlsaturday.com/53/eventhome.aspx

SQL 2008 SPARSE COLUMNS and TDE

By Randall Neth, on June 27th, 2010%

I was sitting at home and thinking about some of the different features of SQL 2008 and their interoperability. Thus I wanted to verify the compatability of SPARSE COLUMNS and Transparent Data Encryption (TDE). SPARSE columns shows great gains for NULL values and TDE allows you to encrypt your database; I wanted to verify just as with TDE and Data Compression you still get the space savings benefits. As you can see by the results below it does appear as though databases with TDE enabled to still benefit from SPARSE COLUMNS. (As a note Backup Compression does not show any benefits when utilized on a TDE enabled database.)

Below are the results (Tables within databases contained identical data):

NORMAL DB: