While conducting a training recently I was asked which is better Count(*) or Count(id) , while we wanted to discuss the topic further we didn’t have time so […]
SQL Server DEV and SSDT – MINDTREE – CHN – DEC
Some feedback from the training What did you like most about the training? Knowledge on SQL Trainers end to end knowledge about the tool. Explained concepts with hands […]
SQL 2012 Administration Societe Generale – JAN
Some feedback from the training What did you like most about the training ? Trainer’s skill and experience in technology Skilled knowledge pool of the Trainer
SQL 2014 ADMIN, DEV – Wells Fargo – JAN
Some feedback from the training What did you like most about the training? -Quite impressed by the way Jayant taught Performance tuning -In depth explanation of all […]
Storing the MDF and LDF files of SQL Server on Azure Storage Part 2
In this second part on the series of how to add mdf and ldf files to Azure Storage we need to create a credential in the database in […]
Storing the MDF and LDF files of SQL Server on Azure Storage Part 1
One of the new features of SQL Server 2014 that have been introduced allow users to create mdf and ldf files in the Azure BLOB Storage containers and […]
Exception Message: The client could not finish the operation within specified timeout. Killing the lease on a file in Azure BLOB
Exception Message: The client could not finish the operation within specified timeout. When backing up a database to the cloud if the network connectivity is slow or if […]
Installing SQL 2014
Installing SQL 2014, if you have ever installed SQL you shouldn’t find anything surprising here.
Part 2 Buffer pool extension SQL 2014
In this second part (read the first part here) of the series we continue testing the limits of our RAM and try to understand SQLs behaviour when it […]
Part 1 Buffer pool extension SQL 2014
In this series I am going to cover the feature Buffer pool extension in MS SQL Server. Now before we can discuss this feature it might be a […]