In this issue:

Tech News : Data Mining/Warehousing

Tech News : General Interest

Tech News : Security

Microsoft News : Development

Microsoft News : General Interest

Microsoft News : Patches, Bugs

Hardware News

Blogs : Administration

Blogs : Analysis Services / BI

Blogs : Backup and Recovery

Blogs : Career

Blogs : Events

Blogs : Integration Services/ETL

Blogs : Performance and Tuning

Blogs : Replication

Blogs : Reporting Services

Blogs : Spatial Data

Blogs : SQL Server 2014

Blogs : T-SQL

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

SQL Developer Bundle 12 must-have SQL Server tools
The award-winning SQL Developer Bundle contains 12 tools for faster, simpler SQL Server development. Download a free trial.
SQL Server Concurrency Understand Locking, Blocking & Row Versioning
Read Kalen Delaney's eBook to understand SQL Server concurrency, and use SQL Monitor to pinpoint excessive blocking and deadlocking. Download free resources.
SQL Data Compare Compare and synchronize database contents
“I've been really missing a neat data comparison tool - SQL Data Compare Pro seems to be the answer to my prayers.” Jan Hansen, Database Architect. Download a free trial.
Editorial - The Loss of Trust

It's a sad day for data professionals. We've been entrusted with keeping data safe, information protected inside of our corporate walls. Many of us agonize and worry that we've missed something in our planning for potential data loss or theft. We fret and stress over the lack of resources devoted to security, wondering when, not if, we will suffer a breach. Many of us make efforts to implement encryption to protect our backup tapes.

That might all be for naught. It's sad that the US government, in the form of the NSA, apparently has access to much of our data. I doubt they have backdoors into our SQL Server instances, but perhaps they do. Who knows if there are trojans, viruses, or other digital constructs at play here. I'm sure the NSA would claim they are only looking for criminal activity, and we have nothing to worry about, but I'm not so sure that's the case.

If other agencies outside the NSA can request this data, how long before individual congressman or other officials start asking for data? How long before a bad movie plot becomes reality with lobbyists asking not for laws, but for information about competitors? In an era when it seems almost everything is for sale, is that far-fetched? If Microsoft, Google, and Facebook comply with government requests, who's to say Symmantec isn't ignoring the domestic equivalent of Stuxnet inside corporate systems?

I've seen articles about how to protect yourself or your company, including encrypting everything to cause more of a headache, but I'm not sure any of that will help. The NSA is constantly working on better ways to break encryption, and when that doesn't work, they strong-arm companies. I wouldn't count on these even super strong server protection, since I'm sure the NSA would just look to attack clients instead of servers, getting information as it's being transferred or accessed.

This is a sad day for data, security, and privacy. Perhaps it's been so for a long time, but it's naive to think this is just an NSA problem. There's a moral issue involved with assuming anyone or any group has the right to view another organization's data. There's also a security issue. The NSA might have built back doors, or exploited the architecture of the current digital infrastructure, but as we all know, not a lot remains secret on the Internet for long. Other countries and organizations will take advantage of any issue; perhaps they already are.

The digital world dramatically levels the playing field for all participants, big or small. After all, for over 50 years, it's been the domain of countries alone to send payloads into space and bring back the spacecraft. Not too long ago a computer programmer did it with his own company. Size truly doesn't matter in the digital world.

» 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 : Data Mining/Warehousing

Why Your Brain Needs Data Visualization - The size and speed of your data is growing exponentially, the world of analytics is changing - and we want you to be ahead of the curve....(more)

Tech News : General Interest

SQLCAT.com consolidated index of Whitepapers - In an effort to migrate as much content as possible from SQLCAT.com to the MSDN SQL CAT site we have consolidated all of the Whitepapers published over the last few years.   While all of the content actually exists on Technet and MSDN download sites, ......(more)

Meet the new hotness: All-in-one 3D printer-and-scanners - Meet Radiant Fabrication's Lionhead Bunny. Radiant Fabrication We’ve told you about inexpensive 3D printers. We’ve reported on the first two 3D scanners. And recently, Ars editor Lee Hutchinson took two 3D printers for a spin to reveal what he called ......(more)

Windows 8 more widely used than OS X, IE still on the rise - Net Market Share In July, Windows 8 passed Windows Vista in market share. In August, it passed every single version of Apple's OS X combined. Internet Explorer 10 grew sharply, too, as almost one in five Internet users now use the latest version of ......(more)

Tech News : Security

The NSA's Cryptographic Capabilities - The latest Snowden document is the US intelligence...(more)

How to secure your company against NSA-inspired hacking - The same techniques used by the NSA can also be used by others. These simple steps can reduce -- but not eliminate -- your company's exposure...(more)

Security expert Schneier calls for more to reveal gov’t spying methods - There are still big holes in today's revelations that the NSA is well on its way to bypassing key forms of Internet encryption, including Virtual Private Networks and the Secure Socket Layer and Transport Layer Security protocols. Today's stories in ......(more)

