I noticed the Lookup function in SQL Server Reporting Services. In this tip we look at all three SSRS lookup functions: Lookup, LookupSet and MultiLookup.

Bad Management

by Steve Jones

SQLServerCentral.com

Editorial

Bad managers are everywhere, but we can improve and help them with some ideas from other companies. That's if we, as an organization, value our staff.

Resumable Online Index Create and Rebuild Operations

by Additional Articles

SimpleTalk

Index maintenance can be a real headache for database administrators as tables grow larger and maintenance windows shrink. In this article, Greg Larsen demonstrates resumable index operations available with SQL Server 2017 and 2019. This feature helps DBAs work around those small maintenance windows by allowing certain index operations to be paused and restarted again later.

How Virtualized?

by Steve Jones

SQLServerCentral.com

Editorial

This week's poll asks about virtualization in your environment. Let us know if you are moving your SQL Server to virtual machines.

Transfer Data to the Cloud Using Azure Data Factory

by Additional Articles

MSSQLTips.com

Cloud Computing

In this tip we look at how to configure Azure Data Factory to move data from an on-premises SQL Server database to an Azure SQL Database.

Serious Hacking

by Steve Jones

SQLServerCentral.com

Editorial

The biggest government hack ever occurred recently. At least until the next one happens.

Improve the Performance of Your Azure SQL Database (and Save Money!) with Automatic Tuning

by Additional Articles

SimpleTalk

Automatic tuning

Organizations may have many concerns about performance when migrating databases to Azure. Fortunately, Microsoft provides some great tools to help improve performance and save money. In this article, Monica Rathbun explains how to take advantage of these features.