In this issue:

Tech News : Security

Tech News : The Lighter Side

SQL Server News : WebCasts

Microsoft News : General Interest

Microsoft News : Patches, Bugs

Blogs : Administration

Blogs : Analysis Services / BI

Blogs : Backup and Recovery

Blogs : Big Data

Blogs

Blogs : Career

Blogs : Computing in the Cloud

Blogs : Database Design, Theory and Development

Blogs : Events

Blogs : Hardware

Blogs : Professional Development

Blogs : Software Development

Blogs : Virtualization

Articles : Administration

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-05-06

SQL Prompt Make working with SQL a breeze
SQL Prompt 5 is the effortless way to write, edit, and explore SQL. It's packed with features such as code completion, script summaries, and SQL reformatting, that make working with SQL a breeze. Try it now.
SQL Backup Pro Get compressed, verified, secure SQL server backups
Use SQL Backup Pro's automated scheduling to get faster, smaller backups. Then verify your restores using DBCC CHECKDB in one easy, automated process. Download a free trial now.
SQL Toolbelt Want to work faster with SQL Server?
If you want to work faster try out the SQL Toolbelt. "The SQL Toolbelt provides tools that database developers as well as DBAs should not live without." William Van Orden. Download the SQL Toolbelt here.
Editorial - The State of the Cloud

Microsoft has joined the billion dollar club. For Azure, that is. They announced that this platform and service will generate a billion dollars in revenue. It's been growing, and at least one analyst expects the revenue to double annually. Profit is something else, but I know from various people at Microsoft that they are working hard and investing heavily in this service, and I'm sure at some point it will be profitable, though I'm not sure how much.

Amazon has had a very successful AWS platform, providing a wide variety of services and products. Their aim is to go for the high volume, low margin business, which makes their service competitive with the costs of buying and managing your own hardware. As long as Amazon and other competitors are out there, I suspect cloud services will be cheap enough to make many companies consider moving some of their infrastructure to this type of environment. It certainly eases the time and effort of building new machines and encourages better development habits.

As IT departments, especially the management of those groups consider using cloud type services, they still have to be aware that this isn't a savings that comes for free. Code changes, staffing skill growth and mindset evolutions to take into the account the challenges of working in a cloud environment, as well as the SLAs that seem to favor the cloud providers more than the cloud customers, mean this isn't an easy decision. Add to this the potential tax implications, and the decision to move away from current IT practices is not always obvious.

The idea of cloud computing, and cloud services, is still very immature. From the definition of what this means, to the offerings, to the architectures, the industry has a lot of growth to do before most of us will feel comfortable moving substantial parts of our infrastructure out of our own facilities.

» 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 : Security

Washington Hospital Hit By $1.03 Million Cyberheist - The costly cyberheist was carried out with the help of nearly 100 different accomplices in the United States who were hired through work-at-home job scams run by a crime gang that has been fleecing businesses for the past five years....(more)

Tech News : The Lighter Side

IBM enters film biz with atomic movie - IBM said it made the world's tiniest movie by using thousands of precisely-placed atoms to create nearly 250 frames of stop-motion action....(more)

25 Weirdest Things in the 'Internet of Things' - The Internet is slowly creeping into every part of our lives, and soon millions and millions of connected devices will all be talking to each other....(more)

SQL Server News : WebCasts

The Basics of Database Sharding - Database sharding is a flexible way of scaling out a database. In this presentation, Jeremiah Peschka explains how to scale out using database sharding, covers basic techniques, and shares some of the pitfalls....(more)

Microsoft News : General Interest

Cloud Produces $1 Billion for Microsoft - Windows Azure is now one of Microsoft's billion-dollar businesses....(more)

Microsoft News : Patches, Bugs

SQL Server Data-Tier Application Framework (May 2013) Available - This update to the Data-Tier Application Framework (DACFx) addresses a high-priority issue causing potential data corruption during DAC Package creation....(more)

Blogs : Administration

Tracking down Deadlocks in your SQL Database - Chris Skorlinski shares some tips for handling deadlocks in your SQL Database applications. You'll see the solutions for SQL Database are similar to on-premises SQL Server for which you'll well documented on web....(more)

Blogs : Analysis Services / BI

Taking Your Analytics Into the Cloud - If you've been itching to serve up your SAS analytics software from the cloud, you won't have to wait much longer....(more)

Blogs : Backup and Recovery

Compare SQL Failover Cluster Instance SQL and OS Node Versions using PowerShell - It is a common check to see if all of the nodes in a cluster are equally patched. The reason behind this is because in order to ensure stable operations and a consistent experience, it is best practice to have all nodes of a failover cluster instance (FCI) at the same build....(more)

Blogs : Big Data

USPS Leverages Big Data To Fight Fraud - When you think “big data,” you probably don’t think of the United States Postal Service. As it processes more than 528 million pieces of mail each day, the USPS has become an active participant in the big data revolution, and operates one of the most powerful non-classified supercomputing databases in the world....(more)

