Learn how you can get the userid of someone connected to Reporting Services and use that information to determine if they can view the report.

VMs for Development

by Steve Jones

SQLServerCentral.com

Editorial

Many technical people use Virtual Machines to build their own lab or test environment. Today Steve Jones asks how you've built your setup.

New Azure SQL Database Standard Tier Sizes

by Additional Articles

SQLPerformance.com

Azure SQL database

Tim Radney of SQLskills talks about the various Standard tiers available in Azure SQL Database – what they get you, and how much they cost.

Data Security Policies

by Steve Jones

SQLServerCentral.com

Editorial

Does your organization have policies around data security? Perhaps they should, or perhaps you should ask for some to be created and education available for users.

Different Ways to Find SQL Server Orphaned Users

by Additional Articles

MSSQLTips.com

orphaned users

SQL Server orphaned users are a common thorny issue in auditing. In this post, Jeffrey Yao provides a few different ways of identifying orphaned users covering various scenarios.

Still More SQL Server Features that Time Forgot

by Additional Articles

SimpleTalk

SQL Server

As the final entry in this series, Robert Sheldon leads you through a group of forgotten features that have been removed from recent versions of SQL Server. In some cases, the features were widely used and often loved, while others had lost their usefulness over the years or were replaced with something much better. In this article, he remembers Data Transformation Services (DTS), a handful of DBCC commands, a few utilities, Active Directory Helper Service, English Query, Web Assistant, SQL Mail, Native XML Web Services, Notification Services, SQL Distributed Management Objects, Surface Area Configuration Tool, and the Pubs and Northwind databases.

Azure DWH part 21: Using Excel in ASDWH

by Daniel Calbimonte

SQLServerCentral.com

Microsoft Fabric (Azure Synapse, Data Engineering, etc.)

This time we will show how to access to Azure SQL Data Warehouse using Excel.

The Worst Code

by Steve Jones

SQLServerCentral.com

Editorial

What's the worst code you've seen? Steve Jones hopes it isn't your own code.

Understanding Migration from SQL Server to SQL Server 2017 using Data Migration Assistant

by Additional Articles

Database Journal

SQL Server 2017

You can use the Data Migration Assistant (DMA) tool to migrate your SQL Server instance to an on-premise SQL Server 2017 or to Azure SQL Database. DMA analyzes data migration issues and provides recommendations to resolve them. Read on learn about the features of DMA and how DMA eases your SQL Server instance migration as well as reduces overall risks, allowing you to complete the migration successfully.