Articles

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!

2022-06-15

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 […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.8 (5)

You rated this post out of 5. Change rating

2022-06-13 (first published: 2022-06-10)

6,368 reads

Discuss

Power BI Report Builder Expressions - Date Functions

by Daniel Calbimonte

SQLServerCentral

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

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (1)

You rated this post out of 5. Change rating

2022-06-13

15,233 reads

Discuss

[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.

2022-06-13

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.

2022-06-13

1,907 reads

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.

2022-06-10

Optimizing my.cnf for MySQL performance

by Additional Articles

SimpleTalk

MySQL

Database systems often need tuning for best performance. Lukas Vileikis explains to how to optimize my.cnf for MySQL performance.

2022-06-08

Why Database Monitoring Tools are Important for Senior Leaders

by Additional Articles

Redgate

Vendors/3rd-party Products

Matt Gordon is a Microsoft Data Platform MVP and the Director of Data and Infrastructure at Rev.io. In this short video, he talks us through the 3 key reasons database monitoring tools are essential for him as a Director, and how they help him to lead a team successfully and productively.

2022-06-08

How to grant PowerBI Service Workspace access using PowerShell

by G_M_J

SQLServerCentral

Learn how to more easily manage permissions in the Power BI service using PowerShell.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (3)

You rated this post out of 5. Change rating

2022-06-06

2,865 reads

Discuss

Database Testing in a Flyway Development

by Additional Articles

Redgate

Vendors/3rd-party Products

If you can test and evaluate databases, and database objects, at every phase of the database development lifecycle, then you are much more likely to be able to adopt continuous delivery. The further down the delivery pipeline that bugs appear, the more costly in time and resources they are to fix.

2022-06-06

Articles

Summit 2022 Community Pre-cons have been announced

Dealing with Transaction Log Growth

Power BI Report Builder Expressions - Date Functions

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

Recover Recently Closed Tab in SSMS

The benefits of database change management

Optimizing my.cnf for MySQL performance

Why Database Monitoring Tools are Important for Senior Leaders

How to grant PowerBI Service Workspace access using PowerShell

Database Testing in a Flyway Development

Blogs

The pros and cons of self-service BI: What every industry leader should know

Off to the PASS Data Community Summit 2024

Implement a RAG Solution Using Azure SQL Database

Forums

Canon PowerShot G7X Mark III Digital Camera with 4.2x Optical Zoom Lens (Black)

Error sub query return more than one value

How to change font size in Query window

Question of the Day

Cloud Sources for the Data Migration Assistant