The Complete Weekly Roundup of SQL Server News

In this issue:

Vendors/3rd Party Products

Tech News : General Interest

Tech News : Security

Tech News : The Lighter Side

Microsoft News : Downloads

Microsoft News : General Interest

Microsoft News : Patches, Bugs

Microsoft News : Security

Blogs : Administration

Blogs : Analysis Services / BI

Blogs : Backup and Recovery

Blogs : Career

Blogs : Computing in the Cloud

Blogs : Database Design, Theory and Development

Blogs : Developer Tools

Blogs : Security and Auditing

Blogs : SQL Server 2014

Articles : Administration

Articles

Articles : Development

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 2014-04-19

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

Looking for participants for deployment process feedback - The Red Gate Database Delivery team is looking for people willing to participate in UX sessions for a brand new product, with $50 Amazon vouchers for participants....(more)

Tech News : General Interest

Good Data Makes Good Neighbors - A new site offers neighborhood profile data -- submitted by residents -- to help prospective home buyers and renters in their searches....(more)

Tech News : Security

Nearly 1 in 5 Say They've Had Data Stolen, Pew Poll Finds - Eighteen percent of online adults in the U.S. have had important personal data stolen. That key takeaway from a new Pew Research Center study highlights the crisis in data protection....(more)

Private crypto keys are accessible to Heartbleed hackers, new data shows - Contrary to previous suspicions, it is possible for hackers exploiting the catastrophic vulnerability dubbed Heartbleed to extract private encryption keys from vulnerable websites....(more)

Tech News : The Lighter Side

Servers as Radiators: Can a Data Center Heat Stockholm? - Sweden's Bahnhof are known for creating offbeat data center designs. There a modular solution that looks like a space station. There was an idea to retrofit an old gas tower. Now the company is talking about recycling the heat generated from the data center to heat surrounding housing....(more)

Escape from Windows XP, Now a Game - Escape from XP, proudly brought to you by the Internet Explorer team....(more)

Microsoft News : Downloads

MSDN Whitepaper: More Cowbell—Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator - Hot off the presses is this new MSDN white paper: Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator...(more)

Microsoft News : General Interest

Microsoft: Let us be your one stop for big data analytics - If there was any question that Microsoft wants to be everyone's data analytics shop, the company erased those doubts with its recent presentation. ...(more)

Microsoft News : Patches, Bugs

Microsoft confirms it's dropping Windows 8.1 support - Microsoft has announced that Windows 8.1 users must upgrade to Windows 8.1 Update if they want security patches....(more)

Microsoft News : Security

Microsoft Services unaffected by OpenSSL "Heartbleed" vulnerability - After a thorough investigation, Microsoft determined that Microsoft Account, Microsoft Azure, Office 365, Yammer and Skype, along with most Microsoft Services, are not impacted by the OpenSSL “Heartbleed” vulnerability....(more)

Microsoft Azure Data Privacy Measures Win EU Approval - Microsoft's cloud computing platform meets the European Union's stringent privacy laws....(more)

Blogs : Administration

How to Run PowerShell Scripts with Administrative Privileges - Sooner or later, as you begin to hone your PowerShell skills, you’ll start writing scripts to automate repetitive tasks....(more)

Searching for Strings in SQL Server Databases - Sometimes, you just want to do a search in a SQL Server database as if you were using a search engine like Google. Besides the obvious Full-Text search, there are plenty of techniques for finding that pesky data that resists the normal SELECT blandishments. ...(more)

Blogs : Analysis Services / BI

Analytics Roadblocks: Tech Isn't the Problem - When a business solution or tool is in the pilot stage, hardware, software, and know-how are the challenges. Once the technical hurdles are cleared, enterprise management and workers must get on board....(more)

Blogs : Backup and Recovery

