Grant Fritchey

gfritchey

I've been hearing this a lot lately: "DevOps and automation will eliminate my job." It's just not true. In fact, it's very much the opposite.

In order to support realistic testing, you need to have both a realistic environment and some way to generate load in that environment. This video shows you one way of setting up a collection of Azure SQL Databases to simulate a real environment. I then use PowerShell to generate load within that environment.

#azure #azuresqldatabase #sqlserver

An experiment in which I do a demo presentation using the Twitch interface to show of how Redgate SQL Monitor supports Azure SQL Database. -- Watch live at https://www.twitch.tv/gfritchey
#redgate #sqlmonitor #azure

I still get people questioning whether or not the GDPR and GDPR-style laws are going to affect us here in the US. I hate to be the bearer of bad news, but it absolutely is going to affect us. You have to be ready.

#gdpr #compliance #cppa

Implementing DevOps is difficult enough without adding the whole issue that communication is just difficult. One part of communication that is difficult is complaining. Letting people know that something is wrong and needs to be fixed is not as simple as pointing at the problem. In order to complain better, you need some of the techniques I outline in this video.

#gdrp #communication #complaining

There are hundreds of properties that describe a database. Most of them go far beyond the fundamentals. However, a few need to be addressed right at the start of creating and controlling databases. This video discusses those properties and how to use the ALTER DATABASE command to manipulate them.

ALTER DATABASE: https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-set-options

#sqlserver #fundamentals #database

After reading the book "IBM and the Holocaust" I realized that the punch card was the invention of the database. In this video I discuss how data and databases not only will outlive applications, databases were around before computers or electronics of any kind.

If you're interested in reading the book, here's the link: https://www.amazon.com/IBM-Holocaust-Strategic-Alliance-Corporation/dp/0914153277/ref=sr_1_1?ie=UTF8&qid=1546457935&sr=8-1&keywords=ibm+and+the+holocaust

I want to start learning PostgreSQL, but I don't want to just install it. I want to work within a hybrid environment. Therefore, enter Azure. I can have a cloud-based, platform as a service offering of PostgreSQL and manipulate it from my client, Ubuntu Linux.

I've heard multiple people say that they won't use Extended Events because they can't capture the values of parameters in stored procedures and parameterized queries. However, that's not true. Extended Events capture the same values that Trace Events, aka Profiler, ever did, in the same manner. Let me show you how.

#sqlserver #dataplatform #extendedevents

Since you can completely set up SQL Server to run entirely on a Linux machine, you're going to need ways to access and manipulate the database there. Here I show how I have SQL Server 2019 running in a Docker container on version 18.10 of Ubuntu. Using that, I then show Azure Data Studio running a restore of the AdventureWorks database. All this is done natively within a Linux laptop.

https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker?view-sql-server-2017

https://docs.microsoft.com/en-us/sql/linux/tutorial-restore-backup-in-sql-server-container?view=sql-server-2017

#sqlserver #azuredatastudio #linux

Understanding that plans can age out of cache is easy enough. Older plans aren't used, so they get removed. However, a bunch of other things can cause plans to get removed from cache. Once a plan has been removed, it has to be compiled again, which can be expensive. If you're seeing plan cache thrashing, you're going to need a way to understand why plans are being removed from cache. Watch this video to learn how.

#sqlserver #dataplatform #extendedevents

Implicit conversions can sometimes lead to problems in query performance. Tracking down these conversions is easy if you have an execution plan. However, capturing execution plans for all queries is a pain. So, instead, I show you how to use Extended Events to capture this information.

#extendedevents #sqlserver #dataplatform

Redgate Software is hosting a great event on December 12, 2018, SQL in the City: Streamed. The focus of the event will be on compliant database DevOps. We've got the whole gang together, so you'll hear from Kendra Little, Steve Jones, Kathi Kellenberger and me on all sorts of topics. Follow this link to get registered: https://www.red-gate.com/hub/events/sqlinthecity/

#redgate #devops #sqlinthecity

It's been a little while since I last looked at Azure Data Studio. Several things have changed. Let's unbox and explore those changes.

