Out of memory error because of the very low virtual address space – Error 701 – Trace Flag 8075

If you are dealing with a SQL Server which got a lot of memory, you may encounter the out of...

Penny wise, pound stupid

Growing up my mother used this phrase quite a bit. Penny wise, pound stupid. (In case you didn’t know the...

Setting up SQL Server to SQL Database (Azure) Replication

I had a need to setup transactional replication from my SQL Server to SQL Database (Azure) where I only needed...

SQL Clone and Encryption

I’ve been testing and working with SQL Clone for the last few months, trying to help the devs at Redgate...

SQL Server Tips and Tricks

In this article I will be listing the tips and tricks to work like
a Pro. 

So let's get started –

Important keyboard...

I’m a VMware vExpert

To add to an already amazing year, recently I was named a VMware vExpert for 2017. I’m honored, humbled, and...

SQL Cruise 2017 – Western Carribean – my experience

As some readers may know, I am a regular attendee on SQL Cruise s for 8 years now. SQLCruise is...

CLR Stored Procedure Cannot Be Marked as System Object?

It is an open secret that in SQL Server, we can “create a system object” by using an undocumented stored...

Deadlock priority

Everyone deals with deadlocks from time to time. But sometimes we need to control who’s the deadlock victim and who...

Friday Reading 2017-02-17

Is it me or is February dragging? Anyway, mixed in with this crazy week I’ve been reading: –
SQL Server vs...