Tags » Microsoft SQL Server

Techfuse, a New Laptop, and How Microsoft Azure Helped Save the Day

On Tuesday, April 22, I had the opportunity to speak at the Techfuse conference in Minneapolis. I was presenting a session on the differences between tabular and multidimensional models with a focus on the developer’s experience. 677 more words

Microsoft SQL Server

Collation: Confusion

I started reading about collations after I had a recent run in with them. As I read I started to realize that for a seemingly simple subject there was a lot to it. 676 more words

Microsoft SQL Server

Understanding the Three A's of Security for SQL Server

Do you know what the “Three A’s of Security” are and how they apply to Microsoft SQL Server? Let’s look at them as they are important for managing security properly on a given Microsoft SQL Server. 340 more words

Syndicated

Collation: Temporary objects and variables: Demonstration

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. 470 more words

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. 948 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