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.
2013-09-19
1,690 reads
Brad's Sure Guide to Maintenance Plans shows you how to use the Maintenance Plan Wizard and Designer to configure and schedule eleven core database maintenance tasks, ranging from integrity checks, to database backups, to index reorganizations and rebuilds.
2013-08-26
8,015 reads
Inside this book, you will find dozens of practical, defensive programming techniques that will improve the quality of your T-SQL code and increase its resilience and robustness.
2013-08-26
9,467 reads
This book shows how to use of mixture of home-grown scripts, native SQL Server tools,
and tools from the Red Gate SQL Toolbelt, to successfully develop database applications in a team environment,
and make database development as similar as possible to "normal" development.
2013-08-26
4,728 reads
Brad McGehee provides a "career guide" for DBAs. It is intended both to help prospective DBAs find a "way in" to the profession, and to advise existing DBAs on how they can excel at their jobs, and so become Exceptional DBAs.
2013-08-26
11,312 reads
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.
2013-08-26
12,146 reads
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.
2013-08-26
4,108 reads
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.
2013-08-26
5,541 reads
Red Gate Books has released SQL Server Transaction Log Management, a free eBook on maintaining and troubleshooting the enigmatic transaction log based on the Stairway Series.
2013-05-23
1,484 reads
We’re putting together a free eBook of 50 tips for Azure Storage, if you’ve got tips that you’d like to share we’d love to hear from you.
2013-05-09
668 reads
By HamishWatson
This blog post will be a series on the Azure Platform and some things...
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
I’m working on a project where it’s useful to automate environment setup and teardown...
I need to create stored procedure or query or any thing on SQL server...
Hey Guys I have a quick questions regarding a better way to write a...
Hello, By default, SQL Server allows a maximum of 32767 concurrent connections which is...
Ask SSC