You can easily use PowerBI Desktop to show graphically how your database is growing, which tables are taking the most space, how various parts of SQL Server is consuming memory, its use of indexes and so on. Sure, you can create graphs in SSMS, but with PowerBI, you can create reports that you can then publish to others, and which allow drill-down. It is a great way to get familiar with PowerBI Desktop as well. Rob Sheldon shows how simple it is to do.

Scrubbing Personally Identifiable Information

by Daniel Brown

SQLServerCentral.com

Restore

Managing personally identifiable information when moving databases to unsecure environment can be challenging. With this flexible and extendable solution for scrubbing it, you can save yourself some time and effort.

Configure SQL Server AlwaysOn Availability Group on a Multi-Subnet Cluster

by Additional Articles

MSSQLTips.com

always on

A “multi-subnet” environment is defined when the OS cluster used as the backbone for AlwaysOn has server nodes that are located in multiple/different subnets. Deploying SQL Server AlwaysOn Availability Groups requires a Windows Server Failover Clustering (WSFC) cluster and each availability replica of a given availability group must reside on a different node of the same WSFC cluster. This post from Manvendra Singh will help you in configuring an HA and DR solution for SQL Server AlwaysOn in multi-subnet networks.

Backing Up SQL Server Databases is Easier in PowerShell than T-SQL

by Aaron Nelson

SQLServerCentral.com

PowerShell

Learn how easy the new SQLServer module makes backups of SQL Server databases.

Backup Data Security

by Steve Jones

SQLServerCentral.com

Editorial

We need better security for our data, especially for our choices in managing data.

Identifying Last Night’s SQL Agent Job Failures

by Additional Articles

Database Journal

SQL Agent

Finding the nightly job failures is just one of a DBA's morning rituals. It is fairly easy to scan all the email with a number of creative search criteria, but what if you would like a more automated approach? Read on to learn how to find and report all job failures using a script.

Not Excited by Linux

by Steve Jones

SQLServerCentral.com

Editorial

Much of the community isn't excited by SQL Server on Linux.

Stairway to U-SQL Level 12: SQL.ARRAY and CROSS APPLY EXPLODE

by Mike McQuillan

SQLServerCentral.com

U-SQL introduces two new data types - SQL.ARRAY and SQL.MAP. Here, we look at what we can do with SQL.ARRAY and the CROSS APPLY EXPLODE expression.

SQL Server Database Provisioning

by Additional Articles

SimpleTalk

provisioning

Database provisioning for development work isn't always easy. The better that development teams meet business demands for rapid delivery and high quality, the more complex become the requirements for the work of development and testing. More databases are required for testing and development, and they need to be more rapidly kept current. Data and loading needs to match more closely what is in production. Grant Fritchey explains.

Simpson's Paradox

by Mala Mahadevan

SQLServerCentral.com

T-SQL

This article is a case study and an attempt to explain an interesting phenomenon with data anomalies that is commonly called Simpson's Paradox.

Using Power BI Desktop to Visualize SQL Server Metadata

Scrubbing Personally Identifiable Information

Configure SQL Server AlwaysOn Availability Group on a Multi-Subnet Cluster

Backing Up SQL Server Databases is Easier in PowerShell than T-SQL

Backup Data Security

Identifying Last Night’s SQL Agent Job Failures

Not Excited by Linux

Stairway to U-SQL Level 12: SQL.ARRAY and CROSS APPLY EXPLODE

SQL Server Database Provisioning

Simpson's Paradox

Blogs

Overcoming Imposter Syndrome: A Plan

Advice I Like: Celebrate Success

Programmatically Retrieving MLV Lineage and Refresh Times

Forums

BCA KCP Rahmadsyah Tlpn/wa:085373737551

BCA KCU BUKIT BARISAN Tlpn/wa:085373737551

BCA KCP Juanda Medan Tlpn/wa:085373737551

Question of the Day

Increase Deadlock Detection