In this issue:

Vendors/3rd Party Products

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

Blogs : Database Design, Theory and Development

Blogs : DMO/SMO/Powershell

Blogs : Events

Blogs : High Availability/Disaster Recovery

Blogs : Integration Services/ETL

Blogs : Performance and Tuning

Blogs : Reporting Services

Blogs : Software Development

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-10-07

SQL Developer Bundle Countless happy developers. One award-winning bundle.
The SQL Developer Bundle can transform the way you and your team work, aiding collaboration, efficiency, and consistency. Download your free trial now.
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.

SQL Compare Need to compare and sync database schemas?
Let SQL Compare do the hard work. ”With the productivity I'll get out of this tool, it's like buying time.” Robert Sondles. Download a free trial.
Editorial - IT Security

IT security is a concern for many businesses. At least that's what a survey at the recent Black Hat conference concluded. Most of the respondents couldn't be sure that a foreign state-sponsored attack had not occurred in their networks. About half of the people were not confident that their staff could even detect an attacker. That's a little scary as many of the people felt their systems might come under attack within the next year.

Digital technology has changed the world in many ways, but one of the most amazing to me is how it has leveled the environment in which all of us can interact. No longer does communication, publication, research, even war require the resources of a country or even a large organization. In the cyber world an individual can make as much impact as a large entity. As with most things, this is a double edged sword, and I'm sure many of us will find that vandalism, as well as malicious attacks on our systems will increase in the future.

However the threats, or perhaps the consequences, aren't severe enough yet. Most companies allow shoddy code, vulnerable to SQL Injection, to pervade their internal (and sometimes external) applications. Security training is limited, and review of third party applications is extremely lax. The respondents at Black Hat are making efforts, but those are a self-selective group. Most organizations would never send an employee to Black Hat events or even monitor the trends and information published by groups like SANS.

I do believe that security will become more and more of an issue. I suspect, however, that until businesses are liable, and decide to purchase insurance, we won't see much change. Once insurance premiums start to depend on the level of security you implement, I suspect we'll see the quality of application code increase.

» 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.


Vendors/3rd Party Products

New SQL Monitor Performance Metric: Plan Cache: Cache Pages Total - This metric collects the total amount of memory, in kilobytes, used by the plan cache of an instance to help identify memory pressure or plan cache pollution. It is similar to the SQL Server: memory manager: SQL cache memory counter, but instead of providing the number of 8-kilobyte pages that make up the plan cache, it provides the total memory used....(more)

Tech News : General Interest

European organizations file lawsuit against UK over vast digital surveillance - The European Court of Human Rights hears 50,000 cases each year. Emiliano Three United Kingdom-based nonprofit organizations and a German Internet activist have filed a lawsuit against the British government at the European Court of Human Rights ......(more)

Tech News : Security

IT Security a Major Concern for Businesses - To combat state-sponsored attacks, 90 percent of respondents to a recent survey had made efforts to protect themselves....(more)

How Bad is the Adobe Breach, Really? - Adobe has confirmed a massive hack that led to the theft of the private information of 2.9 million customers. The hacked data includes consumer names, encrypted credit or debit card numbers, expiration dates, and other information relating to customer ......(more)

Microsoft: User Data Requests Top 37,000 in the First Half - New figures show that the number of Microsoft's cloud users under law-enforcement scrutiny is on pace to nearly match last year's record....(more)

John McAfee Building Gadget To Fake Out NSA - He is best known for developing software that helps thwart hackers who would steal our passwords and other valuable information. Now, John McAfee has come up with a way to thwart the biggest hacker of all -- the National Security Agency (NSA).It's ......(more)

Microsoft News : Development

Microsoft discloses Visual Studio 2013 pricing, rollout plans - Microsoft will be rolling out its latest Visual Studio development-tool suite starting in mid-October. Pricing will remain in line with that of the current VS 2012 suite....(more)

Microsoft News : General Interest

Microsoft's Ballmer gets docked for Windows 8, Surface RT - Microsoft CEO Steve Ballmer recieved 76 percent of the total incentive award for which he was eligible in fiscal 2013. Issues plaguing the Windows division were to blame....(more)

Windows Azure Cloud Platform Gets Two-Factor Authentication--Big Time - NEWS ANALYSIS: At long last, Microsoft's Windows Azure multifactor authentication system lets users set up real security to protect cloud account access....(more)

Microsoft Investors Want Bill Gates Out as Chairman - ...(more)

Microsoft News : Patches, Bugs

Microsoft to patch zero-day IE bug now under attack - Microsoft today said it will ship eight security updates next week to patch critical vulnerabilities in Windows and Internet Explorer (IE), with the one aimed at IE plugging the hole attackers have been exploiting for months....(more)

Hardware News

Microsoft's Surface 2 with LTE to debut on AT - Microsoft's first LTE-enabled Surface 2 tablets will debut on AT...(more)

Blogs : Administration

Invalid or loopback address when configuring SharePoint against a SQL Server - I was presented with a connectivity issue when trying to configure SharePoint 2013 using a CTP build of SQL 2014.  They got the following error when they were it was trying to create the Configuration Database. Exception: System.ArgumentException: myserver,50000 ......(more)

Blogs : Analysis Services / BI

Sharing Functions In Power Query - The Power BI Preview includes the ability to share Power Query queries with other people in your organisation; I was thinking about writing a blog post on this topic, but to be honest the documentation covers it so well there’s little point repeating ......(more)

