Tony Davis

  • Interests: football, modern literature, real ale

SQLServerCentral Article

SQL Server Crib Sheet Compendium

As a developer, DBA or manager, you may not really want to know all about XML, replication or Reporting Services, but if your next project uses one or more of these technologies heavily then the best place to start is with the 'jungle roof' view of each topic that this Crib Sheet compendium provides.

2022-04-27 (first published: )

10,871 reads

External Article

What’s New in SQL Monitor 10?

SQL Monitor 10 packs a lot more under the hood in terms of connectivity, establishing cause-and-effect, and alerting. This article provides the high-level tour of the features we've introduced or improved, and why.

2020-03-20

Stairway to Transaction Log Management

Stairway to Transaction Log Management in SQL Server, Level 1: Transaction Log Overview

The transaction log is used by SQL Server to maintain data consistency and integrity. If the database is not in Simple-recovery mode, it can also be used in an appropriate backup regime to restore the database to a point in time.

5 (2)

You rated this post out of 5. Change rating

2019-03-26 (first published: )

25,053 reads

Tribal SQL eBook Download

TribalSQL: 15 New Voices in SQL Server

MidnightDBA and Red Gate have joined together to produce a new book on SQL Server, written by 15 first-time authors. The resulting book, TribalSQL, includes everything you should know about SQL Server that isn’t taught in traditional training, they call it Tribal knowledge.

You rated this post out of 5. Change rating

2019-03-26 (first published: )

401 reads

Blogs

Announcements from the Microsoft Fabric Community Conference

By

(Shameless plug: The price of my book “Deciphering Data Architectures: Choosing Between a Modern...

The Basics of TRY CATCH Blocks–#SQLNewBlogger

By

I was working with a customer and discussing how to do error handling. This...

Working with ALS – Insights from the Ability Summit

By

The 14th annual Ability Summit is a global event that I attended a few...

Read the latest Blogs

Forums

how to return the min value of a column if a sub-query returns no results

By water490

Hi everyone My query works for most cases.  There is one edge case where...

Basic SQL Query question

By jjevans

Hello, I was given this SQL question and was hoping someone could please help...

Different logical drives in 2024?

By kevin.j.sexton

In recent days past, there was a Performance gain by placing data files, log...

Visit the forum

Question of the Day

Backing up the Resource Database

How does the Resource database in SQL Server 2022 get backed up?

See possible answers