Let us count the ways: How the feds (legally, technically) get our data - beardenb Given that we now know that the National Security Agency (NSA) has the ability to compromise some, if not all of VPN, SSL, and TLS forms of data transmission hardening, it’s worth considering the various vectors of technical and legal data-gathering ......(more)

Our Newfound Fear of Risk - We're afraid of risk. It's a normal part of life, but we're increasingly unwilling to accept it at any level. So we turn to technology to protect us. The problem is that technological security measures aren't free. They cost money, of course, but they ......(more)

Microsoft News : Development

Visual Studio 2013 Release Candidate inches closer - Microsoft may be poised to deliver the near-final release candidate of Visual Studio 2013 sooner rather than later....(more)

Microsoft News : General Interest

Microsoft readies rumored Power Cover for Surface: Reports - Microsoft's rumored new Surface keyboard/covers that feature built-in batteries for extra power will arrive some time after the new Surfaces launch, according to new reports....(more)

Microsoft's Haswell-based Surface Pro 2: The leaks begin - Microsoft's new Surface Pro 2 is expected, unsurprisingly, to be a Core i5 'Haswell' based update to the current Surface Pro, according to new reports....(more)

Microsoft News : Patches, Bugs

Microsoft to patch dangerous Outlook hack-by-preview bug next week - Microsoft today said it will ship 14 security updates next week to patch critical vulnerabilities in Internet Explorer (IE), Windows, Office, and SharePoint, its enterprise collaboration platform. The IE update, slated to affect every supported version, ......(more)

Hardware News

Lenovo Showcases New Yoga, Flex Multimode Devices - ...(more)

Sony Debuts New Vaio Flip Convertible Line of Notebooks - ...(more)

Blogs : Administration

Five SQL Server Settings to Change - SQL Server ships with sane defaults, right? Well, sort of. SQL Server ships with pretty sane defaults for a single CPU socket server or for a development work station. Honestly, the defaults are good enough for many things, but there are a few gotchas....(more)

Rebuild or Reorganize: Index Maintenance Can Save Your Job - Index maintenance compacts a structure *and* changes physical order– both can be important!Once up on a time, there was a database server with 500GB of data and a heavy read workload of dynamic queries. Data was updated frequently throughout the day ......(more)

Blogs : Analysis Services / BI

Handling Large Many to Many bridge tables - In some scenarios you will need to create a many to many relationship in your cube in SSAS. One of the problems that arise from many to many bridge tables are the size of these tables. In this example we have a fact table that contains the history of ......(more)

Power BI (Part 1 – Getting Started) - Microsoft Team and Organizational BI has been often criticized about its complexity and price because it requires SharePoint Server Enterprise for deploying Power Pivot models and dashboards. If cloud deployment is an option for your organization, Power ......(more)

Blogs : Backup and Recovery

SQL Server – How to Perform Striped Database Backup - Even though there are more pros than cons, Striping database backups are often overlooked by many DBAs. Based on my observations in our environment, striping can significantly benefit larger database backups (~500 GB). As shown in the picture below, ......(more)

Blogs : Career

One for My SQL Sisters - Women, for the entire male half of the population, I apologize.Those who know me well recognize, pretty easily, that I am hardly “politically correct.” My mode of address can be blunt and even rude. But… I think it’s also recognized that I’m very even-handed ......(more)

Is Microsoft's Certification Program Value Microsoft's Fault? - I'd be interested if anyone says,...(more)

Microsoft ends top Masters certification exams for IT pros - Microsoft plans to retire its Masters level certification exams by Oct. 1 this year, generating strong protests on blogs and community forums from IT professionals. The Redmond, Washington, software company, however, defended the move, with an executive ......(more)

How to Get Your Manager to Pay for Training - When us geeks want something, we just point at it, look at our manager and say, “I want this. Buy it for me.”Oddly, it doesn’t seem to work.To get what we want, we have to think like a manager.Step 1. Define a user’s Pain Point.You need someone else ......(more)

Blogs : Events

SQL in the City 2013 US Tour - It was a huge honor to be chosen for the 2013 US tour of SQL in the City. Red Gate put on a phenomenal tour in 2012 hitting 6 major cities. This year they are bringing the event back. This year will bring Red Gate to Pasadena on October 9th, Atlanta ......(more)

New classes for 2014 in Tampa, Chicago, Bellevue, Australia open for registration - Kimberly’s been hard at work finalizing details of the classes we’ll be offering in the first half of 2014 and we have 17 new classes open for registration, covering the whole range of courses we teach.Where are we going?We’re heading to Tampa, Chicago, ......(more)

Querying Microsoft SQL Server 2012 Databases Jump Start–September 13th - If you’re already familiar with database fundamentals and you’ve worked with SQL Server, the Querying Microsoft SQL Server 2012 Databases Jump Start course will help you take your skills to the next level. You’ll learn about data manipulation and how ......(more)

