The Complete Weekly Roundup of SQL Server News

In this issue:

Tech News : General Interest

Tech News : Security

SQL Server News : Bugs/KB

Hardware News

Blogs : Administration

Blogs : Analysis Services / BI

Blogs : Backup and Recovery

Blogs : Career

Blogs : Events

Blogs : High Availability/Disaster Recovery

Blogs : Integration Services/ETL

Blogs : NOSQL

Blogs : Performance and Tuning

Blogs : PowerPivot

Blogs : Reporting Services

Blogs : Security and Auditing

Blogs : Software Development

Blogs : Spatial Data

Blogs : SQL Server 2014

Blogs : T-SQL

Blogs : Virtualization

Database Weekly - www.databaseweekly.com

The Complete Weekly Roundup of SQL Server News

Hand-picked content to sharpen your professional edge

SQL Server News for 2013-11-25

SQL DBA Bundle The seven tools in the SQL DBA Bundle support your core SQL Server database administration tasks.
Make backups a breeze! Enjoy trouble-free troubleshooting! Make the most of monitoring! Download a free trial now.
Delivery Join our database delivery research group
If you’re already practicing, or are interested in, Continuous Integration and Continuous Delivery with databases (SQL Server or Oracle), a team at Red Gate would love to hear your views and stories. Find out more about joining our database delivery research group.
SQL Monitor Optimize SQL Server performance
“With SQL Monitor, we can be proactive in our optimization process, instead of waiting until a customer reports a problem,” John Trumbul, Sr. Software Engineer. Optimize your servers with a free trial.
Editorial - Content in the Cloud

This past week was the MVP Summit in Redmond, where Microsoft entertains and informs the people on whom it has recognized as MVPs for various products. I didn't attend this event as I've been out of town a lot in 2014 and wanted to remain at home. I also didn't have high hopes that it would be particularly informative given the relative close proximity to the next release of SQL Server 2014. However many others did and there was one item that caught my eye at the end of last week.

Greg Low wrote a blog about an option in SQL Server 2014 to place part of your database in the cloud. Essentially you could put a filegroup or file in a location accessible by a URL and use that when creating your database. There is documentation on this up on MSDN and you could test this if you have CTP2 and want to experiment with the effect of having a portion of your database on-premises and a portion in Azure.

Dr. Low includes a couple of places where this configuration might make sense in his blog. The first I agree with. If you are using your database in Azure, then accessing some of the files via a URL makes sense. The second? I'm not so sure. The documentation talks about how or why you might do this, but there's one key element I don't see mentioned: performance. What happens if the Azure connection drops? What happens if it's very slow? If my queries were returning to users asynchronously, from separate batches, I would see some benefit here to clients, but if they don't get results until my local files AND my cloud files return data, I'm not sure I'd pay that penalty.

I'm glad this is an option, and I'm sure there are places where this makes sense. I'm just not sure one of them is some of the tables in my database on premise and some in the cloud when they're being joined together.

» Join the debate, and respond to today's editorial on the forums


The Weekly News

All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit. These headlines are gathered throughout the week and are posted in real time at the website. Check there for information throughout the week or enjoy this weekly summary of the SQL Server world.

Tech News : General Interest

Kinesis: Amazon's cloud opens to the Internet of things - The phrase...(more)

Google will build another six solar power plants in the U.S. - Google has announced plans to continue its rollout of solar energy plants in the U.S. with its second largest investment to date: $80 million for six new facilities. So far, Google has committed over $1 billion to wind and solar power plants that create ......(more)

Facebook Ops: Each Staffer Manages 20,000 Servers - Each Facebook data center operations staffer can manage at least 20,000 servers, according to Delfina Eberly, Director of Data Center Operations at Facebook....(more)

Why The Hybrid Cloud is Gaining in Popularity - What’s the driving force behind the hybrid cloud boom? What is causing the blurring of the cloud line? Bill Kleyman looks at why hybrid clouds are gaining in popularity....(more)

