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


Book Review: Pro SQL Server Internals
Another SQL Server internals book hits the market, is it needed? Let's find out... read more...

The Mysteries of Missing Indexes [Video]
SQL Server is trying to help you – when you run a query, you see a missing index request. Before you run that CREATE INDEX script in production, consider a few things. How helpful will the index be? Is it similar to an existing index? Why is it recommending three indexes that are very similar? read more...

Effects of sp_rename on Stored Procedures
There comes a time when mistakes are made. Sometimes those mistakes can be as annoying as a spelling mistake during the creation of a stored procedure. When a mistake such as that happens, we are given a few choices. One could either rename the stored procedure, drop and recreate the stored procedure or simply leave the mistake alone. read more...

Checking who is connected to your server, with PowerShell
There are many occasions when, as a DBA, you want to see who is connected to your SQL Server, along with how they are connecting and what sort of activities they are carrying out. Jonathan Allen looks at a couple of ways of getting this information and compares the effort required and the results achieved of each. read more...

SQL Spatial: Getting “nearest” calculations working properly
If you’ve ever done spatial work with SQL Server, you’ve probably come across the ‘nearest’ problem. You have five thousand stores around the world, and you want to identify the one that’s closest to a particular place. Maybe you want the store closest to the LobsterPot office in Adelaide, at -34.925806, 138.605073. Or our new US office, at 42.524929, -87.858244. Or maybe both... read more...

Public Data Sources – finding them and using them
A quick post here on some valuable data sources you can use in your HDInsight, Microsoft Excel, SQL Server, APS, and other products to enrich your data. read more...

Generating Identities
The only thing you ever need to use for database identity is an IDENTITY, right? Well, maybe. There are a lot of different options and they all have different pros and cons. read more...

How hackers used Google to steal corporate data
A group of innovative hackers used free services from Google and an Internet infrastructure company to disguise data stolen from corporate and government computers, a security firm reported. read more...

Questions about T-SQL Expressions You were Too Shy to Ask
Nobody seems to ask questions about SQL Expressions in forums, even though expressions can cause all sorts of problems. Even the books on T-SQL skate over them in haste to get to more complicated topics. It is time for frank, straight-forward Q&A, and who better than Robert Sheldon to give the A?. read more...

Conference networking for the socially awkward
Conference season is rapidly approaching. Do you approach a room full of strangers with excitement at all the new people you’re going to chat to? Or do you find rooms full of strangers intimidating and begin by scouting out a place you can stand quietly and not be in someone’s way until the next session begins? read more...

SQL Monitor Metric: Out of Memory Errors
The number of out of memory errors that have occurred within a rolling five minute window. If you just want to keep an eye out for any memory errors, you can watch the ring buffers for the Out of memory errors alert when it gets registered there. read more...

Testing SQL Server Query Performance Using Different Levels of Parallelism
While in most cases the SQL optimizer will pick the best execution plan, there are instances where for whatever reason it does not. To answer the question posed in our problem we can use the DBCC SETCPUWEIGHT (value) command which essentially applies a multiplier to the cost component of the optimizer. read more...

​Finding Out What Changed in a Deleted Database – Notes from the Field #041
In this episode of the Notes from the Field series database expert Brian Kelley explains a how to find out what has changed in deleted database. Read the experience of Brian in his own words. read more...

Exploring Impostor Syndrome in Technology
Scott Hanselman on the idea of Imposter Syndrome or being a "Phony." It's the idea that on the surface you're an accomplished technologist but inside you're always question if you're really good enough. read more...

Security Updates Available for SQL Server 2008, 2008 R2, 2012, 2014
If you are running 2008 SP3, 2008 R2 SP2, 2012 SP1, or 2014, you'll want to check out Security Bulletin MS14-044 for details on a denial of service / privilege escalation issue that has been patched. read more...

The Mindset of the Enterprise DBA: 8 Ways To Centralize Your Work
Although it is possible to provide good service to small to medium companies as a DBA without putting in place systems and processes to manage the workload and the demands of teamwork, it isn't so in the larger enterprise. As well as standardizing and documenting, the enterprise DBA needs to centralize the management of systems. Joshua Feierman explains. read more...

Consulting Skills Learned in the Ambulance
A different career before IT brings with it some interesting soft skills. read more...

You Can't Hide From Pryin' Eyes
Two news items from the past week highlight the ways of making people feel comfortable, or not, with data gathering. read more...

When Data Joins The Dark Side
A big data stockpile may contain dark data - unstructured, unclassified information that you can't put to good use. Maybe it's time to find it. read more...

Having performance issues with table variables? SQL Server 2012 SP2 can help!
As part of supportability improvement, SQL Server 2012 Service Pack 2 made an improvement that will help in situations where you have large number of rows inserted into a table variable which joins with other tables. read more...