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


Announcing sp_BlitzCache™ v2.4
Welcome to sp_BlitzCache™ v2.4. This release brings a few changes and bug fixes. Fixed a logical error in detecting the output table. Thanks to Michael Bluett for pointing that out. Sorting by executions per second finally works. Thanks to Andrew Notarian ... read more...

Determining the Windows Groups for a SQL Server Login
There was a question this morning on the SQL Down Under mailing list about how to determine the Windows groups for a given login. That’s actually easy for a sysadmin login, as they have IMPERSONATE permission for other logins/users. Here is an example ... read more...

Big questions, good data, smart designs
The best designers possess empathy for their users — and data is key to gaining this kind of understanding. I recently sat down with Rochelle King, vice president of global design and UX at Spotify, to talk about data, design, and user experience. King ... read more...

Report: Data Breaches Plague California
Personal information about more than 18.5 million Californians was hacked, stolen or otherwise exposed last year and as many as one-third of those people will become victims of fraud, California Attorney General Kamala Harris said Tuesday in a new report ... read more...

Biml and Looping through excel files in SSIS
Biml and Looping through excel files in SSISI came across a question on DBA.StackExchange.com and they wanted to know why they were getting an error about the file being locked. My fine compatriots already suggested the questioner use ProcMon but the ... read more...

Outlier Detection with SQL Server, part 2.1: Z-Scores
By Steve Bolton …………Using SQL Server to ferret out those aberrant data points we call outliers may call for some complex T-SQL, Multidimensional Expressions (MDX) or Common Language Runtime (CLR) code. Yet thankfully, the logic and math that underpin ... read more...

Playing with the log – Before the first full backup
The log file tends to fascinate me. In fact one of my favorite posts is where I looked into the effect of VLF size on shrinking the log. So the other day I was asking about VLFs and got sent to this great video of a recorded session from PASS SQLRally ... read more...

Introduction To SQL Server Joins with Example
In SQL Server database, if records of two or more tables have to be combined, then the Join clause is used. It is a means that combine same fields of the tables can be combined using their common values. There are five types of join clause available ... read more...

Bad habits : Counting rows the hard way
[See an index of all bad habits / best practices posts] One of the slides in my recurring Bad Habits & Best Practices presentation is entitled "Abusing COUNT(*)." I see this abuse quite a bit out in the wild, and it takes several forms. How many rows ... read more...

FIX: Visible preview window in SQL Server Reporting Services gone!
It’s great to see that the Connect site leading to fixes in the product. I was really pleased when SQL Server Data Tools for BI appeared for Visual Studio 2013. What I wasn’t pleased about where a number of UI issues that came with that version. In particular, ... read more...

SQL Down Under Show 64 – Ryan Crawcour–What SQL Server DBAs and Developers Need to Know About Azure DocumentDB
I had the pleasure of recording another SQL Down Under show today. Show 64 features Microsoft Azure DocumentDB product group member discussing Azure DocumentDB and what SQL Server DBAs and developers need to know about it. JSON-based storage has been ... read more...

Sort – Is it Really a Blocking Iterator?
SQL Server has two types of execution plan iterators: Blocking and Non-Blocking. A non-blocking iterator gets rows in and sends rows out at the same time. For instance, the Nested Loops iterator gets rows from its outer input and sends the matching rows ... read more...

Review Kalen Delaney’s Hekaton Book
I have multiple paper copies of Kalen Delaney’s SQL Server Internals: In-Memory OLTP looking for good homes. If you’d like to to write a review of Kalen’s book, I will mail you a copy, free. All you need to do is fill out this quick form which includes ... read more...

SQL Server MAX DOP Beyond 64 – Is That Possible?
I recently posted a blog outlining how the partitions of a table can be used in the calculation for the achievable max degree of parallelism (MAX DOP). http://blogs.msdn.com/b/psssql/archive/2014/09/04/a-partitioned-table-may-limit-the-runtime-max-dop-of-create-alter-index.aspx  ... read more...

Access Git Commits during a TeamCity Build using Powershell
Recently I needed access to the list of commits that were included with each of my TeamCity builds. TeamCity provides a pretty big list of Predefined Build Parameters, but it doesn’t provide access to details of the commits it is currently building. Having ... read more...

SQL SERVER – Is tempDB behaving like a Normal DB?
The more I work with SQL Server, more I am baffled with the way SQL Server works. In all these interactions, I have seen DBA’s and Developers think about TempDB as something totally different from a usage point of view and treat it differently. Yes, ... read more...

SQL SERVER – Beginning Table Valued Constructors – Notes from the Field #052
[Note from Pinal]: This is a 52th episode of Notes from the Field series. I am very happy that the journey which we started one year ago is a amazing milestone. In this 52 episode in the entire year we have learned a lot of new things from industry experts ... read more...

TPC-E Single-Threaded Performance Leaderboard
Fujitsu recently posted a new TPC-E benchmark result of 3777.08 for SQL Server 2014, using a two-socket server with the 18-core, 22nm Intel Xeon E5-2699 v3 (Haswell-EP) processor. This is the highest ever actual TPC-E score for a two-socket server, which ... read more...

Apple Pay Rival CurrentC's User E-Mails Are Hacked
CurrentC, the mobile payment system that many large retailers are promoting over Apple Pay, has been hacked. A blog post published Tuesday on the Web site of Merchant Customer Exchange (MCX), the consortium of retailers backing CurrentC, acknowledged ... read more...

Announcing Our New All-in-One Download Pack
The best poster that isn’t hanging on your wall – yet We give away a lot of stuff – scripts, setup checklists, e-books, posters, you name it. But we kept hearing a theme from folks: “Wow, I’ve seen one of your tools before, but I had no idea there were ... read more...