In this issue:

Tech News : Security

Microsoft News : Security

Blogs : High Availability/Disaster Recovery

Blogs : Performance and Tuning

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

SQL Search How do you search your database schema?
"I use SQL Search regularly and think it's great." Gregor Suttie, Senior Software Engineer, Pulsion Technology. Download Red Gate SQL Search while it's free.
SQL DBA Bundle ‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now.
SQL Developer Bundle 12 essential tools for database professionals
The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.
Editorial - Trust

An interesting piece I found on Bruce Schneier's blog that talks about security and trust, specifically with regards to the security of your passwords and password managers (which I hope you use). There certainly are problems and potential issues with regards to security and passwords, no matter how you choose to manage those.

However the part of the article that caught my eye was the opening, where it says "All these other industries we rely on have evolved codes of conduct, regulations, and ultimately laws to ensure minimum quality, reliability and trust. In this light, I find the modern technosphere's complete disdain for obtaining and retaining trust baffling, arrogant and at times enraging."

Is that true? I know we find that there are more systems in the pharmaceutical, construction, and other professions. These independent groups can provide some certification, evaluation, and standards for their members and practitioners.  I'm not sure how much more trust there is in these fields, and sometimes I think it's just an illusion of more standards and practices. We find all sorts of moral, and professional failures in these businesses, though perhaps more accountability in the legal sense.

Is it because these professions are more mature? Perhaps. In some sense, I think many of these fields benefit from the reality of their products and services. We can see, hear, feel, and touch the effects of decisions and actions in most fields. We can interact with our technological systems, but in many cases the complexity behind simple interactions is more like magic to most people that we'd care to admit.

Plus we seem to be quite willing to build things that don't work well, and then quickly change them to respond to issues. In some cases we might be more like the people that build quasi-useful products hawked on late night television than the engineers that construct bridges.

» 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

The NSA upshot: We're finally taking Internet privacy seriously - The debate over Snowden's status as PRISM leaker obscures real issue: The reach of the Fourth Amendment in a digital age...(more)

NSA's lax ban on USB drives may have contributed to PRISM leaks - News about the NSA and FBI's surveillance programs...(more)

Microsoft News : Security

Microsoft Locks Down the Cloud With Multifactor Authentication - Microsoft makes its Windows Azure cloud services platform a bit more hacker-resistant with a security feature that Web-facing tech companies are increasingly embracing....(more)

Microsoft Study Finds Gap in SMB Cloud Perception, Reality - Small- and medium-size businesses have been wary of cloud services because of security, privacy and reliability issues. But a new Microsoft report, released this week, found that perceptions of clouds contrast with actual experiences. ...(more)

Blogs : High Availability/Disaster Recovery

Using SMB shares with Hyper-V Replica - SMB is getting a lot of attention with Windows Server 2012, and we’ve had questions from a few customers regarding the inter-play between SMB shares and Hyper-V Replica. In this post we’ll share our experience around setting up and using various configurations involving SMB shares and Hyper-V Replica. The issue we were expecting to run into is the apparent lack of authorization to use the SMB share, when using remote management....(more)

Blogs : Performance and Tuning

Improving performance by using SET STATISTICS IO - When I started using SQL Server the company I was working for at the time had no skill in this area, they were more focussed on other platforms and so I had nobody to learn from. The community was in it’s infancy and I had no idea people would blog about this kind of stuff. You were pretty much limited to what was in Books Online and that was kind of dry and hard to navigate....(more)

The Index Your Queries will Never Request (A Clustered Index!) - When it comes to indexes, SQL Server is really helpful. It lets you see what indexes queries are asking for both in execution plans, and missing index dynamic management views (“DMVs”). I like to look at the DMV missing index requests using sp_BlitzIndex™....(more)

Blogs : T-SQL

How to Pass Calculated Columns in the WHERE & GROUP BY clause in T-SQL..? - Suppose we have a calculated Column that is a result of some complex calculation and we want to refer it in a where clause (or a group by clause). This is not straight forward since we can’t use the computed Column directly in the where clause like this: ...(more)


Administrative