How easily can we find tables with dropped columns that need cleanup?

Manage Elastic jobs in Azure using Azure Elastic Jobs Manager

by Kunal Rathi

SQLServerCentral

Microsoft Azure offers Azure Elastic Job agent as a managed service, enabling efficient scheduling of T-SQL workloads on Azure SQL Databases. Learn how to configure the service in this article.

Poor Database Design Realities

by Steve Jones

SQLServerCentral

Database Design and Implementation

Steve sees that poor database design is the reality of the world and we have to work around that.

Snake draft sorting in SQL Server, part 3

by Additional Articles

SimpleTalk

T-SQL

In part 2 of this series, I showed an example implementation of distributing a long-running workload in parallel, in order to finish faster. In reality, though, this involves more than just restoring databases. And I have significant skew to deal with: one database that is many times larger than all the rest and has a higher growth rate.

Basic Always On Availability Groups in SQL Server Standard

by Stewart Campbell

SQLServerCentral

Once Windows Server Failover Clusters have been set up, we can set up Availability Groups in SQL Server. This article will focus on setting up Basic Always-On Availability Groups in SQL Server Standard Edition.
This facilitates High Availability in SQL Server Standard, with three levels of availability and failover:
Asynchronous commit with manual or forced failover,
Synchronous commit with manual or forced failover,
Synchronous commit with automatic failover.

PowerBI premium capacity administration: dataset monitoring and tuning

by Additional Articles

SimpleTalk

Power BI

Over the years Power BI has evolved into a complex and varied ecosystem of tools and solutions, which in its turn demands several supporting roles: there are, of course, developers, data engineers and data scientists, but there is need for one more, i.e. a capacity administrator.