SQL SERVER – Tools for Proactive DBAs – Central Management Server – Notes from the Field #024 - In this episode of the Notes from the Field series database expert John Sterrett (Group Principal at Linchpin People) explains a very common issue DBAs and developers faces in their career and is related to AlwaysOn Availability Group....(more)

VMware Brings Disaster Recovery to the Cloud - Disaster recovery services are nothing new, but VMware vCloud Hybrid Service Disaster Recovery is. The virtualization company just rolled out a new cloud-based disaster recovery service for VMware virtualized data centers....(more)

Keeping Money in the Bank: Managing Data Protection in Today’s Data-Driven World - By leveraging the best practices in storage outlined in this post, organizations can spend more time on innovation and less on managing inefficient infrastructure, writes Tom O'Brien of IBM Tivoli Storage Manager....(more)

Blogs : Career

How does it feel to give a terrible conference talk? - Have you been to a conference and sat through an awful presentation and wondered just how on Earth someone got there?...(more)

Blogs : Computing in the Cloud

SQL Server 2014 Backup to the Cloud - Backing up SQL Server to the cloud makes a lot of sense, particularly for small businesses. Managing the physical media takes up too much time and effort for a small shop. Azure storage simplifies the backup process allowing a small business to allocate its limited resources more effectively....(more)

Blogs : Database Design, Theory and Development

Life of a SQL Query – Query States - From the moment a query request is made until the query response is delivered, what really happens to your query in SQL Server? Let’s find out, and talk about why that matters to you....(more)

Rounding versus truncating - Be careful when implicitly converting data types in T-SQL. Directly assigning 1.5 (either as a FLOAT or a NUMERIC) to an INT value in SQL Server may truncate the value to 1 rather than rounding it up as you might expect....(more)

From where does SSMS get its database defaults? - Where does SQL get the default values from when we create a database without any options?...(more)

Silos and Monoliths – Moving On to the Past - Phil Factor applies the wisdom of his years in IT to the issue of shared vs. siloed databases for applications....(more)

Blogs : Developer Tools

SQLAuthority News – Microsoft Whitepaper – Idle Connection Resiliency - Developers can write data access application that enables ideal connection resiliency with the .NET framework. An idle connection is the one that is active but it’s not executing a command or waiting for data. It is very important to understand how idle connection is reconnecting back in the .NET framework with SQL Server....(more)

Blogs : Security and Auditing

Why should passwords be encrypted if they’re stored in a secure database? - Detailed responses to a crucial security question....(more)

Blogs : SQL Server 2014

SQL Server 2014 Buffer Pool Extensions - SQL Server 2014 contains some interesting new features. Although SQL Server Standard Edition is limited to 128GB of memory, teams deploying on Standard Edition have an option to fit more of their working set in low latency storage: SQL Server Buffer Pool Extensions....(more)

Articles : Administration

Searching for Strings in SQL Server Databases - Sometimes, you just want to do a search in a SQL Server database as if you were using a search engine like Google. Besides the obvious Full-Text search, there are plenty of techniques for finding that pesky data that resists the normal SELECT blandishments. Phil Factor describes some alternative techniques....(more)

Implementing the Recycle Bin Pattern In SQL - Michael J. Swart explains what a recent hackathon showed him about the Recycle Bin Pattern In SQL Server....(more)

Articles

Microservices is SOA, for those who know what SOA is - Microservices is just a Service Oriented Delivery approach for a well architected SOA solution. SOA provides the contextual framework, provides most of the rules that Microservices aims to adhere to but more over gives a broader context within which Microservices fit within a complex enterprise. ...(more)

Articles : Development

Database Delivery Patterns and Practices - Our sister site Simple-Talk have gathered together all of their articles on database delivery in a single place, along with some other resources. The series is set to grow, so check back if this is an area that interests you....(more)

Open Source is a thankless job. We do it anyway. - Open Source is hard. Security is hard. We increasingly rely on open source projects, but they're frequently underfunded and understaffed....(more)


Administrative