Your Top 10 Ideas for SQL Server

• by Additional Articles

• Brent Ozar Unlimited Blog

• SQL Server

You’ve submitted thousands of bug reports and feature requests at feedback.azure.com. Brent Ozar goes through what you’ve voted as the top 10 requests right now.

Conditional DELETE and INSERT in PostgreSQL

• by sabyda

• SQLServerCentral

Introduction We are comfortable with inserting/deleting record(s) into/from a table. But we sometimes get confused when we need to insert or delete records conditionally from a table. Let us look at an example. Example scenario Suppose we have a table, called ALL_EMPLOYEES, which contains all employees' information who are working or had ever worked for […]

Deeper into Nonclustered Indexes: Stairway to SQL Server Indexes Level 2

• by David Durant

• SQLServerCentral.com

By this stage, you should be familiar with the basics of SQL Server indexes. We've discussed what an Index actually is, as well as some of the most common types you're likely to encounter. Now that we've seen some simple examples of how Indexes can be useful, we're going to delve deeper into nonclustered indexes, as we'll see how they can improve the performance of more complex queries.

Incident Response Data

• by Steve Jones

• SQLServerCentral

• Disaster Recovery (DR)
• PowerShell

Being prepared for a disaster might mean having a way to collect data when something occurs.

Automating Azure DevOps with Logic Apps

• by Additional Articles

• SimpleTalk

• Azure DevOps

Azure Logic Apps can be used to automate steps like sending approval emails. Elie Bou Issa explains automating Azure DevOps with Logic Apps.

Take our survey to win a $500 Amazon gift card

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

Take the 2021 State of Database Monitoring survey and tell us about how you monitor your databases, instances and servers. By taking the survey, you’ll contribute to (and get early access to) the leading industry-wide report on database monitoring, and be entered to a prize draw for a $500 Amazon gift card.

You are cordially invited to attend 2021 Virtual Data.SQL.Saturday.LA event!

• by Press Release

• SQLServerCentral

We are reaching out to all people that enjoyed SQL Saturday in LA 2017, 2018, 2019, and 2020 events to let you know that the 2021 event is fast approaching. Only 30+ days remain until the June 12 Virtual Data.SQL.Saturday.LA event. Please register soon to reserve your spot by using http://2021sqlsatla.eventbrite.com/ hyperlink, register using a form below or just use a QR code.

Checking Up on Vendors

• by Steve Jones

• SQLServerCentral

• Auditing

Being able to audit the actions others take on your systems is important to Steve, especially when working in the cloud.

Understanding CRUD Operations on Tables with B-tree Indexes, Page-splits, and Fragmentation

• by Mohsin Khan

• SQLServerCentral

• Indexing
• SQL Server internal storage

Introduction Every DML transaction reads the data before it makes any changes. Not only during a SELECT query, but when you run any DML statement, insert, update, or delete, SQL Server first fetches a bunch of pages into the buffer pool locating the desired rows and changes them while synchronously writing to the transaction log […]

Running Dynamic Code Quality Checks on Flyway Databases: Table Smells

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

How to extend the range of SQL code analysis, during database development, to include dynamic analysis of the database metadata. This will allow regular checks for problems with the design of your tables and indexes ("table smells") that can affect database performance and data integrity.