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


MS SQL, T-SQL, and SQL Server Interview Questions
This book aims to help you succeed in a SQL developer interview, how does it fare? read more...

Modern Collaboration is Double-Edged Sword
It’s never been easier to share information on the Web, and the workflows and habits formed through the use of consumer applications has led users to expect the same ease of use and control over data in their professions. read more...

WaterOx SQL
We all get to the point eventually when we completely dread going into work, even if it is only a short walk downstairs to the home office. read more...

Lenovo Web Site Hacked as Retribution for Superfish Scandal
The embarrassment isn't over for Lenovo: the web site for the world’s biggest PC maker was taken offline by a malicious hacker group as retribution for the bundling of the Superfish malware on its PCs. The site was down for much of Wednesday. read more...

Everyone Wants You To Have Security, But Not from Them
In December, Google's Executive Chairman Eric Schmidt was interviewed at the CATO Institute Surveillance Conference. One of the things he said, after talking about some of the security measures his company has put in place post-Snowden, was: "If you have important information, the safest place to keep it is in Google. And I can assure you that the safest place to not keep it is anywhere else." read more...

Book Review – SQL Server Internals: In-Memory OLTP
Anthony Nocentino reviews Kalen Delaney's SQL Server Internals: In-Memory OLTP. In summary "This is the book that you will reach for when you have a question about how it works. I really look forward to when In-Memory OLTP matures enough that some it current limitations are relaxed." read more...

Biml - Snippets
What's the ProjectCoreName and how does that differ from the ScriptTaskProjectName and should it differ? What's the crazy syntax for escaping my code within the code? Yeah, I don't care anymore. I no longer care, because I have a snippet. read more...

Is my SSIS package running in 32 or 64 bit mode?
I've lost track of the number of times a package has worked but then it doesn't on another machine and it ends up being a mismatch between the "bittedness" of their driver and their execution model. read more...

More online operations available now – or soon
I was running some tests in SQL Database and discovered at least one new operation that supports ONLINE = ON. read more...

Secure Connections Management in SSIS, Part 1
SQL Server Integration Services (SSIS) is built to move data. SSIS ships with features to support the secure transmission of data. In this series, my goal is to promote awareness of these features and advocate for their use. read more...

Monitor Query Statistics
One of the most common tasks that DBAs are required to perform is monitoring. This is not just a task. Monitoring is a strategy, and a good DBA should have a well-defined plan for carrying out this strategy. But I’m not here to talk about monitoring as a whole. I would like to talk about one of the common monitoring areas, which is query statistics. read more...

Why isn’t my filtered index being used?
Quite often, people have filtered indexes but find they’re not being used as often as they’d like. But why? Rob Farley investigates. read more...

When Parameter Sniffing Caused Deadlocks
Parameter sniffing combined with query plan caching means that SQL Server seems to only care about parameter values the first time it sees a query. So ideally the first parameter values should be typical parameter values. When people talk about parameter sniffing problems, it’s usually because this assumption doesn’t hold. read more...

The 3 Configuration Options that you always have to change in SQL Server!
Max Server Memory, Cost Threshold for Parallelism and Max Degree of Parallelism (MAXDOP). read more...

Prepared statements: be careful when given “THE” solution for all of your development practices
Kimberly Tripp attempts to untangle a few misconceptions about Prepared Statements. read more...

Replicating Excel Percentile in DAX
Currently, DAX has no native percentile function so if you want to replicate a version that matches what the Excel Percentile.INC (inclusive) function does you have to jump through a few hoops. read more...

Azure Blob Storage Part 7: Snapshots
Snapshots remind me of the VAX/VMS operating system, where you could have multiple versions of the same file. You could always revert to an earlier version by copying that version of the file on top of the most recent version. This is pretty much how snapshots work. read more...

Monkeys and bananas: stifling innovation in the workplace
Paul Randal recounts a story about a psychology experiment involving monkeys and bananas and the reinforcement of constrained, negative thinking, and sees parallels in the IT workplace. read more...

DevOps, the DBA, and the word “No”
The old 1970s vision of a walled off data center with DBAs in white lab coats acting as gatekeepers to the data is long discredited. As DBAs, even if you’re not working with development teams at all, you’re just offering a service to the business. This whole, a DBAs favorite word is “NO”, meme needs to die a quick, hard, death. read more...

Balancing Your Available SQL Server Core Licenses Evenly Across NUMA Nodes
Both SQL Server 2012 and 2014 Standard Edition have an artificial license limit of either 16 physical cores or 32 logical cores (along with a limit of four sockets, whichever is lower). This meant that SQL Server 2014 Standard Edition could only use 32 out of the 48 logical cores in a customer's new server. read more...