Today Steve asks about your best day as a DBA.

Easily manage SQL Server licensing with SQL Monitor 10.1

by Additional Articles

Redgate

SQL Monitor 10.1 now gives you a comprehensive overview of your SQL Server licensing, so you know which licenses are in use, and which versions are on which servers. This simplifies license auditing and lets you unearth misconfigurations that could potentially cost you money. The new version also integrates with Microsoft Teams and Splunk, and supports complex Active Directory environments.

Tempdb – Here’s a Problem You Didn’t Know You Have

by Additional Articles

SimpleTalk

SQL Performance

Because of its many roles, tempdb is the source of performance issues in SQL Server, and there are recommended configuration changes to mitigate this. In this article, Fabiano Amorim demonstrates another issue with tempdb performance that you probably didn’t know about.

A 2020 Look at Software Developers

by Steve Jones

SQLServerCentral

Career Growth

The results of a survey on software developers has some interesting insights.

Stairway to U-SQL Level 22: Creating a Custom Extractor

by Mike McQuillan

SQLServerCentral

Throughout this series, we’ve consistently dealt with delimited text files; comma and tab, for instance. We’ve used the U-SQL built-in extractors to process these files. But what if we need to deal with different types of file, like JSON, XML or fixed width? That’s where custom extractors come in. U-SQL provides us with the ability […]

SQL Server Data Masking with DbDefence

by Additional Articles

MSSQLTips.com

data masking

Data breaches are becoming too common place with some accounts reporting more than 1000 breaches per year with close to 50 million records exposed yearly in the financial, business, education, government and healthcare industries. Learn about how DbDefence performs SQL Server Data Masking as a portion of a three pronged approach to protect your data.

Generate Role Member Reports using dbatools and the ImportExcel PowerShell modules

by Cláudio Silva

SQLServerCentral

Being able to get information and save it on a Excel as a report can be a common and tedious task. What if we could join dbatools and ImportExcel PorwerShell modules to accomplish this in a easier and fast way? We will see how to export roles and its' member and save that info on a multi spreadsheet Excel file with handy tables ready to be explored.

No Excuse to Ignore the Database

by Steve Jones

SQLServerCentral

Today Steve talks about the DevOps journey with databases.

Redgate Streamed

by Additional Articles

Redgate

Conferences, Classes, Events, and Webinars

This July we're taking Redgate Streamed down under, bringing together expert industry speakers from Australia and New Zealand for a full day of online sessions, knowledge sharing and networking.