Using USERELATIONSHIP function in Measures and Calculated Columns - ...(more)

Top 10 Best Practices for Building a Large Scale Relational Data Warehouse - As of September 1, 2013 we decided to remove SQLCAT.COM site and use MSDN as the primary vehicle to post new SQL Server content. This was done to minimize reader confusion and to streamline content publication.  MSDN SQLCAT blogs already includes most ......(more)

Blogs : Backup and Recovery

Recovering the tail end of the transaction log - Knowing a great deal about backup and recovery is key to any DBA’s career. Most of us fully understand the recovery models, recovery point objectives and recovery time objectives. What I have found from speaking at many SQL Saturday’s and User Groups ......(more)

Database maintenance and when is it needed (Part 5: Back Up Database) - This week we are closing our discussion regarding database maintenance steps, with the most important database maintenance of all:...(more)

Blogs : Career

The Myth of the Rockstar Programmer - The Myth of the Rockstar Programmer is just that, a myth. It's an unfortunate myth for a number of reasons. It sets an unreasonable expectation for regular folks. Calling out rockstars demotivates the team. Telling someone they are a rockstar may ......(more)

My Favorite Things About Being a DBA - I get to work with everybody. Developers need to push data in and out of the database. End users want to get reports out. Executives want to make better decisions. Vendors need to update code. Anytime something’s happening in the company, I’m one of ......(more)

Blogs : Computing in the Cloud

Microsoft's Windows Azure Meets Federal Security Standards - The FedRAMP stamp of approval puts Azure in the running for U.S. federal government workloads that are destined for the cloud....(more)

Blogs : Database Design, Theory and Development

New online course: Why Physical Database Design Matters - Kimberly’s first Pluralsight online training course went live today: SQL Server: Why Physical Database Design MattersIt’s 4 hours long and is the first in a multi-part series on performance.The modules in this course are:IntroductionData Types and ......(more)

Blogs : DMO/SMO/Powershell

Setting Up a Domain Controller with PowerShell - Quickly setting up a domain controller is a vital step in creating a good demo environment. This post will walk you through a quick and easy set of scripts to get started.Step 1: Download and Install Windows Server 2012If you don’t already have a blank ......(more)

Blogs : Events

New In-Person Training Class Bonus: Video Home Studies - For our classes next year, we’re kicking it up a notch. When you buy a seat in our How to Be a Senior DBA or SQL Server Performance Troubleshooting classes, you’ll also get 2 hours of video training right away.The more you know, the better questions ......(more)

Blogs : High Availability/Disaster Recovery

Error during installation of an SQL server Failover Cluster Instance - A common issue I've run into while helping with SQL Server Failover Cluster (FCI) installations is the failure of the Network Name. In the following post I'll discuss a bit of background, the common root cause, and how to resolve it. Background The ......(more)

Blogs : Integration Services/ETL

Stupid me - Building a script component....(more)

SQL Server – How to Copy or Export an SSIS Package Using Command Prompt Utility – DTUTIL - The command prompt utility dtutil can be very handy when we want to quickly export an SSIS package from either file system to msdb or vice-versa. For a quick demo, I created a package called “ProductPrice” uder the file system C:\packages, as shown in ......(more)

Blogs : Performance and Tuning

Need for Queue Depth Control in SQL Server IO - I have complained about lack of queue depth control in SQL Server IO before and I am complaining again. I fully understand the desire to restrict the number of knobs, which used incorrectly can cause more harm than good. The main point about IO queue ......(more)

Solving SQL Server Scalability Problems - You’ve been nursing your SQL Server through day after day of increasing load. Stored procedures are taking longer and longer to run. There are timeouts on the client side. Both customers and management are getting upset. As you’re bemoaning the terrible ......(more)

How Much RAM Does Your New Database Server Need? - Glenn Berry (@GlennAlanBerry) of SQLskills.com talks about memory limits on certain versions and editions of SQL Server, and ways to determine the optimal amount of memory to put in your servers....(more)

How It Works: Maximizing Max Degree Of Parallelism (MAXDOP) - I was working on an index build issue for an 80 CPU system and kept seeing that only 64 CPUs were getting used. I had carefully studied sys.dm_os_spinlock_stats and sys.dm_os_wait_stats along with performance counters, memory usage pattern, and I/O activities.   ......(more)

Blogs : Reporting Services

SSRS Parameters, Authentication, and SharePoint Integration -- Test Your Knowledge - We now have several SQL Server Reporting Services 2012 (SSRS) quizzes that you can use to test you knowledge about configuring parameters, authentication features, and integration with SharePoint. The quizzes include links to documentation related to ......(more)

Making Tables Look Good - I could be talking about the tables in my database – I do make them skinny by using the right data types – but in this case I’m talking about SQL Server Reporting Services tables. You’ve seen them before. The average table is bland and boring, with nothing ......(more)

Blogs : Software Development

NHibernate and Stored Procedures in C - ...(more)

Blogs : SQL Server 2014

In-Memory OLTP Programmability: Concurrency and Transaction Isolation for Memory-optimized Tables - The new In-Memory OLTP feature introduces memory-optimized tables and natively compiled stored procedures in SQL Server 2014, to optimize performance and scalability of OLTP workloads. To benefit from this technology in an existing SQL Server application, ......(more)

Blogs : T-SQL

T-SQL Tuesday - ...(more)


Administrative