In out last post we created a virtual network, in this post we create a virtual machine and map it to our virtual network. There are tons of […]
Creating a Virtual network in Azure
A virtual network like its name suggests is an imaginary network created within Azure to give users the feel of having a private network within the cloud. This […]
Creating a Web App Role and Website in Azure
In this second post we explore how to create a Web App in which we can host a website and then bind our Public IP Address. In order […]
Adding a Public IP to Azure
In this post I show how to get a new Public IP provisioned for use with Web applications from the Azure Management Portal. It all starts with an […]
administration / Database / MSSQL / TSQL
Using Openrowset to import data from a CSV file
If you are using a 64 bit edition of Windows then you are most likely using a 64 bit edition of Office and as a result of Access […]
A few more free e books
A few more free e-books for the SQL DBA. This from REDGATE and some of the most prolific writers and SQL Experts in the world. I am sure […]
Loading Resumes and searching them using SQL Server – Part 2/2 (PDF+ FileTable + Full Text Search)
In this post we continue after creating our file table and posting some pdf documents into it. For the previous post please click here. Apparently there is very […]
Loading Resumes and searching them using SQL Server
Recently I came across a requirement where we needed to load Resumes into SQL server and then search these documents for specific keywords. Important things to keep in […]
Video on Memory Optimization for SSIS packages
Improving RAM Utilization within SSIS packages using data types. In this video we explore the impact of incorrect data types on how SSIS allocates RAM and the simple […]
Chinese Hackers(Cracker) and Azure, have I hit the bigtime??
I have a website hosted on Azure which I use for my trainings. Today I received a number of alerts from Azure showing High CPU usage for the […]