Consultant & Trainer for all things MSSQL
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 I promised to write a blog about it. Coming right down to it, in almost all cases Count(*) is better. Typically you won’t be able to tell…
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 on. Came to know topic didnt know earlier. Trainer was able to explain the topics covered in training. Performance improvement only by basic stuff(e.g. index) Trainer is…
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
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 the key concepts. -Given real time examples wherever needed which helps understanding complete picture
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 order to allows it access to the Azure storage space. Click here to read part 1 CREATE CREDENTIAL [https://mydatabase122.blob.core.windows.net/sqldata] – name OF the storage account WITH IDENTITY…
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 still have it listed in the on premise database server as a valid database. While I find it hard to find a good use case for this…
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 the database backup operation was halted in between then the blob (backup file) remains locked in the Azure storage space since the operations didn’t complete. In such…
Installing SQL 2014, if you have ever installed SQL you shouldn’t find anything surprising here.
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 encounters memory pressure. To this end we have created a table that is little more than 2 GB in size and have set out SQL server buffer…
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 good idea to define what a buffer pool is and why it needs extensions in the first place. The buffer pool is that part of the RAM…
There are a million articles, blogs post etc. about indexes out there, I am guilty too of contributing to it. Here is my attempt at correcting the vast amount of theory with a quick crash course on index F1 style, ideally in a few quick minutes you should go from 0 to 300 What I…
If you have a large database then you probably have table partitioning implemented. While I have already blogged a lot about partitioning one feature that is really useful in SQL 2014 is the ability to rebuild an individual partition online. Previously for VLDB that contain partitions you either had to rebuild the index on the…
One common usage for the expression task in SSIS is to implement conditional flow of the constraints. In the below screenshot you can see that we implement an expression tasks which follows an error checking activity and evaluates if there were any errors , if yes the execution move to the right else to the…
In this post we cover the T-SQL command used to restore the database from the backup URL RESTORE DATABASE madworks FROM URL = ‘https://ebsclouddbstore.blob.core…….madworks_backup.bak’ WITH CREDENTIAL = ‘Azureblobbackups’ ,STATS = 5 — use this to see monitor the progress The output shows the time taken to restore the database, a sloppy 2 seconds for a…
When restoring the database from a cloud URL there is a chance you will encounter the below error. Msg 3271, Level 16, State 1, Line 1 A nonrecoverable I/O error occurred on file “https://ebsclouddbstore.blob.core.windows.net/mssqlbakups/madworks_backup_2015_01_13_134617.bak:” Backup to URL received an exception from the remote endpoint. Exception Message: Error occurred while referencing Blob in remote storage. Msg…