Tags » Microsoft SQL Server

How to halve your database recovery time in 60 seconds

Introduction

Picture the scene. Your sitting at you’re desk one morning and a user bursts in in a blind panic and tells you your company’s most critical system is down and your business is currently dead in the water. 885 more words

SQL Server

Monitoring Dirty Pages in the Buffer Pool

A few people have commented that they found a post I did a while back on per database RAM usage quite helpful. You can see that article here: 429 more words

SQL Server

Rookie SQL Server Mistake: Check your editions BEFORE doing a massive restore

A quick tip to anyone doing a large restore of SQL Server databases – check the two editions BEFORE starting. By edition, I don’t mean 2012 -> 2014, I mean Enterprise Edition-> Whatever… 256 more words

SQL Server

Who is an expert?

Recently Paul Randal had a brief rant on twitter where he complained about the fact that there are no stupid questions. This lead to a discussion on and how experts should and should not react to said questions. 446 more words

Microsoft SQL Server

SQL Server Reporting Services: How to add Interactive Sorting to a Table with no groups?

Sorting is one of the common requirements in a SSRS report that business users ask for, even if they don’t ask – it’s great to have interactive sorting enabled at places where it makes sense. 128 more words

Microsoft SQL Server

Oracle Tips for MSBI Devs #6: Supporting SSAS Tabular Development

As SQL Server Analysis Services Tabular Models become more popular, models will use Oracle databases as sources. One of the key issues whenever you work with Oracle is understanding how to properly configure the necessary components to enable development. 715 more words

Microsoft SQL Server

Collation: Correction -> Instance

I had a recent run in with collation problems and it got me started reading about them. As I read I started to realize that for a seemingly simple subject there was a lot to it. 307 more words

Microsoft SQL Server