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


Power BI Pulse Chart vs. Dancing bars in Excel
[2016-Jun-30] Recently Microsoft Power BI has been enhanced with a new Pulse Chart custom visualization (Visual Awesomeness Unlocked: Pulse Chart) which is extremely good and useful for a visual data story telling. I believe that the less we have people ... read more...

Books Online for SQL Server 2016
This one is for those of you who prefer to use a local SQL Server Documentation, a.k.a. Books Online (BOL), instead of using the web-based BOL. A local BOL is essential for me. Navigating the contents, switching between pages and searching is lightyears ... read more...

SSRS Subscriptions (What goes on “under the hood”)
One of the more difficult features to understand/troubleshoot that I’ve found in my experiences working with SSRS customers is the SSRS subscription functionality, especially the subscription processing piece of it before the report execution starts. read more...

Data Security: Time to be Grown-Up
How do you quickly clear a room-full of application developers, short of shouting ‘fire’ and setting off a smoke-bomb? The answer, of course, is to stand up in front of them and announce that you are giving a talk about database access-control and security. read more...

Invoke-SqlCmd Just Got Better!
If you’ve read even just a few of my articles on Simple-Talk you know that I’m a big fan of PowerShell + SQL Server.  Over the years I have written a lot about how to collect data from your SQL Servers and store it somewhere, maybe in a database, maybe ... read more...

5 secrets for writing the perfect data scientist resume
No hype. No fluff. Just skills.Data scientists are in demand like never before, but nonetheless, getting a job as a data scientist requires a resume that shows off your skills. At The Data Incubator, we’ve received tens of thousands of resumes from applicants ... read more...

What is Artificial Intelligence?
Mike Loukides and Ben Lorica examine factors that have made AI a hot topic in recent years, today's successful AI systems, and where AI may be headed in the coming years. The State of Artificial Intelligence Defining artificial intelligence isn’t just ... read more...

Released: System Center Management Pack for SQL Server, Replication, AS, RS, Dashboards (6.7.2.0)
We are happy to announce that Management Packs to monitor SQL Server 2016 product family and updates to existing Management Packs have been released! Only the English versions are available at this time. Localized Management Packs will be made available ... read more...

SQL SERVER – Error Fix: Msg 13601 Working with JSON Structure
As you new versions of SQL Server come, the amount of capabilities just increases exponentially. It is tough to keep up in pace with the innovations and learning that one needs to go through. I have in the past written few articles around working with ... read more...

How to Use Zip With SSIS? – Notes from the Field #130
[Note from Pinal]: This is a 130th episode of Notes from the Field series. In this episode we are going to learn something very simple but effective about SIS and Zip. This subject is not very much discussed about and hardly there are many information ... read more...

SQL PowerShell: July 2016 update
This post was authored by Ayo Olubeko, Program Manager, Data Developer Group. The July update for SSMS includes the first substantial improvement in SQL PowerShell in many years. We owe a lot of thanks for this effort to the great collaboration with ... read more...

Availability Group Direct Seeding: Extended Events and DMVs
As of this writing, this is all undocumented I’m super interested in this feature, so that won’t deter me too much. There have been a number of questions since Availability Groups became a thing about how to automate adding new databases. All of the ... read more...

High-severity bugs in 25 Symantec/Norton products imperil millions
Much of the product line from security firm Symantec contains a raft of vulnerabilities that expose millions of consumers, small businesses, and large organizations to self-replicating attacks that take complete control of their computers, ... read more...

Electric Vehicles at the Pikes Peak International Hill Climb: Race report
Despite a blown engine that prevented any running on the Friday before the race—and an epic case of jet lag after winning the 24 Hours of Le Mans the week before—Romain Dumas was ... read more...

HP Spectre 13 reviewed: Remarkably thin, but not light on power
Your smartphone isn't the only thing that companies are obsessed with making thinner. Focus has turned to laptops as well, with the belief that making thin-as-paper and light-as-air notebooks will draw ... read more...

This chatbot appeals parking tickets and wins 60 percent of the time
Joshua Browder, a 19-year-old British student at Stanford University, has created a chatbot (DoNotPay.co.uk) that successfully challenged parking tickets in London and New York City. The chat interface asks a few basic questions and then auto-generates ... read more...

Western Digital Rolls Out 256 GB SanDisk microSDXC Memory Cards
Coinciding with the Mobile World Congress at Shanghai, SanDisk owner Western Digital is introducing two new microSD memory cards that can store up to 256 GB of data. The new SanDisk-branded cards are designed for smartphones, tablets and content-capture ... read more...

The Lenovo ThinkPad P70 Review: Mobile Xeon Workstation
It’s been almost a year now since Lenovo first announced the new P50 and P70 mobile workstations, which were 15-inch and 17-inch notebooks, respectively. The part of the announcement which likely caused the most buzz was that Intel was now going to offer ... read more...

Microsoft's Windows 10: Anniversary Update to hit August 2; 350 million devices and counting
Microsoft will release Windows 10 on August 2 across the more than 350 million active devices where it is now running, and on other coming new PCs, phones, and more. read more...

Computerworld's advanced beginner's guide to R
Many newcomers to R got their start learning the language with Computerworld's Beginner's Guide to R, a 6-part introduction to the basics of the language. Now, budding R users who want to take their skills to the next level have a new guide to help them: ... read more...