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


Building Better Test Data with SQL Provision
In this article, Microsoft MVP Steve Jones shows how SQL Provision can help create test data that complies with regulations that prohibit the sharing of sensitive or personal data, but still looks and behaves like the real deal. read more...

New Whitepaper: Data Protection and Compliance During Provisioning
Data privacy and protection is a large concern across all organizations and knowing how to best approach it can be daunting. Grant Fritchey unpicks US legislations HIPAA and SOX to uncover exactly what is required of you and your team to ensure compliance. Download your free copy. read more...

Use SQL Server? We’d like to hear from you.
Redgate are running a survey to better understand trends in adoption of different technologies and platforms. Completing this survey will take just a few minutes. As a thank you for your time, they will be giving away one $100 Amazon gift card to one randomly selected participant who completes the survey by December 7, 2018. read more...

The Benefits of Adopting Compliant Database DevOps at PASS
The GDPR presented a challenge for PASS - a community of over 250,000 data professionals with almost 300 Local Groups around the world and 24 Virtual Groups. This whitepaper shows how PASS were able to introduce compliance by default with the new data privacy regulations by using Redgate's solutions to apply DevOps practices to the database. read more...

2019 State of Database DevOps – Take the survey!
Database development practices are more integral than ever to DevOps success. How are we saving time, automating processes, deploying more frequently, all whilst keeping business critical data secure? Take part in the survey for an advanced copy of the research report, and a chance to win a $250 Amazon voucher. read more...

SQL in the City Streamed December 2018
The theme for December 2018's SQL in the City Streamed is Your Journey to Compliant Database DevOps. The schedule includes sessions designed to broaden your skillset, support your ongoing learning, and keep you up-to-date with what’s new in the industry and at Redgate. read more...

Accomplishing DevOps with Databases - experiences from the wild…
Have you heard the recent industry noise about how people are applying DevOps principles to databases and wondered if it is just hype? MVP Hamish Watson demonstrates how the noise is based on facts, and how using things like Source Control, Continuous Integration and Continuous Delivery will make a huge (positive) difference to how you deploy changes to your SQL Server estate. read more...

Creating a data culture can transform risk calculation for insurers
James Boother from COEO will be joining us for a live video session to discuss the seven steps some organisations are already taking to predict future risks with even greater certainty and the opportunities Data Mastery presents insurers. read more...

What we learnt at PASS Summit
PASS President Grant Fritchey will be joined by fellow Microsoft MVPs Kendra Little and Steve Jones to discuss their highlights and learnings from PASS Summit 2018, the largest Microsoft Data Platform conference. read more...

Table Spool
Introduction The Table Spool operator is one of the four spool operators that SQL Server supports. It retains a copy of all data it reads in a worktable (in tempdb) and can then later return extra copies of these rows without having to call its child ... read more...

Kubernetes For The Microsoft Data Platform Professional 101
With the announcement of SQL Server 2019 big data clusters at Ignite, Kubernetes (often abbreviated to K8s) now stands front and center as part of Microsoft’s data platform vision. The obvious inference being that this is something that the Microsoft ... read more...

Creating Database Maintenance Plans
Using database maintenance plans, we can automate basic database administration activities. Maintenance plans are SQL Server integration service packages which are executed by SQL Server Agent job on configured schedule. Using maintenance plans, we can ... read more...

Setting up a simple Rest interface with SQL Server
We’re going to set up a web service for a SQL Server database using node js on a windows server. This is intended for a mobile application, but has a variety of other uses where an ODBC connection isn’t possible. This service is purely done as a demonstration ... read more...

Windows 10 Activation Servers Hit A Snag, Deactivates Legitimate Installs of Windows
While we sit and wait for Microsoft to figure out what is wrong with Windows 10 1809 that was released and then pulled, the company is dealing with another issue this week. If you have suddenly found your install of Windows 10 to no longer be activated, ... read more...

Why VMware Is Acquiring Heptio and Going All In for Kubernetes
NEWS ANALYSIS: VMware is positioning itself to be a leader in the next generation of the cloud, enabling multicloud with Kubernetes-based technology. read more...

Users Stop Engaging With Brands After Data Breaches, Report Finds
Brands lose a lot more than just data when they suffer a data breach, according to Ping Identity. They also lose customer engagement and trust. read more...

Don’t just think database DevOps. Think compliant database DevOps.
The 2018 Accelerate State of DevOps Report from DORA specifically calls out database development as a key technical practice which can drive high performance in DevOps. It’s an interesting shift in our understanding of what should be included in DevOps ... read more...

Nine things I learned from driving a supercar for three days
The email arrived unexpectedly. "I don't think we've ever met, but I'm the PR Manager for McLaren in North America," it began. My pulse quickened as I continued reading. "We've got a 570S Spider that is making ... read more...

Converting SQL Server LSNs with PowerShell
If you’ve spent much time playing with SQL Server backups and restores then you’ll have discovered Log Sequence Numbers (LSNs), I’ve discussed before How SQL Server LSNs are generated, and went through how to manually convert a hexadecimal LSN to a numeric ... read more...

Python in Visual Studio Code – October 2018 Release
We are pleased to announce that the October 2018 release of the Python Extension for Visual Studio Code is now available. You can download the Python extension from the Marketplace, or install it directly from the extension gallery in Visual Studio Code. read more...