Welcome to #SQLServer Weekly!
Here is a roundup of SQL Server content from this past week ordered by their social sharing volume. I gather the most shared SQL Server content in Twitter, Facebook, Google+ and LinkedIn.
“How to restore SQL Server database with Veeam Explorer for SQL Server”
When we released Veeam Explorer for SQL Server last year, I was very excited about this new Explorer. It truly addresses the database restore situation with ease for virtualized SQL Server systems running as a virtual machine (VM) on VMware vSphere and Microsoft Hyper-V without requiring the expertise of a SQL Server database administrator (DBA). In this blog post, I’ll focus on simply restoring a SQL Server database from a Veeam backup job.
“Sql Server Interview questions: What is the XML datatype?”
The XML datatype holds and understands valid XML streams pretty much the same way that integers hold numbers with no decimal points, varchars hold strings of varying length, and the Geography datatype holds a position on the earth.
“ColumnStore Indexes in MS SQL Server”
Introduced in SQL 2012, ColumnStore indexes differ greatly from standard row-based indexes. Intended for OLAP systems, these indexes store data in a highly compressed, segmented fashion with the column as the basis (rather than typical row-based indexes). This type of column-based index allows for great performance gains in data warehouses where table scans, rather than seeks, are performed.
“Utah SQL Server Group”
SQL Server meetup group in Utah
“Dealing with an Inherited SQL Server”
Get a quick must-do checklist for dealing with an inherited SQL Server system
“Microsoft SQL Server 2012 Bible”
The comprehensive, tutorial resource for SQL Server 2012
“The Top 10 Mistakes Made by SQL Server DBAs”
I had the recent good fortune to undertake a speaking tour in which I talked to eight chapters of the Professional Association for SQL Server (PASS) throughout the American Midwest and South. (You can read details about this speaking tour, called the SQLVacation, here.)
SQL Server Integration Services Feature Pack for Azure
SQL Server Integration Services Feature Pack for Azure enables you to easily extend your SSIS workflow to use cloud technologies powered by Microsoft Azure, such as Azure Storage, HDInsight, and Machine Learning etc.