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


SQL Server Features Discovery Report
I don't need to validate SQL Server installations on a regular basis. When the need arises, my preference is to run the SQL Server features discovery report. Further, I prefer to run it from the command line. After looking up command line parameters ... read more...

McAfee Study Reveals 1-in-4 Organizations Using Public Cloud Has Had Data Stolen
by Angela Guess A recent press release reports, “McAfee, the device-to-cloud cybersecurity company, today announced its third annual cloud adoption and security report, Navigating a Cloudy Sky: Practical Guidance and the State of Cloud Security. The ... read more...

Boxes and Lines…Er, Whiskers
I had to cut short my last dabbling in distribution post because I had to get to Game 2 of Round 1 of the playoffs between the Vegas Golden Knights and Los Angeles Kings, which was am amazing game with not one, but two, overtime periods! That made for ... read more...

Avoid use of the MONEY and SMALLMONEY datatypes
One of SQL Prompt's code analysis recommendations is that you avoid using the MONEY and SMALLMONEY datatypes - this article from Phil Factor explains why. read more...

Finding overlapping ranges of data
This week, I had a problem where I needed to find and eliminate from the results of my query, data with overlapping ranges. I have written about this topic before, in my database design book book, in regards to building a trigger to avoid overlapping ranges. But even though I have written on the topic there, I still use Google just like you to get quick help (I use books when I want to learn, or expand my knowledge on a topic in depth, blogs when I need a simple answer to a simple or complex question.) read more...

Provisioning SQL Server Instances with Docker
With SQL Server 2017, Microsoft announced the exciting news that SQL Server would now run in Docker containers. Laerte Junior provides a guide to get started creating SQL Server instances in Docker. read more...

SQL: Are bit columns useless in SQL Server indexes?
If you are aware of Betteridge's law of headlines, you already know the answer, but let me explain. There are a lot of odd myths that surround SQL Server. One of the more persistent ones is related to indexes on columns that hold bit values. A SQL Server ... read more...

Fix: Reporting Services Configuration Manager can’t find Power BI Report Server
I just spent ages trying to work out why I couldn't connect to Power BI Report Server using the Reporting Services Configuration Manager. Amazingly, I hadn't had to reconfigure it since I installed it, but now I needed to change the email account. And ... read more...

Best-practices, guiding principles of choosing procedure parameters
Designing implementation of interface is as critical as designing interface itself. In this post we will discuss some advice on how to choose the right set of parameters for your procedures read more...

In-Memory OLTP: A Case Study
Watch this week’s episode on YouTube. When In-Memory OLTP was first released in SQL Server 2014, I was excited to start using it.  All I could think was “my queries are going to run so FAST!” Well, I never got around to implementing In-Memory OLTP.  ... read more...

Webinar: 6 Principles of the GDPR and SQL Provision
On April 24, I’ll be hosting a webinar that talks about the GDPR and how you can help ensure compliance in your development environments. I’ll talk about some of the issues and show how SQL Provision can help. The GDPR is complex, but it certainly does ... read more...

Fix WHERE clause AND/OR/NOT confusion with truth tables
The ANDs, ORs, and NOTs in a T-SQL query's WHERE clause can get confusing, especially if you're thinking of it like plain-Jane algebra. Here I show you how to figure out exactly what a query is doing, using truth tables! The post Fix WHERE clause AND/OR/NOT ... read more...

24 Hours of PASS – April 25th–26th
Well, it is that time of the year, again. PASS puts on a 24 Hours of PASS where 1 hours session go on once an hour for 24 hours. This is free training usually on a certain topic. The topic this time around is Cross Platform SQL Server Management. The ... read more...

Exploring system tables, views, SPs etc
I wanted to spend a few minutes highlighting a couple of important tools for figuring out what information you have available to you within SQL Server. sys.all_objects and sys.all_columns. Note the All. These system views are almost exactly the same ... read more...

Python Jupyter Notebooks in Azure
There’s a new feature in Azure, and I stumbled on it when someone posted a link on Twitter. Apologies, I can’t remember who, but I did click on the Azure Notebooks link and was intrigued. I’ve gotten Jupyter notebooks running on my local laptop, but ... read more...

Query Store Cleanup Can be Part of a Blocking Chain
Forgetfulness can lead to learning something new. This is a bit of a nightmare when it happens in production, but a treat when it happens in an isolated test system– and that’s how I learned this. I left a bit of blocking open on my test VM, and forgot ... read more...

3 Ways Communication Can Help Analysts Be More Successful
Being a great analyst is more than SQL, Python or reporting—great analytics is a human exercise, a communications skill and way to grow a data-driven culture. Here are 3 simple techniques will help take your dashboards from simple intrigues to impactful ... read more...

R & Python 101: Complex Visuals
One of the most impactful ways data teams can communicate is by turning ideas into visuals to share with internal stakeholders. With Python and R, chart creators have more controls to better customize the final visualization that appears in their Periscope ... read more...

Why IoT Security Issues Still Loom Large in Health Care
According to recent research from IoT security company Zingbox, health care organizations are wrestling with an array of IoT security issues. read more...

How Data Breaches Affect the Corporate Bottom Line
Using events reported as cyber-breaches in the nonprofit Privacy Rights Clearinghouse, a team of economists from Singapore, Cyprus, Hong Kong and the U.S. examined which firms are at highest risk of attack and what the consequences are. read more...