Uses for SQL Server 2014

This week I gave a presentation to a client on using SQL Server 2014 in-memory features. This was just an overview session to give them an idea of what it was and how it works. The discussions that acme of out of this were quite interesting. One in particular stands out.

(more…)

Backup optimization: Data only backup

Over time, our databases get bigger and bigger. One possible solution to reduce this problem is the use of backup compression. Mind you – wouldn’t it be better to start by reducing the volume of information to back up? In databases, most of the information to be backed up is in these three types of object:

(more…)

Testing latency between client and SQL Azure via client statistics in SSMS

As I write this blog post, There are six location options while provisioning a SQL Azure server. And so while provisioning a SQL Azure server, who may have to decide the optimal location of the SQL Azure server based on the criteria that the latency between your application and the SQL Azure server is the minimum. And as you may know, we get better performance – if we are are able to minimize the latency between client and SQL Azure. So let’s get into action.

(more…)

Summary – SQL server to SQL Azure migration

In this blog post, I aim to summarize database migration options that I have been blogging about for past few weeks. Choosing right tool is a key decision when you decide to migrate SQL server to SQL Azure – And I hope this blog post can help you decide which is the best tool to be picked for your scenario: (more…)

CLR: Not In My House! Really?

SQL Server supports CLR objects in a database. But – how much do we use them? I find myself as one of the rare SQL CLR users. I created myself a set of tools that include data types, scalar and especially aggregate functions. I use them for data overview and data quality assessment during data mining and master data management projects. Many times I encounter an obstacle for these objects: a DBA saying “CLR? Not in my house!”, and CLR is ruled out on that server.

(more…)