I am an IT Professional from the UK with a huge interest in MS technology especially SQL Server and Azure.
During 2015 I was mentored by Paul Randal – Data Platform (SQL Server) MVP of SQLskills.
I have written articles for SQL Server Central, TechNet, built the SQL Performance dashboard project on CodePlex with over 1600 downloads and I have helped gather data for SQLskills Waits and Latches Library. I have also helped the SQL Server product team with testing SQL Server vNext adaptive query processing feature.
My aim is to help you in your day to day work or to reinforce specific areas that I am interested in, so I try to keep things short and simple.
Sometimes I will reinforce basic concepts via a quick SQL Server video clip – https://blobeater.blog/sqlserver-video-library/
Arun Sirpal – BlobEater
p.s. I am no longer afraid to mention that I like Sheep.
I have actually lost Paulie in the garden.
Copyright © All rights reserved. You are free to use any of the content here for personal use but need permission to use it anywhere else on the internet.
A quick post that is hopefully useful, I wanted a quick way to find the time, size of the database file size change and who caused it.
Setting up AD authentication with Azure SQL Database sounds simple, it is assuming you plan carefully. I did run into issues but once rectified it felt great using AD authentication in Azure rather than just SQL logins.
Hopefully you know the relevance and importance of setting a correct value for max memory on your SQL Server. By default it will be the value 2147483647 which is not a random number but the 8th Mersenne prime! In a computing sense it is the maximum positive value for a 32-bit signed binary integer and that is big.
After using Microsoft SQL Server for over 10 years going back to MySQL feels weird BUT with Azure it is really easy to build a MySQL database and I have a feeling that this might be the start of an incoming change for some. For this post I want to show you what Azure currently offers I then create a MySQL database and connect to it via Azure Cloud Shell.
Have you heard of SQLskills? Have you heard of the waits library? If not then where have you been hiding?
I did a dangerous thing, and I want to make sure that YOU DO NOT do the same.
I was creating a couple of extended events sessions and was playing around with some actions. I ended up with the following code where I was after a guy called Shane:
I got bored (really bored) one weekend I decided to challenge myself. I had corruption within a specific table (localised within a page) with no backups handy only an old image of the data files. The challenge being salvage data without attaching the data files.
A small but nice little feature I have been using recently can be found within Query Store.
A quick blog post to start the day, If you remember a few months ago I blogged about SQL Server vNext https://blobeater.blog/2017/02/03/sql-server-vnext/, more specifically around the Adaptive Query Processing feature.
I promised a recap/review on my first SQLBits event so I finally got around to it, hopefully you will find it useful (even though it was 2 weeks ago!)