Steve has a few thoughts on what is worse than telling your boss about a data breach.

Introduction to SQL for Cosmos DB

by Additional Articles

SimpleTalk

This article by Adam Aspin reviews the Azure Cosmos DB SQL API from the perspective of the relational database developer. More specifically it will show you how to leverage your Structured Query Language skills to exploit the core possibilities of Cosmos DB as a NoSQL document database.

Who Are Your Authenticated Users?

by Steve Jones

SQLServerCentral.com

Editorial

Steve has a question on security this week.

Can deleting rows make a table…bigger?

by Additional Articles

Brent Ozar Blog

Indexing

Michael J. Swart posted an interesting question: he had a large table with 7.5 billion rows and 5 indexes. When he deleted 10 million rows, he noticed that the indexes were getting larger, not smaller.

SQL Server Reporting Services Lookup, LookupSet and MultiLookup Functions

by Additional Articles

MSSQLTips.com

Reporting Services (SSRS)

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.