Latest Blog Posts
As with everything on this site...The owner of gethynellis.com will not be liable for…
The most common questions I’m asked during networking sessions at technical conferences and events aren’t technical! People want to know what it’s like being an independent consultant. Things like how to get started and what to look out for are common themes. So I wanted to share the some… Read more
I thought I would share the output of some DiskSpd tests that I conducted on Azure VMs that ultimately will have SQL Server installed. I will then show a comparison of the same test on my local (average) machine.
DiskSpd – This is a tool that is provided by Microsoft… Read more
The following command is run to gain details on deadlocks.
DBCC TRACEON (1222,-1)
However, once the SQL instance is restarted this flag is set back to disabled.
To enable it on the instance upon startup:
- Open SQL Configuration Manager
- Services > Sql Service Instance > Properties > Startup Parameters
I got a call the database, not online/available mode, we suspect there was a corruption. One of my AlwaysON secondary database went suspect mode, it’s because of the log file and drive was full. I tried to resume the database. ALTER DATABASE dbname SET HADR RESUME;.
It went “in… Read more
What’s going on here?
So last week you may have seen this picture on Twitter…it went a little crazy…and you may have been wondering what are we up to? Well, last week I had the pleasure of filming a Pluralsight Play By Play. A Play By Play is a… Read more
A major benefit of Azure SQL Database (PaaS) is the fact that Microsoft manages the backups – it’s great because recovering to a point in time is straightforward.
With all editions of the database full backups are taken every week, differential backups are taken hourly, and transaction log backups are… Read more
As a SQLSat veteran and organizer, I regularly receive feedback that there needs to be "more" content at the elementary level for new folks in the field, students, etc. I try…
I tend to try and get code on the screen quickly and then start to remove things. I’m a visual person, and it’s helpful for me to see some tables, joins, filters, and columns as I’m structuring a query.
First - the big one. I am honored to be chosen for the first time to speak at the PASS Summit in Seattle. The only negative is that I am not on until Friday…
It’s not my fault. I had to be sarcastic. I had to mention the correct Read more
In this module you will learn how to use the Bubble chart Power BI Custom Visual. The Bubble chart allows you to show the value of categories proportionally represented by the size of the bubble.
Module 16 – Bubble
The collection of Azure SQL Database cmdlets can be found at – https://msdn.microsoft.com/en-us/library/mt574084.aspx. There are alot, however I tend to use the following quite frequently and I am sure they will be useful to others too.
You can scale your database up or down with the Set-AzureRmSqlDatabase command –… Read more