Little Data Remains Important in Healthcare IT - Electronic Health Records (EHR) were promoted as the end-all-be-all solution for the industry – a standardization that many thought would organically and naturally occur, stabilize, and be maintained. It hasn't. At least not yet....(more)

Linking Open Data to Augmented Intelligence and the Economy - After years of steady growth, open data is now entering into public discourse, particularly in the public sector. If President Barack Obama decides to put the White House’s long-awaited new open data mandate before the nation this spring, it will finally enter the mainstream....(more)

Blogs

Visualizing Data: Bad Labels, Easy Fix - Too often, people make simple charts hard to read by using software defaults and not thinking about reader needs....(more)

More businesses than you think are on the cutting edge - As a counterpart to his recent survey on what the oldest version of SQL Server you have in production (see the results here), Paul Randall kicked off a survey last week asking what the newest version of SQL Server is that you have in production....(more)

Blogs : Career

Top 8 sites for researching your next employer - Knowing where to find inside information can mean the difference between getting a job from a great company and heading down the wrong path....(more)

3 Steps to Finding Your Secret Sauce - It’s difficult to define why some things are wildly successful in a sea of forgettable products. Some recipes have a mysterious umami that comes from a subtle dash or two of magical sauce. In business and technology there’s an indefinable edge that sets people and teams apart. How do you get that special something?...(more)

Enhance your career by blogging! - When James Serra started his blog two years ago, he never would have thought how much it would help his career....(more)

Blogs : Computing in the Cloud

Benchmarking Amazon EC2: The wacky world of cloud performance - Cloud machines are not all alike, produced with precision like the boxes that sit on our desks. They're a bit like those cars of the '70s....(more)

The taxman cometh for cloud services - If you build it, they will come. And hot on their heels will be the tax collectors....(more)

Cloud SLAs 'fall short,' says user advocacy group - Service level agreements in the cloud computing market are skewed in the favor of providers, can be difficult for customers to decipher, and in some cases are rigid and non-negotiable say the Cloud Standards Customer Council....(more)

The “Consumerization” of IT and the Dark Side of the Cloud - Cloud computing is actually being largely driven by the “Consumerization of IT”. That phrase, as grammatically incorrect as it is, represents a fundamental change to the way businesses think about technology, and subsequently how the IT team provides it....(more)

Blogs : Database Design, Theory and Development

Who’s Afraid of the Big Bad Data Type - Data types seem so innocuous, but mistakes in their use can creep up on you like a flesh-eating zombie and destroy your project just when you least expect it. Dealing with strings seems so trivial, what could go wrong? An awful lot....(more)

Are you checking for possible integer overflow? - Rhys runs a couple of systems that stick a mass of records through on a daily basis. Without integer overflow checking, a data overload could be around the corner....(more)

Blogs : Events

TechEd 2013 North America and Europe Registration Open Now - The Microsoft TechEd 2013 Content Catalog is LIVE with hundreds of Breakout Sessions, Hands-on Labs and Instructor-led Labs, delivered by Microsoft and industry experts....(more)

PASS Virtual Chapter Events : May 2013 - PASS Virtual Chapters (VC) are interest-based forums that unite the SQL Server community through live webcasts with top SQL Server experts, online forums and resources – including an archive of past presentations, and special training events....(more)

SQL Server Events in the UK – May 2013 - Things are really ramping up in May and June this year, it’s a great time to be an IT Professional with so much free SQL Server training available! This month there are 9 events planned including the Europe’ premier SQL Server SQLBits....(more)

Blogs : Hardware

What is a FLOP? - Ever wonder about the meaning of a FLOP? Beyond a measure of number crunching, or simply the basis of the acronym – Floating Point Operation — what does FLOP mean for computing, and more specifically, supercomputing?...(more)

A SQL Server Hardware Tidbit a Day – Day 30 - For the final post in this series, Glenn Berry lists a few resources that you can use to help stay current with what is happening in the world of server hardware and storage....(more)

Blogs : Professional Development

Five Ways to Improve Your Productivity with SSMS - For most DBAs, Management Studio is the primary work tool, which is why using it properly can save a lot of time and effort. Here are a few tricks that can improve your productivity when working with it....(more)

Blogs : Software Development

Follow Amazon's Example: Dare to Talk About IT Costs, Prices - Software pricing is one of those arcane and secret processes where negotiations never see the light and final contracts hold service, support and upgrade gotchas can challenge the wiliest spreadsheet jockey....(more)

Blogs : Virtualization

Doing It Wrong: Virtualizing SQL Server - Thomas LaRock has been involved in virtualization projects for almost ten years now. In that time he's had the opportunity to track his own list of “best practice” items. It’s a list he share freely with clients and customers that seek me out for virtualization advice....(more)

Articles : Administration

Troubleshooting AlwaysOn – Sometimes it takes many sets of eyes - Aaron Bertrand discusses some obstacles he recently encountered when configuring an Availability Groups lab environment and how some assistance from the community helped him isolate and solve the issues....(more)


Administrative