Tech News : Security

Stuxnet Discovered To Contain Two Stealth Weapons - The Stuxnet virus that damaged Iran?EU?s Natanz nuclear facility was worse than we thought. In fact, Ralph Langner, a cyber security expert, described it as ?EU?far more dangerous than the cyberweapon that is now lodged in the public?EU?s imagination.?EU?Claimed ......(more)

GitHub bans weak passwords after brute-force attack results in compromised accounts - Popular source code repository service GitHub has recently been hit by a brute-force password-guessing attack that successfully compromised some accounts....(more)

Yahoo Will Encrypt All Data Moving Between its Data Centers - In a move to reassure customers about the privacy and security of their data, Yahoo today said it will encrypt all data moving between its data centers....(more)

SQL Server News : Bugs/KB

Cumulative Update #7 for SQL Server 2012 SP1 - CU 7...(more)

Cumulative Update - ...(more)

Hardware News

Western Digital's HAMR technology could increase disk capacity five-fold - Western Digital yesterday said it has demonstrated heat-assisted magnetic recording (HAMR) technology at a Chinese trade show. The technology has the potential to increase the density through which data is stored on hard disk drives by more than five ......(more)

Blogs : Administration

Fill Factor, Why Do You Taunt Me? Part 2 - So Friday we were discussing the idea of an idea. I think... or an idea of an idea's idea. What she said...Let's answer the easy question. How far are your fill factors off from the default settings?First we want to look at what our default setting actually ......(more)

Fill Factor and wasted space: Quick Tip - This is a little excessive, but here's a quick script to show you your fill factors per table that are not at 100 as well as how much unused space you have per table. It also creates a script to rebuild, be aware of the options that are set.select db.name ......(more)

How many heap tables do you have? :Quick Tips - Nothing exciting, just a general script. How can you see what heaps you have laying around?exec sp_MSforeachdb @command1 ='use [?]SELECT object_Name(i.object_id)AS TableName, i.object_id,Schema_Name(o.schema_id)AS SchemaName, i.name, avg_fragmentation_in_percent, ......(more)

Transaction Log Monitoring - Paul Randal (@PaulRandal), CEO and owner of SQLskills.com, discusses monitoring the transaction log, as he rounds out his series on transaction log configuration and management....(more)

Windows Server 2012 R2 Group Managed Service Accounts and SQL Server - Are you tired of spending time changing passwords for SQL Server service accounts? Do you incur downtime or risk when changing passwords for critical SQL instances?? DBA’s can now leverage Group Managed Service Accounts to eliminate password management ......(more)

SQL Server Diagnostic Information Queries for November 2013 - I have made a number updates and bug fixes, including some additional columns in some of the queries for all of the versions of my SQL Server Diagnostic Information Queries for this month.  I have also added more comments and links about how to interpret ......(more)

Blogs : Analysis Services / BI

The Modern Data Warehouse - In recent surveys by TDWI Research, roughly half of respondents report that they will replace their primary data warehouse (DW) platform and/or analytic tools within three years. Ripping out and replacing a DW or analytics platform is expensive for IT ......(more)

Visualizing Cop Stops in NYC - A fascinating map of New York City -- overlaid with data from stop-and-frisk reports and gun-recovery operations -- provides fodder for critics and visualization enthusiasts alike....(more)

McDonald's Stays Hot With Predictive Analytics - McDonald's gives restaurant owners the chance to ask...(more)

Blogs : Backup and Recovery

Backups and Consistency - I wrote about transactional consistency recently. Why do we need this?Imagine that I have an orders table and an ordersdetail table in my database. The orders table has the order header (date, customer, etc) and the detail table includes information ......(more)

SQL Server 2014 Hybrid: Storing data files in Azure storage - Bizarre or not? - In the sessions that I was attending in Redmond yesterday, I was interested to see the presenter discussing the idea of having individual database files in the cloud as some sort of bizarre option that’s now available in SQL Server 2014. I don’t see ......(more)

