Latest Blog Posts
Right now one of the hottest topics around the world is the cloud and the successful methods for the migration to the cloud. In the world of Microsoft Data Platform and the relational databases, the Azure SQL Database represents one…
I'm proud to have been a part of SQLSaturday Charlotte 2016 this year, and happy that I was joined by a number of my colleagues from Sparkhound. We're establishing a presence in Charlotte and already have a couple big clients in the area, so Sparkies from both Baton Rouge and…
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
I have had an interesting week teaching Learning Tree course 534 Developing SQL Queries for SQL Server. I had an interesting group from a variety of technical background all wanting to improve their skills in writing queries. Today's the last day, we have had some great questions as the week…
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, … Continue reading
I'll be presenting my talk on SQL Server Permissions and Security Principals
this weekend at SQLSaturday #560 Charlotte, NC.
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.
One of the ways I work quickly is with SQL Prompt Read more
I have some great speaking dates coming up this Fall - here is the list:
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…
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
This week's Great Value IT Offers are in. If you want to your ITIL learning on this autumn we have some great deals for you :
ITIL® Intermediate: Operational Support and Analysis
3rd October 16
Introduction - Detecting and Monitoring Memory Pressure
I will be writing this article in four parts because this
topic is huge and amount of information can be overwhelming for readers and for
me also. So we will be exploring it step by step.
Alert and perfmon…
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. Scaling You can scale … Continue reading
I do not say you should be expert in other technologies but you should be aware of what it is and whats the purpose and whats its characteristics and basics. when we talk of RDBMS (DBMS) like SQL most of … Continue reading
My wonderful friend Chrissy LeMaire and I are the creators of two GitHub repositories for SQL Server and PowerShell called dbatools and dbareports
If you are working with SQL Server I highly recommend that you take a look at the vast number of commands available to you at dbatools which… Read more
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them here. In this week’s episode, we’re discussing how Slack can improve your company’s internal communication.
Over the past year, the Pragmatic Works team has been successfully using Slack for internal… Read more
This is just a quick reminder to encourage you to attend my next round of all-day precon training session at the upcoming SQL Saturday in Minnesota on Friday, September 30 called ‘The Complete Primer to SQL Server Infrastructure Tuning‘.
The focus of the course is to help those… Read more
Just a quick blog post about an error I recently encountered when trying to create a mobile report for SSRS 2016, using the Mobile Report Publisher. I created the following query on top of the Wide World Importers data warehouse:
Recently I have been creating many Azure SQL databases via the portal where I started to find it quite tedious. So I decided to find a scripted approach via PowerShell where I could just change some parameters and hit enter. I … Continue reading