Expert Database Design Tips for SQL Server and Azure - Data designers and DBAs need to understand the logical, physical, and technical differences in designing and managing Windows Azure SQL Databases (WASDs) and traditional, on-premise SQL Server databases. In this session, we'll review the concepts that still work in both and the features that need to be tailored to each target environment. Please join renown data architect, Karen Lopez and Sr. DBA, Thomas LaRock for this live event. You’ll see demonstrations of the database design processes and gain best practices for model-driven development for each environment, including tool support. We will discuss tips and tricks for creating and maintaining WASD database designs. They’ll finish up with 5 tips for designing and managing performance for both SQL Server and WASD....(more)

SQL in the City US Tour - Red Gate is bringing top SQL Server MVPs and their own developers on tour with SQL in the City. Catch them at one of their events this October in Atlanta, Charlotte, and Pasadena. These free events will provide multiple opportunities to build SQL Server knowledge. Sessions will cover SQL Server topics like Database deployment, query performance tuning, and core monitoring. Red Gate is also hosting free SQL in the City Seminars this September on the Fridays before SQL Saturday San Diego and Denver. ...(more)

Blogs : Integration Services/ETL

My thought on data pipeline - We learned many lesson during developing and using SQL Azure Dashboard for live site troubleshooting. We also collected and learned how other team do data pipeline and data driven decision. In this document, we provide some initial thought on how we ......(more)

Comparing Data Quality Services (DQS) and Master Data Services (MDS) - This post describes some of the ways that Data Quality Services (DQS) and Master Data Services (MDS) differ in their processes and some of the ways in which they are similar. The information in this post is taken from the Cleanse and Match Master Data ......(more)

Converting SQL_VARIANT on PDW - There are a number of data types that are currently unsupported on PDW. Among those are SQL_VARIANT. The interesting part of that is that SQL_VARIANT along with several other unsupported data types are found all over the place in system tables in PDW....(more)

Blogs : Performance and Tuning

SQL – Find CPU,Memory,Connections, VLF’s,I/O of all the Databases - Find CPU, Memory, No Of Connections/databases and VLF’s and I/O details in one single script. You just need to run the below T-SQL in SSMSDownload the code here Metrics*****************************************************************************USE ......(more)

Performance Surprises and Assumptions : DATEDIFF - SQL Sentry's Aaron Bertrand (@AaronBertrand) investigates a case where two different methods of deriving an inline constant can lead to very different cardinality estimates....(more)

SQL Server Internals: Nested Loops Prefetching - Nested loops join query plans can be a lot more interesting (and complicated!) than is commonly realized. One query plan area I get asked about a lot is prefetching. It is not documented in full detail anywhere, so this seems like a good topic to address ......(more)

Geek City: How old are my statistics? - This post is basically to answer a question asked in class this week: How can we get the last statistics update date for ALL user tables in a database? After working on the query for a while, I realized that the new metadata function I posted about here ......(more)

Forced Parameterization Can Lead to Poor Performance - Something that is a relatively common performance eye opener is when you have a large ad hoc workload, and you’re getting a huge gap in the lack of plan reuse.  You talk to the application team that is responsible for this possibly dreaded scenario and ......(more)

Blogs : Replication

Replicated Stored Procedure Execution - One feature that many of my clients are unaware of is that the batched execution of a stored procedure can be replicated under certain circumstances. This can result in significant improvement in performance for stored procedures on replicated databases.This ......(more)

Blogs : Reporting Services

SSIS ReportingPack v1.1.1.0 – Execution Stats visualised in a Gannt chart via usp_ssiscatalog - There are many SSRS reports in SSIS Reporting Pack and the one I’ve perhaps spent most time on is the executable_duration report which provides this visualisation: I happen to think this is really useful because it shows the start time and duration ......(more)

Blogs : Spatial Data

Optimizing SQL Server Spatial Queries with Bounding Box - SQL Server supports two data types to store spatial information – geometry and geography. Geometry supports planar, or Euclidean, flat-earth data. Geography supports ellipsoidal round-earth surface. Both data types can be used to store location information, ......(more)

Blogs : SQL Server 2014

Solving Session Management Database Bottlenecks with In-Memory OLTP - As we started working with early adopters on the SQL Server 2014 In-memory OLTP engine (project codenamed Hekaton) one of the first scenarios we ran into involved a session management database in SQL Server. The application was a high volume website ......(more)

Blogs : T-SQL

sp_executesql, Parameters and Parameter Sniffing - I’m honestly not crazy about dynamic T-SQL within stored procedures. There are just a few too many opportunities to mess it up with dire circumstances to your server and your data. However, I absolutely recognize that dynamic T-SQL may be needed, and, ......(more)

SQL SERVER – Simple Puzzle with UNION - It has been a long time since played a simple game on SQLAuthority.com. Let us play a simple game today. It is very simple puzzle but indeed a fun one.First let us execute following SQL.Query 1:SELECT 1UNION ALLSELECT 1ORDER BY 1It will return ......(more)


Administrative