Press Release

Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".

2019-09-11 (first published: )

103,660 reads

SQL Server Transaction Log Management eBook Download

Free eBook: SQL Server Transaction Log Management

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.

2019-09-04 (first published: )

104,952 reads

Free eBook: SQL Server Internals: In-Memory OLTP

In this free eBook, Kalen Delaney explains how Microsoft's 2016 In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton.

2019-08-28 (first published: )

55,467 reads

Free eBook: SQL Server Execution Plans, Third Edition

If a query is performing poorly, and you can't understand why, then that query's execution plan will tell you not only what data set is coming back, but also what SQL Server did, and in what order, to get that data. It will reveal how the data was retrieved, and from which tables and indexes, what types of joins were used, at what point filtering, sorting and aggregation occurred, and a whole lot more. These details will often highlight the likely source of any problem.

2019-08-21 (first published: )

119,575 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.

2019-08-14 (first published: )

82,179 reads

Redgate Takes over the SQLCop Project

I am happy to announce the Redgate Software and I are supporting and taking over stewardship of the SQL Cop project at this point. With permission from its founder, George Mastros, we will host the main repository for the project at https://www.github.com/red-gate/sqlcop. This should be considered the official repository for the code from this point […]

5 (1)

2019-08-13

2,826 reads

Blogs

Origem Flash Headphone Sale

By

I reviewed a set of wireless headphones this summer, and I continue to use...

Troubleshooting NUMA Node Inbalance Problems

By

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get...

Graph – Shortest Path

By

‘Shortest path’ is by far the most feature of SQL Graph for now. What...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

Duplicate data

By arvind.patil 98284

Hi Experts . I have table Temp_decimal_mismatch which has duplicate data . The duplicate...

https://faqssupplement.com/provexum-uk/

By nakusybaktkus

However the problem is the quality of the last thing these remedies! There have...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers