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 : Computing in the Cloud

Blogs : Data Access / ORMs

Blogs : DMO/SMO/Powershell

Blogs : Events

Blogs : Hardware

Blogs : High Availability/Disaster Recovery

Blogs : NOSQL

Blogs : Performance and Tuning

Blogs : Professional Development

Blogs : Software Development

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 2012-09-17

SQL Backup Pro Have you tried SQL Backup Pro 7 yet?
Get faster, smaller, fully verified backups today. Try SQL Backup Pro 7's automated DBCC CHECKDB and be prepared when you need to restore. Download free trial.
SQL Connect Keep your database and application development in sync
SQL Connect is a Visual Studio add-in that brings your databases into your solution. It then makes it easy to keep your database in sync, and commit to your existing source control system. Find out more.
SQL Storage Compress Compress live data by 73% 
Red Gate's SQL Storage Compress reduces the size of live SQL Server databases, saving you disk space and storage costs. Learn more.
Editorial - The Longevity of the Relational Database

One of the worst crimes in IT is to generalize from particular experience. The more experience we get, the more that black and white dogma about 'best practices' or 'patterns' fades into shades of grey. So many times, the teams who create new ways of handling, or processing data, look up from their work, and declare that it is good and suited to all conceivable purposes. Sure, it is fine for the type of data you can imagine, but what about all the other types?

In a former role, evaluating database technologies for a large multinational corporate, I was forced to check the products of an unceasing procession of optimistic entrepreneurs presenting new ways of handling data. Over twenty years ago, there was a wave of NoSQL hysteria, and a succession of suited presenters wobbled their jowls in sincerity at me and solemnly declared relational systems to be dead in the water, soon to be replaced by object databases. It did not happen, of course, because the people who developed the new generation of databases had no idea of the range of requirements of scale, resilience, security, data-flow, and the sheer interdependence of corporate data. There is a world of difference between the way of responsibly handling test data, departmental data, private research data, financial data, personal data, manufacturing data, and sales data. Handicapped by their hazy knowledge of the realities of data processing, none of the hopeful companies who I evaluated survived even a handful of years.

Usually, I pitied, and sympathized with, the people I met who were attempting to break the supremacy of the relational model for handling corporate data. I explained the burden of support and training that the introduction of a new technology entails, the sheer scale of the data it would be required to accommodate, the almost science-fiction demands on performance. I waxed eloquent on the statutory requirements for data, the corporate rules, the conditions for putting database systems into production, the complexity of data processing. I'd dip into my fund of horror stories of the consequences of leaving even a trace of doubt in the data and its integrity. I don't think I ever even bruised their confidence in their new solution.

Yes, we always hope to see a better solution for semi-structured data or for ephemeral information. All developers bridle at the restrictions of SQL Databases, but cannot help admiring their sheer ubiquity, their ability to provide data integrity and accessibility for the whole tapestry of data categories thrown up by human endeavor.

Phil Factor

» 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

The Best Times To Post To Facebook, Twitter, Google+ & Other Social Networks [Infographic] - When it comes to social media marketing you want to make sure you get the most out of each and every single post you make in terms of reach. One of the best ways to maximize the reach of your social media posts is understanding the best (and worst) times of day to share content....(more)

The Royal Nokia Screw-Up That Shouldn’t Have Been - If Nokia had managed the launch well, the Lumia 920 could have been a phone that worried Samsung, piqued Apple, and inspired hordes of customers around the world to at least take a look before signing up for the new iPhone. But none of that happened, because Nokia made a hash of the whole affair....(more)

Tech News : Security

Crack in Internet's foundation of trust allows HTTPS session hijacking - Researchers have identified a security weakness that allows them to hijack web browser sessions even when they're protected by the HTTPS encryption that banks and e-commerce sites use to prevent snooping on sensitive transactions....(more)

Five Epic Hacks That Never Happened - In the spirit of yesterday’s GoDaddy incident where a random Twitter handle claimed to have downed the hosting giant, here are five great hacks that never happened — despite what you might have learned from the media....(more)

Go Daddy blames outage on tech glitch, not hackers - Go Daddy, one of the world's biggest Internet hosting companies and website registration companies, blamed technical problems for a nearly six-hour service disruption that affected some of its more than 10 million customers on Monday....(more)

GoDaddy goes down, Anonymous takes credit - Popular domain name registrar and Web and email hosting provider GoDaddy is experiencing a severe outage, one that appears to have taken out not only its hosted services, but even those websites that have registered their domain names through GoDaddy....(more)

SQL Server News : Bugs/KB

FIX: Incorrect results when you run a parallel query that uses a columnstore index in SQL Server 2012 - When you run a parallel query in Microsoft SQL Server 2012, you may receive incorrect results. This problem occurs if the following conditions are true: The query runs against a partitioned table that has a columnstore index, or the query uses an aggregate function over the columnstore index...(more)

Hardware News

University builds cheap supercomputer with Raspberry Pi and Legos - Inspired by the low-cost computing power of the Raspberry Pi, a team at the University of Southampton has used the ARM-based Linux computer-on-a-board as a building block for a low-cost supercomputer—racked and stacked using Lego blocks. And they’ve published a step-by-step guide for anyone interested in creating their own Raspberry Pi high-performance computing “bramble."...(more)

Helium-filled hard disks will lead to higher capacities - A sealed hard disk drive filled with helium instead of air. Queue the excellent jokes....these new drives squeak when broken instead of clunking... ...(more)

Blogs : Administration

Can I install SQL Server 2012 Standard Edition to run in a server with more than 4 sockets or more than 16 cores? - Bottom-line ...it doesn’t make sense (in terms of economy) to install an Standard edition of SQL Server in a physical server with more than 4 sockets or 16 cores when you plan to license it through the Per Core licensing model. If you do so, you will have to pay licenses for cores SQL Server will not use, typically, concurrently when the workload of the server grows requires such computing power....(more)

How To: Right-sizing The Datatypes Currently In The Buffer Pool - Thomas La Rock refines his datatypes sizing script to focus on the pages that are being used in memory right now. ...(more)

Bulk Insert and Kerberos - Adam W. Saxton on an issue involving a failed bulk load and Kerberos Delegation....(more)

SQL Server: Understanding GAM and SGAM Pages - We know that SQL server stores the data in 8 KB pages. An extent is made up of 8 physically contiguous pages.When we create a database, the data files will be logically divided into the pages and extents.Later, when user objects are created, the pages are allocated to them to store the data.GAM (Global Allocation Map) and SGAM (Shared Global Allocation Map) pages are used to track the space allocation in SQL Server....(more)

Revisiting Inside Tempdb…. - Bob Ward clarifies some of the lesser known facts about tempdb....(more)

Blogs : Analysis Services / BI

The Weather Chanel Boosts Efficiency and Control with Microsoft BI and Power View - Prior to upgrading to SQL Server 2012, The Weather Channel managed 1 petabyte of financial data on five different systems as well as on employees’ desktops. Each system operated in a silo, requiring consolidation on a Microsoft Excel 2010 spreadsheet to create any type of business intelligence report. As you can imagine, this process was very time consuming, often taking days to complete....(more)

Blogs : Backup and Recovery

Real tortoises keep it slow and steady. How about the backups? - Maria Zakourdaev puts some 3rd party backup tools through their paces....(more)

Blogs : Computing in the Cloud

Max Pool Size Setting and Federations in Windows Azure SQL Database - With federations, your app servers connect to the collection of databases (your federated db with the root and member databases) using a single connection string. This is key to solving the connection multiplexing and connection pool fragmentation issues....(more)

Working with Relational Data in the Cloud: Some Useful Articles - Windows Azure provides two core relational database technologies for applications that require relational data storage with transactional capabilities. The first is Windows Azure SQL Database, and the second is running SQL Server inside a Windows Azure Virtual Machine. Both are based on SQL Server, and so existing SQL Server skills and knowledge transfer well to Windows Azure. ...(more)

Blogs : Data Access / ORMs

Domain Model over Database Schema. Using fluent nHibernate to generate the database - In domain driven design everything centers on your domain model. Domain objects are persisted to a database. What that database exactly looks like is not known to the model. ...(more)

Blogs : DMO/SMO/Powershell

Use PowerShell to Simplify Access to XML Data - Microsoft Scripting Guy, Ed Wilson, shows how to use Windows PowerShell 3.0 to read XML files....(more)

Powershell v3 and the NEW ISE (Integrated Scripting…. AHHHH! THE NEW EDITOR!) - Now the gates have opened and with the Windows Management Framework 3.0 we have the new, the GREATLY improved, the “Oh come on, why didn’t you give us this in version 2” Powershell ISE....(more)

Blogs : Events

24 Hours of PASS coming up soon! - The next 24 Hours of PASS event is less than a fortnight away (Sep 20/21)! And there’s lots of info about it at http://www.sqlpass.org/24hours/fall2012/....(more)

Speaking - Red Gate's SQL in the City - Allen White will be in Chicago on October 5, and in Seattle on November 5, presenting a session entitled Automated Deployment: Application And Database Releases Without The Headache....(more)

Blogs : Hardware

Do you want free hardware? We can help! - Most companies don't know the ins-and-outs of choosing hardware, and how to maximize its performance while minimizing the hardware and licensing costs. Once you've spent your money, you're stuck with whatever you bought until the next hardware budget cycle comes around, whether it fits the bill or not....(more)

Blogs : High Availability/Disaster Recovery

Disaster Recovery Discovery - Last weekend, several of my IT staff and I convened to a remote CoLo center in a large South East city of the US. Our mission: to perform a Disaster Recovery test......(more)

AlwaysOn Availability Groups Connectivity Cheat Sheet - A cheat shewet to help you predict how the connectivity will behave in various combinations, and therefore setup your Availability Group replica properties correctly....(more)

SQL Server: Correlating Timestamps From Various Data Points - "I was looking at data from a customer, in a different time zone (UTC+1) from mine, this week involving SQL Server AlwaysOn (HADRON) and found that lining up the timestamps in the various logs was challenging. Some times are local to the SQL Server instance, others UTC and yet other utilities attempt to adjust the UTC time using your current client settings. "...(more)

Merge replication stopping without errors in SQL 2008 R2 - The Merge Agent on the subscriber was just stopping every time, shortly after it started. With no errors anywhere – not in the Windows Event Log, the SQL Agent logs, not anywhere. We’d managed to get the system working again, but didn’t have a good reason about what had happened, and last week, the problem occurred again....(more)

Blogs : NOSQL

FoundationDB — Not Your Standard NoSQL Database - A database that "adopts the inherent strengths of NoSQL and integrates what they call YesACID"...(more)

Big Data Learning Resources - Lara Rubbelke shares some resources to learn about Big Data and Hadoop. ...(more)

Blogs : Performance and Tuning

Why is that SQL Server Instance under stress? - There are several reliable indications, using SQL Queries, of the what is causing SQL Server performance problems. Some of these are fairly obvious, but others aren't. Grant shows how you can get clues from any SQL Server as to the cause of stress....(more)

Optimizing ad-hoc workloads - The setting, "optimize for ad-hoc workloads", is configured using sp_configure and when enabled will generate a very small execution plan stub when a statement is first compiled. This plan stub, which is many times smaller than what the execution plan would normally be, ensures that the plan cache doesn't get very large from dynamically executed SQL that isn't likely to be resused....(more)

Blogs : Professional Development

10 Things I Hate About Interviewing You - If you are looking for a job (especially a job as a DBA) here are ten things that will likely result in my losing your phone number when you walk out the door....(more)

Free ebooks: What’s new in our list of great resources - Introducing Windows Server 2012, Programming Windows 8 Apps, and more......(more)

What Counts For a DBA: Ego - In most organizations, the DBA team is seriously outnumbered by headstrong developers and clock driven managers, and “great” DBAs will often be outnumbered by…well…the not so great. In order to be heard in this environment, a DBA will not only need to be very skilled, but will also need a healthy dose of ego...(more)

From Hairdresser to DBA – How to start a career in IT - I left school more years ago than I care to count with minimal qualifications and more or less fell into a career in hairdressing. I loved what I did for most of my time in that career but by 1999 had achieved everything I wanted to within that industry. I decided it was time for a change of direction. That new direction was IT, not the most obvious choice you might think and certainly not an easy change to make. This post is about that change and tries to offer tips for others in a similar situation. ...(more)

When Your DBA Job Sucks: The Phases of Burnout - Even when you love being a DBA, working the job can turn into a grind. There’s many times when you’re up all night troubleshooting just to face another day at the office handling user complaints....(more)

Blogs : Software Development

Ten Things I Wish I’d Known When I Started Using tSQLt and SQL Test - The open-source Unit Test framework tSQLt is a great way of writing unit tests in the same language as the one being tested. In retrospect, after using tSQLt for a while, what are the 'gotchas'; those things that you'd have been better off knowing about before you get started? David Green lists a few tips he wished he'd read beforehand....(more)

Why I’m done with Scrum - "I’ve had a lot of success with Scrum – but I’ve had greater success in ditching it. Jimmy Bogard explains a few (of many) reasons why....(more)

On Professional Code - More to the point, a professional system is one that can be supported in production easily. About the most unprofessional thing that you can say is: “I have no idea what is going on.”...(more)

Blogs : T-SQL

Why Doesn’t Partition Elimination Work? - Given a partitioned table and a simple SELECT query that compares the partitioning column to a single literal value, why does SQL Server read all the partitions when it seems obvious that only one partition needs to be examined?...(more)

Using Alt-select in SSMS, Word, and elsewhere - A surprising number of database people and Windows users in general don’t know about Alt select. This is a Windows technique not unique to SSMS that allows a user to select an arbitrary rectangular region of text and delete it, cut it, or copy it....(more)

T-SQL Window Functions - Part 2: Ranking Functions - Steve Hughes present part 2 of his series on SQL window functions, this time exploring use ranking functions. ...(more)

TSQL - Solve it YOUR Way - Finding the MAX Value from Multiple Columns - We have a table with three datetime columns and want to return the most recent date for each row. As part of the blog series TSQL - Solve it YOUR Way, we see four different solutions from three of the more helpful and creative contributors in the TSQL MSDN forums....(more)

Lost in Translation – Deprecated System Tables – sysdevices - Jason Strate continues a blog series which focuses on translating compatibility views in SQL Server to their respective dynamic management objects....(more)

When I Use Nested Joins - Michael J Swart explains how he avoids RIGHT OUTER joins in favor of LEFT OUTER joins and OUTER joins in favor of INNER joins....(more)

Blogs : Virtualization

Moving to Hyper-V - Andrew Fryer has been asked more and more often about how to move virtual machines onto Hyper-V and so wanted to do a definitive post on the tools and techniques to do this....(more)


Administrative