With SQL Server 2019 getting closer to release, Steve asks about the hardware limitations that we should have in Standard Edition.

Introduction to SQL Server Security — Part 5

by Additional Articles

SimpleTalk

SQL Server contains many built-in views and functions that can be used to understand what is going on “under the hood,” and security is no exception. In this article, Robert Sheldon explains the security related catalogue views, dynamic management views, and system functions.

SQL in the City Summits – US & Down Under

by Press Release

Redgate

event

Redgate are inviting senior data professionals to attend one of the upcoming SQL in the City Summit events taking place in May and June. If you’re interested in learning how your business can benefit from implementing Compliant Database DevOps this event is for you. Find out who’s presenting and register for a Summit near you today.

Testing Databases: What’s Required?

by Additional Articles

Redgate

Testing

Phil Factor reviews the various types of database test that need to run during development work, what sort of test data they require, and the challenges with managing this data, and in keeping the test cell stocked with the correct database, and data, in a way that allows rapid cycles of database testing.

DBAs and the ITIL Framework, Part II: Asset Management

by John F. Tamburo

SQLServerCentral.com

See how the ITIL Framework's Asset Management standards make the DBA's job easier. Use the CMDB and DML to keep your data assets under tight control.

The Other Jobs

by Steve Jones

SQLServerCentral

Career Growth

This week Steve is asking what jobs you might choose if you had the chance, as well as those you enjoyed, or perhaps dreaded.

Azure SQL Elastic Pools and SQL Monitor

by Additional Articles

Redgate

Azure SQL

Jon Hayman explains the Azure-tailored metrics and alerts in SQL Monitor that track use of the limited compute resources available to an Azure SQL Elastic Pool, and to each of the databases in it.

The Silent Bug I Find in Most Triggers

by Additional Articles

Brent Ozar Blog

I don’t have a problem with triggers. They get the job done when you need to implement business logic in a hurry, and you’re not allowed to change the application. As long as you keep the number of statements to a minimum (say, 2-3), and don’t try to do something really slow like fire up a cursor, triggers can be an efficient way to solve hard problems quickly. However, most triggers I run across have a really, really dangerous bug.