Monthly Archives: October 2015

Using Azure Scheduler

By | October 28, 2015

Azure scheduler is a feature that allows users to schedule activities within Azure. Scheduler works by first creating job collections. This is a great way to automate the call of web services. Creating the job After clicking the create scheduler job the below screen appears Click Custom Create, choose the region and give the job… Read More »

The hazards of data types when deleting data

By | October 27, 2015

Recently in one of the forums a question was posted where the developer had run a delete statement similar to the one below delete from #tmp where data =1 This deleted all the data in the table, obviously there was a large number of different values for the column data. Now the first and most… Read More »

Call me anything but a GURU

By | October 24, 2015

The first time someone called me a SQL Guru it felt a bit odd coz I never considered myself one. But once the initial shock had worn off, I felt extremely proud about finally having attained a title that I have been aiming for almost all my career. However over time I have realized the… Read More »

Does Partitioning Improve Performance?

By | October 22, 2015

Partitioning is a great feature for improving the way we manage our data. However we can also improve performance of select statements from the table as well. This requires a good understanding of the way partitioning works and how properly placing files on the disk can improve the IO performance. One common way that partitioning… Read More »

Setting up Integrated Security / Windows Authentication with Azure SQL Databases

By | October 20, 2015

In this lengthy post I explain how to setup Azure AD Authenticated users such that they may be used to connect to SQL Database hosted in Azure. Users of Windows azure will note that the only way till now to connect with SQL database hosted in Azure was via User names and passwords created for… Read More »

Upgrading existing Azure databases to V12

By | October 19, 2015

V12 of Azure database has been out for some time now. Combined with all the new features being released in Azure and PowerBI it makes sense to upgrade. This post shows you how:- Login to Azure website and select the database that you want to upgrade Under the quick glance menu on the right select… Read More »

Very Large datasets GB to TB – Where to get them for free?

By | October 19, 2015

Every once in a while I need a very large dataset to work with, most often this required creating dummy data using one of my favorite data generators called Mockaroo. But sometimes a few GBs is not enough, at these times I turn to a little know feature of AWS (Amazon Web Services). AWS has… Read More »

Measuring Uptime in SQL Server – Why nines don’t work

By | October 19, 2015

A key part of every DBAs jobs is maintaining uptime. A DBAs capability is measured by the amount of Uptime he is able to ensure on servers he manages. An important part of this is calculating the uptime of the servers. While it might sound simple over the years I have seen different calculations being… Read More »

SSIS and SSRS Training for Wells Fargo

By | October 12, 2015

4 day training for MS SQL Server SSRS and SSIS with Wells Fargo in Whitefield Bangalore. It’s going to be awesome. Going to create and SQL Server Monitoring Application using SSIS and SSRS and hopefully a few other different types of Reports too. Busy months ahead.

LnT Infotech SQL Server Training

By | October 12, 2015

Just finished a virtual training for LnT InfoTech in EPIP industrial Area. Looking forward to the next training with Well Fargo