Menu

Speaking at SQL Saturday Dallas

0 Comment

Speaking at SQLSaturday Dallas! I’m proud to announce that I will be speaking at SQL Saturday Dallas on May 17th 2018! This one won’t let you down! Check out the amazing schedule! If you don’t know what SQLSaturday is, it’s a whole day of free SQL Server training available to you at no cost! If you haven’t been […]

Mini-Rant: Spoofed Phone Numbers and Trust

0 Comment

I’ve seen this more and more over the last year: I receive a phone call with a number that indicates it’s coming from a town or city near me. For instance, I received a call where the number reported to Chapin, SC. Curious to see if it was a company trying to sell something, I […]

Containers: Create a Custom Container

0 Comment

Creating a custom container is where things get truly exciting. There’s actually a ton of work and knowledge around this. To start with, I’m going to keep it simple. I’m going to create a container with a database & some data and a couple of general customizations. From that, we’ll create our own container. To […]

Using Azure Data Factory Mapping Data Flows to populate Data Vault

0 Comment

(2019-May-24) Data Flow as a data transformation engine has been introduced to the Microsoft Azure Data Factory (ADF) last year as a private feature preview. This privacy restriction has been lifted during the last Microsoft Build conference and Data Flow feature has become a public preview component of the ADF.There are many different use-case scenarios that can […]

New Azure “SQL Server settings” blade in the Azure Portal

0 Comment

I just noticed today that there is a new blade in the Azure portal when creating a new SQL Server virtual machine. I’ve been looking for an announcement regarding this new Azure portal experience, but I haven’t found one yet. This feature wasn’t available when I took the screen shots for my last post on […]

Mass Backup All Sessions

0 Comment

Migrating Extended Event Sessions from one server to another should be a simple task. So simple, one would think there was no need to give it a second thought, right? Well, I have previously written about this topic, you are welcome to read it here. The article discusses quite a bit about scripting out your […]

The SQL Change Automation in SSMS Beta

0 Comment

Give it a try, as the beta is out. I’ve been watching this product and getting updates for the last six months or so and lately I’ve been pushing to get this out. It’s close enough to be useful and helpful for me, and I wanted to get other feedback. Someone listened and you can […]

Containers: Working With Volumes

0 Comment

In the previous two posts on containers I showed how use Docker commands to get an image and create a container. This time, we’re going to create a container again, but, we’re also going to create a volume so we can do some fun stuff. For an understanding of why I’m doing a series of […]

db_owner in msdb == sysadmin

0 Comment

This doesn’t require much in the way discussion. This isn’t exactly a huge issue since I don’t think granting db_owner in msdb happens a whole lot, but still. Consider yourself warned. I should add, this will work on any database that has trustworthy turned on and the dbo is a sysadmin. Oh, and my understanding […]

Filtered Index Basics

0 Comment

In this post, we continue with another beginner’s blog of database features that may be unknown to many. Let’s take a look at filtered indexes. Many database administrators are fully aware of the power of indexes and know how to create them. However, I find that some have yet to dive into fully optimizing their […]