If you don’t know what this means pay attention!! I recently posted a blog about the characteristics of a senior DBA. One of the points mentioned there was […]
Proof that tempdb mdf and ldf files are **NOT** dropped at the OS level when SQL Server is restarted
A quick video showing that the mdf and ldf files are actually ** NOT ** dropped during server restart. Thanks to Mike for bringing up this topic. https://www.youtube.com/watch?v=N4eB-uY5MYI […]
A ton of MS E-books to download
I am not sure how many other users have visited this blog but it’s been one of my go to places when I wanted to read up on […]
Renaming all columns in a table quickly
Recently imported a table where the column names where quoted using double quotes which then became the table names , So a column name would be “Airline” instead […]
Using Azure Scheduler
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 […]
The hazards of data types when deleting data
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 […]
Call me anything but a GURU
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, […]
Does Partitioning Improve Performance?
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 […]
Setting up Integrated Security / Windows Authentication with Azure SQL Databases
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 […]
Upgrading existing Azure databases to V12
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. […]