Blogs : Career

Two new courses on Advanced Corruption Recovery Techniques and Maintenance Plans - I’ve just heard from our good friends at Pluralsight that our two latest online training courses are now live and available for watching!My latest course is SQL Server: Advanced Corruption Recovery Techniques which follows on from my earlier SQL Server: ......(more)

How to Fail a Phone Screen - It’s funny to me how easy it is to fail a phone screen – both as the interviewer, and as the interviewee – especially considering the fact that the purpose of a phone screen is to determine whether a candidate is worth bringing in for an interview.  That’s ......(more)

Free Ebook: SQL Server DBA Training Plan - Our Hierarchy of Database Needs training email plan has been a lot of fun. Thousands of SQL Server professionals have signed up to get an email in their in-box every Wednesday for 6 months. It’s like a part-time college course – the one you should have ......(more)

Getting Started with SQL Server Sample Databases - The best way to improve your skills as a database professional is to practice. If you’re like me, you might even take that practice outside of the workplace and do a bit of homework on the side. You can’t take a copy of your production database home ......(more)

Blogs : Events

Free Online SQL Server Training for the Week of November 24, 2013 - If you’re a training provider and I’ve missed you, please drop me a line at brian {dot} kelley {at} sqlpass {dot} org.All times are Eastern (New York). To convert to your local time, use the converter at timeanddate.com.Monday, Nov 25:12 PM – Integrating ......(more)

Blogs : High Availability/Disaster Recovery

Configuring Availability Group connectivity - Rick Pittser (@rjpittser) of SQL Sentry explains how to configure Availability Groups for connectivity from primary applications and also for connecting to read-only secondaries....(more)

SQL Server 2012 AlwaysOn High Availability and Disaster Recovery Design Patterns - This is one of the popular blog posts on sqlcat.com. Reposting (with updated links) here after sqlcat.com is de-commissioned. Author: Sanjay MishraContributors: Justin Erickson, Mike WeinerReviewers: Prem Mehra, Juergen Thomas, Steve Howard, Chuck ......(more)

Blogs : Integration Services/ETL

Biml Metadata Options and Considerations - Simply put, metadata is data about data. Probably the most common way that SQL Server Professionals use metadata is when we query SQL Server System Views. In this article we’ll discuss using metadata to drive BimlScript automation. Before I start listing ......(more)

Blogs : NOSQL

MongoDB and CAP - Just read this great post, Call me maybe: MongoDB and the wrap-up post, Call me maybe: final thoughts. They're part of a series called Jepsen on behavior of various NoSQL databases in failure scenarios.Very geeky but very interesting....(more)

Still Early Days for Hadoop - The vast majority of our audience is not using Hadoop for big data storage yet, according to our last flash poll....(more)

Blogs : Performance and Tuning

Indexing Fundamentals - First, lets understand what the types of indexes are. If you take a reference book, you have the two types of indexes. The book itself is a clustered index, it contains all the data and has the key field of page number. The index in the back is your ......(more)

SQL Diagnostics Project Part 1 – Configuring Custom SQL Data Collections - This blog post will be part 1 in a multi-post series where I show you how to create your own custom SQL Server troubleshooting data collections, how to load the data into a SQL Server database, and how to create your own custom reports based on the data ......(more)

If You Like Your Query Plan, You Can Keep Your Query Plan - Period(*).  I have two motives here. One – I liked the title. Two – it’s a good reminder and a couple recent conversations brought it up so I figured I’d talk about an old feature that first came out in SQL Server 2005 – Plan Guides and has been improved ......(more)

