Planning to Increase Cost Threshold for Parallelism – Like a Smart Person!

Planning to Increase Cost Threshold for Parallelism
When administrating a SQL Server instance with multiple CPU cores and heavy workload, it’s...

How to fix Orphaned Users easily

What are Orphaned Users
“Orphaned Users” is a common issue in SQL Server where a Database User is no longer associated...

How to Update @@SERVERNAME to Actual Machine Name?

The @@SERVERNAME Global Variable
The system global variable @@SERVERNAMEcan be used to return the name of the machine the SQL Server...

DocumentDB Tutorial 2 – Working with Documents

Join Eitan Blumin in the next video of his DocumentDB Tutorials. This time learn how to work with the documents...

Meet the Team- Eitan Blumin

When I was about 7 years old and got my first computer during the early nineties,
I said “This is...

Automatic Roll Forward Transaction Log Backups

Performing a transaction log backup every 15 minutes has its advantages. But it also has disadvantages. Ever tried to restore...

Getting Started with Azure DocumentDB Programming

In my previous post in the series, I provided a short explanation on how to register your very first Azure...

My First Azure DocumentDB Account

In my first post in the series, I provided a basic introduction to Microsoft’s new product: Azure DocumentDB, and how...

Introduction to Azure DocumentDB

This is a basic introductory post about Microsoft’s new product: Azure DocumentDB, and how it compares to SQL Server.

What is...

Let SQL Server Write Code for You

Introduction
Many times I happen to find myself in a situation where, as a DBA, I need to write some long...