Views in MySQL allow you to save a predefined SQL query. Robert Sheldon explains the benefits of views and how to create and query them.

Virtual Events Are Here To Stay

by Grant Fritchey

SQLServerCentral

Uncategorized

This week was the MVP Summit. As was the case for the last couple of years, the event was entirely virtual. We were shown a bunch of new and interesting things by Microsoft. We were able to talk to each other and to the engineers at Microsoft. I'm honored that I've been an MVP and […]

Executing Notebooks in a Stored Procedure

by Steve Jones

SQLServerCentral

humor

Writing notebooks in Azure Data Studio is a great way to keep a number of queries in one place and execute them together. Steve has a way to do this inside a stored procedure.

Power BI in Grafana

by Steve Jones

SQLServerCentral

humor

An exciting new way of viewing your Power BI visuals. The functionality is a bit limited, but highly desired.

Exploring New SQL Prompt Features in SQL Toolbelt and SQL Toolbelt Essentials

by Additional Articles

Redgate

Vendors/3rd-party Products

Roseanna Whitelegg explores new SQL Prompt functionality that has been added to SQL Toolbelt and SQL Toolbelt Essentials to help teams increase their productivity, improve code quality, and make collaboration easier.

SQL Server and Oracle Create Table Comparison

by Additional Articles

MSSQLTips.com

Database Design

In this article we look at a comparison of different things you can specify when creating tables in SQL Server and in Oracle.

SQL Server 2017 Build List

by Steve Jones

SQLServerCentral.com

SQL Server 2017

A list of builds for SQL Server 2017.

How do you secure sensitive data in a modern Data Warehouse?

by diponkar.paul

SQLServerCentral

In 2019 Canadian Broadcasting Corporation (CBC) news reported a massive data breach at the Desjardins Group, which is a Canadian financial service cooperative and the largest federation of credit unions in North America. The report indicated, a "malicious" employee copied sensitive personal information collected by Desjardins from their data warehouse. The data breach compromised the […]