With remote working still encouraged around the world, there is a need to ensure that operations teams have full visibility of your estate, not just your production servers. If your engineering teams have access to secure development and testing servers, deployment issues are caught before they reach production. Find out how to keep communication flowing between DBA and development teams in this free whitepaper. Read the whitepaper here.

Lean Coffee

by Steve Jones

SQLServerCentral

Meetings

Lean Coffee is a way of organizing a meeting that might not have an agenda.

Stairway to SSAS Tabular Level 11: Partitioning

by Thomas LeBlanc

SQLServerCentral

Analysis Services (SSAS)

In this next level, we cover partitioning for SSAS.

SQL Server Transaction Log Management eBook Download

Free eBook: SQL Server Transaction Log Management

by Press Release

Redgate

Transaction Log

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.

Why choose Oracle?

by Additional Articles

SimpleTalk

Oracle

Oracle has been established as one of the top database systems used in enterprises throughout the world. In this article, Cynthia Dzikiti describes her career as an Oracle application developer and covers some of the benefits of Oracle.

Recovering Databases From a Master Backup

by Steve Jones

SQLServerCentral

Losing your instance might result in the need to get information from what you have. Steve Jones looks at a way to get the proper version and patch, and database list, from what limited resources you might have.

The Next Evolution of Big Blue

by Steve Jones

SQLServerCentral

Cloud Computing

IBM is breaking up and Steve thinks back about the evolution of the company and where they might go from here.

Execute SSIS Package from PowerShell - Part 1

by Additional Articles

MSSQLTips.com

PowerShell

In this article we look at how you can execute SSIS package using PowerShell both with and without SSIS package parameters.

SQL Server Phone Home

by Steve Jones

SQLServerCentral

SQL Server shares some data with Microsoft, but the use is documented. Steve sees this as a model for how companies might share information.

Let’s move: Azure Resource Mover

by Additional Articles

SimpleTalk

cloud

Moving resources from one location to another in Azure has been possible but not easy to do. In this article, Dennes Torres introduces an exiting new Azure feature: Azure Resource Mover.

Create a Feedback Loop between Devs and DBA Teams with Monitoring

Lean Coffee

Stairway to SSAS Tabular Level 11: Partitioning

Free eBook: SQL Server Transaction Log Management

Why choose Oracle?

Recovering Databases From a Master Backup

The Next Evolution of Big Blue

Execute SSIS Package from PowerShell - Part 1

SQL Server Phone Home

Let’s move: Azure Resource Mover

Blogs

Methodology for dealing with bad data in production

How to Provision an Azure SQL Database

Claude finds two cryptographic weaknesses (but the sky isn’t falling)

Forums

Why SQL Server Database Attach fails and how to repair it

Fixing P1 Queries

BIT_COUNT() IV

Question of the Day

BIT_COUNT() IV