Specialized Performance Troubleshooting (Part 3: How to identify storage issues at a SQL Server box) - This week I will explain how to detect and analyze storage performance issues. The first step is to collect a Perfmon trace and check these two counters for each disk: Physical Disk: Avg. Disk Sec/Read Physical Disk: Avg. Disk Sec/Read The recorded...(read ......(more)

Blogs : PowerPivot

Generating A Date Dimension Table In Power Query - There are hundreds of different methods for generating a Date dimension table for use in Power Pivot: you can use TSQL, Excel formulas, import from the DateStream table in the Windows Azure Marketplace, and there’s even an app for it. Nevertheless I ......(more)

Blogs : Reporting Services

Kerberos Configuration Manager updated for Reporting Services - Back in may, we released the Kerberos Configuration Manager tool to help with diagnosing and correcting Kerberos related issues for SQL Server.  Today, I’m happy to announce that version 2 of this tool has been released and has been updated for Reporting ......(more)

Blogs : Security and Auditing

Automated Permissions Auditing With Powershell and T-SQL: Part 5 - If you’ve followed along to this point, and have assembled the pieces as I’ve given them to you, you’re now looking at a Powershell script that is slowing getting more complex.By now, you should be starting to appreciate how much power (pun intended) ......(more)

How to reset the SA password in SQL Server - Getting locked out of a SQL Server can happen in a number of ways.  You could inherit a server that was managed by someone that left the company and only that person had System Admin rights for example. A recent encounter I had was were a database server ......(more)

Blogs : Software Development

Introducing the Red Gate SSMS Ecosystem - The Red Gate SSMS Ecosystem is a framework that makes it easy to develop, share and manage SSMS plug-ins. We aim to help plug-in developers build everything from homegrown solutions and community-driven projects to commercial solutions provided by partner ......(more)

Lessons Learned from Six Years of Agile Database Development - Alex Kuznetsov describes the agile principles, techniques and tools that allowed his development team to make frequent database refactoring a reality, without disrupting users. He explains how this allowed his team to apply an iterative, evolutionary ......(more)

Visual Studio Updates - Survey - Hi folks.With Visual Studio 2012 we started the Visual Studio Update program - releasing regular (nearly quarterly) public updates that contained both new features and servicing fixes. To date we’ve released four Updates, and the latest Update for Visual ......(more)

Blogs : Spatial Data

Spatial Indexing: From 4 Days to 4 Hours - Over the past month I have been involved in the optimization of a Spatial Index creation/rebuild.  Microsoft has several fixes included in the SQL Server 2012 SP1 CU7 Release I have been asked by several people to tell the story of how I was able to ......(more)

Blogs : SQL Server 2014

SQL Server 2014 In-Memory OLTP discussions at PASS Summit 2013 - Wow, what a great PASS Summit!  Great to see so many old friends and meet so many new ones! At PASS I had the opportunity to talk to a number of people about an exciting new feature we have in SQL Server 2014, In-Memory OLTP (codenamed...(more)

Blogs : T-SQL

Hashing for Indexes - Hashing functions. I’m going to talk about two ways to hash your data inside SQL Server and one way outside SQL Server.CHECKSUM optionsLet’s talk about  BINARY_CHECKSUM() and CHECKSUM().These are both vulnerable to collisions but they’re nice and ......(more)

Use application lock to synchronize T-SQL code - Application lock can be used to synchronize T-SQL code, you can control if the session is able to run the t-sql code at same time, it is like the lock keyword in C...(more)

SQL Server – Custom sorting in ORDER BY clause - ORDER BY clause can be used to sort the results returned by SELECT statement in SQL Server. It orders the result set by specified column list. When used with character data type columns it sorts data in dictionary-order.Sometimes, we need result set ......(more)

What You Can (and Can’t) Do With Indexed Views - Views are logical objects in SQL Server databases that present you with a “virtual table”. Views are typically created for one of three reasons: security, simplification, or aggregation.Security: we create views so that a user can read specific columns ......(more)

Blogs : Virtualization

SQL SERVER – vCPUs – How Many Are Too Many CPU for SQL Server Virtualization ? – Notes from the Field - ...(more)


Administrative