Additional Articles

Overview of In-Memory Technologies of Azure SQL Database

by Additional Articles

Database Journal

In-Memory

Azure SQL Database offers a straightforward approach to controlling its performance through vertical scaling. Despite its simplicity, scaling up has obvious pricing implications and, while it is an online operation, it might result in rollback of in-flight transactions. If you are looking for a supplemental approach to enhancing performance, then you might want to consider implementing in-memory technologies which are part of the Azure SQL Database feature set.

2018-11-13

2,109 reads

Testing PowerShell Modules with Pester

by Additional Articles

SimpleTalk

Pester

In the third article of this series on testing PowerShell code with Pester, Robert Cain demonstrates how to test the functions in a PowerShell module.

2018-11-12

2,113 reads

Unused Indexes - Are they really unused or have they just not been used YET?

by Additional Articles

Brent Ozar Blog

Indexing

Tara explains when index DMVs gets reset by telling a story from her dark past.

2018-11-09

3,197 reads

Azure EA Financial Reporting and Granular Access to Data Through the Enterprise

by Additional Articles

SimpleTalk

Azure

With the billing data from your Azure Enterprise Agreement collected into one database, it is still necessary to break down the costs and provide access to the correct departments and individuals. This is important for chargeback and further analysis. In this article, Feodor Georgiev demonstrates how to provide granular access to the billing data.

2018-11-08

2,241 reads

Simple way to Import XML Data into SQL Server with T-SQL

by Additional Articles

MSSQLTips.com

XML Datasource

In this tip we look at a simple way to import a simple XML document into a SQL Server table.

2018-11-07

3,140 reads

How Big is Your Transaction Log?

by Additional Articles

Database Journal

Transaction Log

If you are not managing the transaction log space used by a database, the transaction log might grow uncontrollably. With SQL Server 2017 there is a new dynamic management function (DMF) that exposes statistical information about a database transaction log. One of the things you can do with the information returned from this DMF is to determine how full a database transaction log file is.

2018-11-06

3,724 reads

Azure and Windows PowerShell: Using VM Extensions

by Additional Articles

SimpleTalk

Azure

In the third part of his series, Nicolas Prigent describes how to run post-deployment configuration and automation tasks on Azure Virtual Machines. Nicolas explains how to use Azure VM Extensions using the Azure PowerShell module to save time during the provisioning process.

2018-11-05

2,274 reads

5th annual “Seattle Freecon”

by Additional Articles

SQLServerCentral.com

Events

On Monday, November 5th, 2018, the 5th annual “Seattle Freecon” (a FreeCon in Seattle for those that might not be attending a pre-con before the PASS Summit) will be held. Put on by Jason Brimhall and Wayne Sheffield, there’s a set of 6 sessions you can attend for free that day. That’s right, absolutely FREE.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2018-11-02 (first published: 2018-10-29)

3,203 reads

Index Tuning Week: How Many Indexes Are Too Many?

by Additional Articles

Brent Ozar Blog

Indexing

When you're not sure, start by aiming for 5 or less indexes per table, with 5 or less fields each.

2018-11-02

4,276 reads

HIPAA and Database Administration – Part 2

by Additional Articles

SimpleTalk

HIPAA

HIPAA was signed into law in the United States in 1996. In this article, Robert Sheldon discusses how the act affects the day-to-day responsibilities of database administrators.

2018-11-01

2,480 reads

All authors

Additional Articles

Overview of In-Memory Technologies of Azure SQL Database

Testing PowerShell Modules with Pester

Unused Indexes - Are they really unused or have they just not been used YET?

Azure EA Financial Reporting and Granular Access to Data Through the Enterprise

Simple way to Import XML Data into SQL Server with T-SQL

How Big is Your Transaction Log?

Azure and Windows PowerShell: Using VM Extensions

5th annual “Seattle Freecon”

Index Tuning Week: How Many Indexes Are Too Many?

HIPAA and Database Administration – Part 2

Blogs

Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency

March 2026 SQL Server Security Updates

How Fabric Mirroring Transformed with SQL Server 2025

Forums

Multiple Deployment Processes

How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases

Upgrading Admin Queries

Question of the Day

Upgrading Admin Queries