The single best way to learn to control how to create a database is through the use of T-SQL. This video shows how to create a database using the defaults, how to manipulate those defaults on your server, and how to take direct control of creating a database through T-SQL code. All of this is fully documented by Microsoft here: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-database-sql-server-transact-sql

#fundamentals #sqlserver #database

In this very modern age of software development and systems management, it's time to start to toss some of the old concepts. One of them that has to go is this fundamental divide between the traditional DBA and the traditional developer. If that divide ever made sense in the past, that time has gone. It's fundamentally time for the DBA to accept the reality that they are actually developers. Let me explain why.

#devops #dataplatform #dba

With the addition of SQL Clone 3, SQL Provision is even better than it ever was. Watch this video to see the new version of SQL Clone in action.

I just wanted to take a moment to say thank you. I appreciate all I have and everyone who has helped me achieve it. It felt like the right time to say thanks. Be sure to stick around for the fire alarm right in the middle of the video.

#grateful #thankyou #pass

We are finally starting too see some action on the enforcement front of the GDPR. I outline the reports that we have from France and the UK as well as provide some additional information that is coming. The articles that I'm references are here:

French companies with GDPR warnings:
https://martechtoday.com/two-french-location-data-companies-receive-gdpr-consent-warnings-223467

ICO Warning to Canadian company:
https://www.complianceweek.com/blogs/global-glimpses/ico-issues-first-formal-gdpr-enforcement-action#.W75Kqy-ZOCQ

You should read the GDPR. Here's a link to it:
https://eugdpr.org/

The ICO says self-reporting of breaches is increasing:
https://www.dataiq.co.uk/news/self-reporting-ico-soars-gdpr-warnings-hit-home

The French are warning that block chain technology, in and of itself, could be leading to GDPR breaches:
https://www.out-law.com/en/articles/2018/october/french-businesses-blockchain-gdpr-warning/

#gdpr #compliance #privacyandprotection

Privacy and protection is changing more and more in the United States. Many of these laws are mirroring the requirements of the GDPR. You should be finding out how best to be compliant when these rules apply to you.

#gdpr #privacyandprotection #compliance

You can take direct control over the information on display in Azure Data Studio. The dashboards for databases, servers, and more, are available for you to manipulate using things as simple as a T-SQL query.

For more on the Azure Data Studio, be sure to check out my other videos on the topic:

https://www.youtube.com/watch?v=F8Pvl3PVFBM&t=36s
https://www.youtube.com/watch?v=EHjyNpTa5_A
https://youtu.be/J0P0HK8aTKk

#azure #azuredatastudio #sqlserver

If you're using Azure Data Studio to write T-SQL, you're going to want a way to measure the performance of that code. Microsoft has provided a plug-in called SQL Profiler that meets that need. This tool actually uses Extended Events under the covers to get the job done. Let me show you how it works.

#azure #sqlserver #azuredatastudio

You have 72 hours to report a data breach under the rules laid down by the GDPR. Do you have monitoring in place ready to support that?

#gdpr #privacyandprotection #monitoring

Getting Source Control set up in Azure Data Studio is shockingly simple. However, there is a little trick to it. I'll show you how to get it done and you will have your code in source control in no time.

#sqlserver #azuredatastudio #azure

Masking data for non-production environments is actually quite difficult. Take postal code values. They correspond to a particular city and region. How then do we mask the data in a way that maintains that functionality? Redgate SQL Data Masker provides has a number of ways to do this. I'll demonstrate one.

For more on SQL Data Masker: https://www.red-gate.com/products/dba/data-masker/
For more on Redgate Software: https://www.red-gate.com/

-~-~~-~~~-~~-~-
Please watch: "Extended Events Live Data Window "
https://www.youtube.com/watch?v=UDtXjewvqmM
-~-~~-~~~-~~-~-
#redgate #sqldatamasker #masking

SHOW MORE

Created 9 months, 3 weeks ago.

74 videos

CategoryScience & Technology

Primarily focused on the Microsoft Data Platform, Redgate Software, DevOps and lots of things related to IT.