Database Weekly is the seven-day roundup from SQLServerCentral. We scour the Internet with a fine-toothed set of queries to compile the most informative weekly newsletter about SQL Server. Over 670,000 SQL Server professionals rely on it to kick-start their week.

Sign up to our newsletter now, to keep up to date with all the latest news.

Latest Database Weekly Newsletter Articles


Row-Level Security: Performance and common patterns
This post demonstrates three common patterns for implementing Row-Level Security (RLS) predicates: Rows assigned directly to users, row assignments in a lookup table, and row assignments from a JOIN. read more...

SQLintersection coming up in May
This time SQLIntersection is in Scottsdale (Phoenix), Arizona (May 18-21). The speaker lineup includes Brent Ozar, Allen White, Aaron Bertrand, Kevin Kline, Shep Shephard, Denzil Ribeiro, David Pless, Tim Chapman, and four from SQLskills (Paul, Kimberly, Erin, and Tim). read more...

Webinar: Wait, what exactly are we shipping? Keeping control in database continuous delivery
Join us on Tuesday 28th April at 4pm BST (11am EDT) for a free webinar panel discussion featuring Brian A. Randell, Grant Fritchey, Steve Jones, and host, Stephanie Herr, on the topic of maintaining visibility and control in database continuous delivery. read more...

Project Elysium wants to use VR to revive deceased loved ones
How far is too far when it comes to pushing the boundaries of virtual reality? As VR devices grow ever more sophisticated—and the tools to create software for them ever more accessible—where do we draw the line between what’s ethically acceptable in the real world and what’s ethically acceptable in the virtual world? read more...

The Read Uncommitted Isolation Level
Read uncommitted is the weakest of the four transaction isolation levels defined in the SQL Standard. It allows dirty reads, non-repeatable reads, and phantoms. Most database people are aware of these phenomena, but not everyone realises that they do not fully describe the isolation guarantees on offer; nor do they intuitively describe the different behaviours one can expect in a specific implementation like SQL Server. read more...

An Incredibly Insecure Voting Machine
Virginia election officials have decertified an electronic voting system after determining that it was possible for even unskilled people to surreptitiously hack into it and tamper with vote counts. read more...

SQL Server 2014 RTM Cumulative Update 7 Available
Microsoft has released SQL Server 2014 RTM Cumulative Update 7, which is Build 12.0.2495. This cumulative update has 41 public hot fixes, several of which look pretty significant. read more...

Are Index ‘Included’ Columns in Your Multi-Column Statistics?
When you create an index in SQL Server with multiple columns, behind the scenes it creates a related multi-column statistic for the index. This statistic gives SQL Server some information about the relationship between the columns that it can use for row estimates when running queries. read more...

Time Slots - An Essential Extension to Calendar Tables
After answering many forum entries from developers asking for help with dealing with SQL that involved time intervals and ranges, Dwain Camps dreamed of a generalized tool that sets up time slots of various sorts without the need to experiment; that could do the heavy lifting, so that developers could do aggregations and reports based on time intervals without the hard graft. read more...

How to Attach a SQL Server Database without a Transaction Log and with Open Transactions
This article covers the not-so-uncommon scenario where someone gives you a SQL Server database to attach to your instance, but only gives you the *.mdf file. read more...

Forced parameterization to the rescue
Some of the features have been around for a long time. But we keep seeing users not taking advantage of it. This article gives you an example how forced parameterization can help you. read more...

Ruminations on Writing Great T-SQL
Depending on the problem being addressed, oftentimes there are just a few very elegant solutions, and probably a bunch of solutions that are not nearly as elegant. In simplicity there is often elegance. Simplicity, elegance and speed may unfortunately not all play well together. But if you can come up with a solution that is elegant, simple and fast, that’s usually going to get you a lot closer to writing great T-SQL. read more...

Squaring big data with database queries
Although next-gen big data tools such as Hadoop, Spark, and MongoDB are finding more and more uses, most organizations need to maintain data in traditional relational stores as well. Deriving the benefits of both key/value stores and relational databases takes a lot of juggling. read more...

Make Sure to Schedule Your SQL Server Replication Jobs
You setup SQL Server Replication and everything looks fine. Rows are flowing between the servers and you think you’re done. Right? Wrong... read more...

T-SQL HOST_ID and HOST_NAME
Included in T-SQL for SQL Server is a functions that returns the workstation information that executes a SQL statement. You can use this to record what workstation the transaction came from in your application or business intelligence processes. read more...

AMD claims Windows 10 will launch by late July, and that feels very soon
In the conference call AMD hosted last week to discuss its first quarter results, CEO Lisa Su let slip with a piece of information that wasn't immediately caught: she said that Windows 10 would be released in late July. read more...

Biml - separate dataflows into separate packages
Bill Fellows explains how he breaks down overly-complicated SSIS packages into smaller packages focusing on individual tasks. read more...

Query Hash Formula Changes Between Versions
Grant Fritchey looks at how to track queries on a 2008R2 instance and a 2014 instance in order to validate performance after an upgrade. read more...

Follow the yellow brick what? My road to public speaking
This is the story of how Chris Sommer went from being the cowardly lion to presenting at his local SQL PASS chapter. read more...

Intel: Fifty Years Under Moore's Law
To celebrate the50th anniversary of Moore's Law, Intel published several web pages dedicated to the history of Intel and how Moore's Law has contributed to the advancement of the company. In a video, Moore also spoke about his predictions and his surprise at how far it has gone. read more...