The SQL Server 2012 Parallel Data Warehouse is ready to roll out and it is a BigData big deal

The SQL Server 2012 Parallel Data Warehouse (PDW 2012) contains a number of impressive improvements one of which is integration with Hadoop. PDW V1 featured integration with Hadoop by implementing a SQOOP based import/export connector. This new feature is named Polybase and in short, Ploybase allows you to issue a TSQL query that accesses data…

0

Book Review – Hadoop: The Definitive Guide, Third Edition

Book Review – Hadoop: The Definitive Guide, Third Edition (May 2012)By Tom White Copyright 2012Published by O’Reilly Media IncISBN: 978-1-449-31152-0 OverviewOrganized into sixteen chapters and three appendices, Hadoop: The Definitive Guide, provides a comprehensive and detailed guide to the Hadoop ecosystem.  The first three chapters provide an overview and history of the Hadoop project and introduce…

0

Exploring Windows Azure Storage Options

My newest adventure has me exploring Big Data and I have spent the past few weeks swimming in the deep end of the Windows Azure pool. Here are some quick links to the data storage options available on Windows Azure:     SQL Database (formerly known as SQL Azure) This is Software as a Service…

0

Hyperthreading, Turbo Boost, SQL Server and You

Here are two topics that are tangentially related, Hyperthreading and Turbo Boost. Conversations beginning with one often lead to the other so here are my thoughts, comments, findings and resources on both. Hyperthreading and SQL Server I am asked about hyperthreading all the time. People have a lot of different experiences with hyperthreading and SQL Server. …

0

Virtualizing? You need more skills

Latte Art If you are planning on building a Private Cloud and virtualizing your SQL Servers there are some new skills you MUST acquire.  In addition to all the skills you need to effectively manage your SQL Server instances and databases now you will need to be able to effectively manage the virtual environment that is…

0

SQL Server 2012 – CUs are Inevitable (T-SQL Tuesday #29)

This T-SQL Tuesday is being hosted by Nigel Sammy. Enjoy. Ever build a Slipstream install of SQL Server?  All that manual cut and move and pasting of little binary files here and there and everywhere it seems. Always felt so hands-on. Always wondered if it would actually work. Always had to update the thing. Don’t get…

2

Magical Database Monitoring

This weeks photo is from Jersey City,NJ looking across the Hudson River (Scene One: Office of the DBA) Enter: Friendly SQL Adventurer ready to help you be more pro-active in your management of your enormous SQL Server landscape. Has your company invested in a database monitoring tool?  Something that will give you “live” performance information…

0

VSUS (VLF Segments of Unusual Size)

Enjoying another little train trip around an airport. and while waiting around for my flight I thought I would try and tackle fixing that 16 VLF segments of 16 GB each situation I described in my previous blog post. You might just think “well that should be just like fixing the too many VLFs issue, just shrink it down…

0

If > 50 VLFs are bad, then 16 is good, right?

Exhibit A:  256 GB transaction log file with 16 VLFs.  Doing the quick math that would make each VLF 16GB.  16 x 16GB VLFs = 256GB transaction log. (yes, that is a large transaction log) All this guidance I see says 50 VLFs would be too many. Okay, not too many VLFs, so we should be fine……

0

Up in the Air

Airplanes with Props One of my favorite short flights is the flight from Seattle, WA to Portland, OR. If the weather cooporates you can get views like this; Mt. Rainier There are a number of things I like about this flight.  First, I like airplanes with props – just something about them. Second, this flight…

0