In this issue:

Vendors/3rd Party Products

Tech News : Data Mining/Warehousing

Tech News : General Interest

Tech News : Security

Tech News : The Lighter Side

Microsoft News : General Interest

Blogs : Administration

Blogs : Backup and Recovery

Blogs : Computing in the Cloud

Blogs : DBA Tools

Blogs : Deep Into Windows

Blogs : DMO/SMO/Powershell

Blogs : Performance and Tuning

Blogs : Security and Auditing

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

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 Custom Metric: Untrusted Check Constraints - This metric returns the number of check constraints that have their is_not_trusted flag set to 1 in the sys.check_constraints table. Untrusted constraints force SQL Server to construct less efficient query plans, because it doesn’t know enough about the kind of data contained in the table. This can point to a data integrity issue which should be investigated....(more)

Tech News : Data Mining/Warehousing

Wishing You the Happiest of Holidays - Some fun statistics about the Fourth of July from All Analytics. ...(more)

Tech News : General Interest

Latest Oracle Database 12c 'Designed for the Cloud' - Typically, Software-as-a-Service configurations involved various customers sharing a multi-tenant application but separate data. Oracle said that, by flipping this model in 12c, it can achieve better security, among other advantages. However, pluggable, multi-tenant database functionality will not be part of the regular Oracle fees, but will come as a separately priced option....(more)

SkyDrive in Windows 8.1: Cloud storage the way it’s meant to be - Instant access to all your files with much less syncing....(more)

All the Google Products That Google Itself Has Killed Dead - Google is responsible for giving birth to tools that have changed the entire world: Google search, Gmail, Android and so forth. It should be celebrated! However, Google is also responsible for the death of many of its own products as it re-focuses its priorities: Google Labs, Google Reader and many other less celebrated Google products. ...(more)

A Google Reader Replacement - Google Reader closed it's doors on July 1. Phil Haack presents his preferred alternatives (Feedly and Go Read) for any making the switch at the last second....(more)

Tech News : Security

Rampant Apache website attack hits visitors with highly malicious software - Darkleech is back. Or maybe it never left. Either way, it's a growing problem....(more)

Facebook's Android app snags your mobile number the moment you launch it - Facebook says it will fix the issue, but the company is testing users' tolerance for poor data security...(more)

Tech News : The Lighter Side

Chicken chicken chicken: chicken chicken - Chicken: a simple language with a single keyword...(more)

Microsoft News : General Interest

Microsoft killing off TechNet subscriptions - Microsoft is set to end its TechNet subscription scheme. Started in 1998, TechNet subscriptions gave IT professionals perpetual licenses to Windows client and server operating systems. Though these licenses were technically only authorized for evaluation purposes, many used them as cheap Windows licenses for personal machines....(more)

What's behind Microsoft's pending reorg? - Microsoft is in make-over mode. The company needs to make sure it can create services running across a family of devices -- not just its own, but non-Windows-based ones, too -- at a quicker pace. ...(more)

Blogs : Administration

Optimal SQL MaxServerMemory Setting TSQL- All Versions - Based on certain assumptions regarding optimal settings for MaxServerMemory, Tara Shankar Jan provides a script to set it appropriately....(more)

Support timelines for SQL Server, .NET Framework, Visual Studio, Team Foundation Server and Windows - Jerry Dixon presents a list of important dates and relevant information....(more)

Will Instant File Initialization Really Help My Databases? - Normally, when you need to grow a file, the space to be used will be overwritten with zeros. Depending on how large your file needs to be, this can take some time. With rights to use IFI, SQL Server skips that step – the space is claimed on disk, and the stuff on disk is overwritten as needed. It makes database growth faster....(more)

Importance of Setting the Correct SQL Server Collation - A simple operation to install the Monitoring Server role toreport on adoption and usage of Lync 2010 is derailed by a rogue SQL Server collation setting. ...(more)

The Accidental DBA (Day 30 of 30): Troubleshooting: Transaction Log Growth - Whatever the reason is that has made your database’s log grow, take corrective action to allow the log to clear, and then take preventative action to stop the log having to grow again....(more)

The Accidental DBA (Day 29 of 30): Troubleshooting Deadlocks - Troubleshooting deadlocks in SQL Server begins with collecting the deadlock graph. Extended Events collects the information by default and eliminates the need to enable further collection and then waiting for the deadlocks to reoccur to gather the information....(more)

Blogs : Backup and Recovery

trace flag for backup and restore operation - A brief investigation of a few backup related tracflags, such as 3004, which shows the internal backup/restore operation for every step....(more)

