SQL

Gitflow Workflow Hotfix Branching for SQL Database Projects

• by Additional Articles

• MSSQLTips.com

• DevOps and Continuous Delivery (CI/CD)
• Git

• Article

Git is a great tool for source control and in this tip we look at how you can utilize Git source control to build and deploy database hotfixes.

2021-02-10

Oracle archived redo size – the research

• by Additional Articles

• SimpleTalk

• Oracle
• SQL

• Article

Oracle archived redo size may be smaller than that of online redo log files. In this article, Jonathan Lewis takes a deeper look.

2021-02-04

Managing database changes using Flyway: an Overview

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

This article describes the principles of using Flyway migrations to build a database from scripts, to a specified version, and to track, manage and apply all database changes.

2021-02-03

SQL Server interview questions for experienced developers

• by Additional Articles

• SimpleTalk

• Free Training
• SQL Server
• SQL Sever

• Article

SQL Server tech interview questions must be well crafted to make sure the candidate actually knows the topic. In this article, Sergey Gigoyan provides his favorite questions for interviewing SQL Server developers.

2021-01-27

• Discuss

Heaps in SQL Server: Part 4 PFS contention

• by Additional Articles

• SimpleTalk

• Development

• Article

When inserting rows into a heap, SQL Server must sometimes update the PFS page which can PFS contention and affect performance. In this article, Uwe Ricken demonstrates how to measure PFS contention.

2021-01-25

DAX financial functions: Depreciation calculations

• by Additional Articles

• SimpleTalk

• BI

• Article

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson continues his series surrounding the DAX financial functions. In this article, he exposes four functions that are popular in the calculation of depreciation and amortization. Those accustomed to these functions within Excel will find the syntax, uses and operation of the functions familiar within the Power BI environment.

2021-01-19

The Joy of Realistic Generated Fake Database Data

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

Have you ever had to demonstrate a database-driven application, and longed to have the real data to do so? To do what, precisely? Well, so you can then scroll through the customers who have used the system, demonstrate the accounting and audit, browse through the products, maybe even demo the customer tracking system with comments, complaints and so on. All this is possible, using realistic, fake data.

2021-01-08

SQL Server Error Log

• by Additional Articles

• SimpleTalk

• SQL Server

• Article

The SQL Server error log is a great source of information for DBAs for monitoring errors and the operation of the server. In this article, Greg Larsen explains the details and how to configure the SQL Server error log.

2021-01-08

DBA in training: Know your server’s limits

• by Additional Articles

• SimpleTalk

• Database Administration

• Article

Comparing current performance to baselines helps DBAs know when there’s a problem. In this article, Pamela Mooney describes how to measure the physical resources drive space, latency, memory, and CPU.

2021-01-06

Import Excel Data into SQL Server with PowerShell

• by Additional Articles

• MSSQLTips.com

• PowerShell

• Article

In this article we look at PowerShell code you can use to import Excel data into SQL Server.

2021-01-05