We’re delighted to announce the Summit community pre-conference sessions and speaker lineup! Choose from 14 pre-cons featuring Brent Ozar, Kimberly Tripp, Melissa Coates, Itzik Ben-Gan, Denny Cherry, and others, taking place on Monday Nov. 14 and Tuesday Nov. 15. Full-day pre-con sessions will cover topics including database performance tuning and troubleshooting, T-SQL querying, DAX, security, cloud VMs, Azure Data Factory, Azure infrastructure, parameter sniffing, Power BI, PostgreSQL, equity toolkits, and much more!

Dealing with Transaction Log Growth

by Kenneth Igiri

SQLServerCentral

Uncategorized

Introduction Relational databases are designed to track changes introduced to a database by data modification language (DML) commands. The fundamental reason for this construct is to ensure that changes are durable and that they can be rolled back reliably. The typical DML command used in SQL are INSERT, UPDATE and DELETE. When INSERT introduces new […]

Flawed Data Integration

by Steve Jones

SQLServerCentral

software development

These days we often have multiple applications that need to exchange data in use by customers. Steve shares a few thoughts on his recent experiences.

Power BI Report Builder Expressions - Date Functions

by Daniel Calbimonte

SQLServerCentral

Learn about expressions and date functions in the Power BI Report Builder.

[Re-post] The 10 Benefits of Monitoring for Leaders

by Additional Articles

Redgate

Vendors/3rd-party Products

A third-party database monitoring tool is an investment that drives enormous value for the bottom line of a business in ten key ways, from simplifying cloud migration to retaining talent. Here's how.

Recover Recently Closed Tab in SSMS

by Additional Articles

MSSQLTips.com

Management Studio (SSMS)

Learn different ways to recover a T-SQL script when using SQL Server Management Studio if SSMS is accidently shutdown without saving the script.

Building a PC

by Steve Jones

SQLServerCentral

Hardware

Steve has a few thoughts on building your own PC to help you with work or your career.

The benefits of database change management

by Additional Articles

SimpleTalk

DevOps and Continuous Delivery (CI/CD)

Using a change management system for database code is a new idea for many database administrators. Grant Fritchey explains the many benefits of database change control.