10 Tips for Efficient Disaster Recovery - Most disasters are, in fact, relatively minor annoyances that we deal with inside of our department, finding workarounds or accepting delays in completing our work. However, sometimes we have real disasters of the sort that result in management peering impatiently over our shoulder as we strive to find a solution....(more)

Blogs : Computing in the Cloud

Cloud as a Tier with Microsoft StorSimple - Several months ago Microsoft acquired a company called StorSimple, a hardware storage appliance with multiple storage tiers such as SSD or SAS disks and Windows Azure. There was no real buzz around this, but for Thomas Maurer this is a huge step and shows in which direction the whole Cloud and Datacenter future will go....(more)

Blogs : DBA Tools

SSMS Tools Pack 2.7 is released. New website, improved licensing and features - Mladen describes the various improvements to the latest version of his popular SSMS add-in....(more)

Blogs : Deep Into Windows

Windows Server 2012 R2, Already?? - Pierre Roman summarizes some of the new features, including the introduction of Hyper-V Replica....(more)

Blogs : DMO/SMO/Powershell

PowerShell updatable help updated! - A recent update to Windows PowerShell help removed parameter data types from the syntax block. This is now fixed....(more)

Blogs : Performance and Tuning

A gentle introduction to transaction isolation levels and Hekaton tables - Memory-optimized tables support three transaction isolation levels in user transactions: SNAPSHOT, READCOMMITTED, and SERIALIZABLE. My first puzzle was the BOL describes SNAPSHOT as the “lowest” of the three. I’ve always considered SQL Server’s SNAPSHOT isolation level as most like Oracle’s SERIALIZABLE isolation level, but in the world of memory-optimized tables and user transactions, SNAPSHOT is indeed a lower isolation level than READCOMMITTED. Hmmm....(more)

On Bobcats per 100 Orders and Other Spurious Metrics - Did you know that you can ship a bobcat 1/30th of the time and still maintain 97% positive feedback on ebay? What other statistical lies are lurking out there for you to find?...(more)

Understanding What sp_updatestats Really Updates - For sp_updatestats, the logic is so incredibly simple, it’s scary: If one row is modified, the statistic is updated. One row. ONE ROW. What’s my concern? I’m worried about the overhead of updating statistics for a bunch of statistics that don’t truly need to be updated....(more)

Index Internals and How Filtered Indexes Look Like (Part 2) - Filtered indexes and what they look like from a storage perspective....(more)

Baselining with SQL Server Dynamic Management Views - When you're monitoring SQL Server, it is better to capture a baseline for those aspects that you're checking, such as workload, Physical I/O or performance. Once you know what is normal, then performance tuning and resource provisioning can be done in a timely manner before any problem becomes apparent. We can prevent problems by being able to predict them. Louis shows how to get started....(more)

Blogs : Security and Auditing

Can I stop a System Admin from enabling SQL Server xp_cmdshell? - We have an audit requirement to disable xp_cmdshell. However, I've read that a member of the sysadmin role can re-enable xp_cmdshell. Is there any way to prevent this from happening? The short answer is no. ...(more)

Collecting the Information in the Default Trace - The default trace is still the best way of getting important information to provide a security audit of SQL Server, since it records such information as logins, changes to users and roles, changes in object permissions, error events and changes to both database settings and schemas. The only trouble is that the information is volatile. Feodor shows how to squirrel the information away to provide reports, check for unauthorised changes and provide forensic evidence....(more)

Blogs : SQL Server 2014

Getting Started With SQL Server 2014 the Easy Way - Grant Fritchey on an easy way to try out SQL Server 2014, to have a server up and running with SQL Server 2014 installed and ready to go in 5 mins, using Azure Virtual machines (providing you've got the right MSDN subscription)....(more)

SQL 2014 In-Memory OLTP ‘Hekaton’: training videos and white papers - How do you get started with Hekaton? Arvind Shyamsundar offers a readiness roadmap!...(more)

Updatable columnstore index, sp_spaceused and sys.partitions - Columnstore index in SQL Server 2014 contains 2 new important features: it can be clustered and it is updateable. Michael Zilberstein plays with bothon a table with 63 million rows – 9 million in each of seven partitions....(more)

Blogs : T-SQL

Replacement for system stored procedure sp_dboption in SQL Server 2012 - The system stored procedure sp_dboption is not available in SQL Server 2012 anymore. Use the ALTER DATABASE command instead....(more)

It Took Me Ages To Figure This One Out: A Puzzle - The challenge is to figure out why a query and a stored procedure return different results even though the procedure is defined using the same query....(more)


Administrative