books

SQL Server Backup and Restore

  • Article

A DBA's tasks, from day-to-day, are rarely constant; with one exception: the need to ensure each and every day that any database in their charge can be restored and recovered, in the event of error of disaster. In this book, you'll discover how to perform each of these backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool.

4.5 (2)

2013-08-26

12,146 reads

SQL Server Concurrency: Locking, Blocking and Row Versioning

  • Article

Your application can have impeachable indexes and queries, but they won't help you if you can't get to your data because another application has it locked. That's why every DBA and developer must understand SQL Server concurrency and how to troubleshoot excessive blocking or deadlocking. Kalen Delaney's book is your guide.

5 (2)

2013-08-26

4,108 reads

SQL Server Transaction Log Management by Tony Davis and Gail Shaw

  • Article

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. An effective response to a crisis requires rapid decisions based on understanding its role in ensuring data integrity.

3 (2)

2013-08-26

5,541 reads

Blogs

Azure Platform Series: How to setup Azure Cloud Shell

By

This blog post will be a series on the Azure Platform and some things...

Daily Coping 5 June 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Use Chocolatey to Install Multiple SQL Server 2019 Instances for Testing

By

I’m working on a project where it’s useful to automate environment setup and teardown...

Read the latest Blogs

Forums

How to generating Excel File with multi sheet by using SQL server 2012?

By ahmed_elbarbary.2010

I need to create stored procedure or query or any thing on SQL server...

performance tuning for a subquery

By rohitkocharda

Hey Guys I have a quick questions regarding a better way to write a...

Maximum number of users that can simultaneously log in SQL 2016

By SQL_Hunt

Hello, By default, SQL Server allows a maximum of 32767 concurrent connections which is...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers