Azure SQL Database provides a number of benefits that leverage resiliency and redundancy built into the underlying cloud infrastructure. You can take advantage of these features in order to perform backup, restore, and failover tasks, which help you recover from human errors, service outages, or even regional disasters. In this article, Marcin Policht provides an overview of the primary capabilities incorporated into Azure SQL Database, in particular focusing on point-in-time restore

An Impressive SQL Server

by Steve Jones

SQLServerCentral.com

Editorial

This Friday Steve Jones has a poll about which SQL Servers might impress you. Is there a company or installation that you think would really showcase the power and scalability of SQL Server?

SQL Server on Linux

by Steve Jones

SQLServerCentral.com

The Lighter Side

A secret project is underway up in Redmond, according to sources not so high up in the development team. A port is partially working for various reasons. Read this exclusive scoop!

Oracle Error When Importing An Interval Partitioned Table

by Additional Articles

Database Journal

Oracle

Oracle 12.1.0.2 can throw an ORA-01438 when importing an interval partitioned table. In this post, David Fitzjarrell suggests a work-around until Oracle patches the bug.

Correct Old Mistakes

by Steve Jones

SQLServerCentral.com

Editorial

We all make mistakes, but it's important that we revise our code to correct them over time.

Data Mining Part 34: Preparing for a certification exam

by Daniel Calbimonte

SQLServerCentral.com

In this article we will talk about the Microsoft certifications related to Data Mining.

SQL Server Data Tools (SSDT) and Database References

by Additional Articles

SimpleTalk

SQL Server Data Tools (SSDT)

SQL Server Data Tools (SSDT) provides, via the DacPac, interesting support for verifying not only those references within the database, but also those to other databases even if they are on other servers. Although it is adds an extra level of complexity to deployments, it can increase the probability that deployments will succeed without errors due to broken references or binding errors. Ed Elliot investigates.

The Boardgame of Office Politics

by Additional Articles

SimpleTalk

Sometimes the stress of interdepartmental friction withing organisations, can get on top of you, especially between the business and IT when the going gets tough. Simple-Talk's answer is a board game to put it all into perspective. Instead of getting carried away, play the board game instead and reach catharsis.

Byte Me: Private Cloud

by Bob Lang

SQLServerCentral.com

Editorial

Vapourware.

Advanced Mathematical Formulas using the M Language

by Additional Articles

MSSQLTips.com

Power BI Designer

The Power BI desktop designer contains a rich set of advanced mathematical functions. In this article, John Miner shows how you can combine these functions together in a computed column to solve numerical business problems.

Azure SQL Database Resiliency - Point-in-Time Restore

An Impressive SQL Server

SQL Server on Linux

Oracle Error When Importing An Interval Partitioned Table

Correct Old Mistakes

Data Mining Part 34: Preparing for a certification exam

SQL Server Data Tools (SSDT) and Database References

The Boardgame of Office Politics

Byte Me: Private Cloud

Advanced Mathematical Formulas using the M Language

Blogs

Claude AI Convinced Me Not to Build an iPad App

A New Word: Dolorblindness

Claude Code Helps Analyze Test Data Manager Log Files

Forums

Data Warehouse Toolkit meets Star Schema: The Complete Reference

GPX distance and time analysis in SQL Server

The DBA is Dead; Long Live the DBA

Question of the Day

Changing the AG Listener