Grant Fritchey

gfritchey

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

Since adaptive joins can control their behavior, using either a hash or a nested loops, what happens when you start putting join hints into the mix. Let's explore that and see how the adaptive join, the execution plan, and the query performance is affected.

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

I'm starting a series of video posts using the new Azure Data Studio tool. The first video is just a simple query against a SQL Server database to show off what this tool is capable of.

I'm very pleased to announce that my book on SQL Server Performance Tuning has been completed. It's now 900 pages long and filled with material. Go here to order your copy:
https://www.amazon.com/Server-2017-Query-Performance-Tuning-ebook/dp/B07H49LN75/ref=sr_1_8?ie=UTF8&qid=1536766092&sr=8-8&keywords=fritchey

For a completely different book on a related topic, I can also offer you a 100% free copy of SQL Server Execution Plans: https://www.red-gate.com/products/dba/sql-monitor/entrypage/execution-plans

Learn how to use the Live Data window with Extended Events to do more with the information you capture using Extended Events in SQL Server and Azure SQL Database. There's more functionality there than is immediately apparent.

When you need to make our fantastic tools do just a little more, why not go to university to learn how. Redgate University: https://www.red-gate.com/hub/university/

The first thing you need to understand about databases is that they are just files. I explain the types of files and information about how best to manage them.

Understanding the different join types and where they apply is an important part of reading and understanding execution plans in SQL Server. I introduce the four joins; nested loops, hash, merge and adaptive.

For more on adaptive joins, here's another video I made: https://youtu.be/Oxj3HilCnko

Redgate is hosting a live, in-person event in New York City, London and Chicago in October. Watch this video to learn what it's all about. Follow this link to get learn more and get registered: https://www.red-gate.com/hub/events/redgate-events/sqlinthecity-summit/

I've just started reading the details of the new California Consumer Privacy Act and I'll share them with you as I find them.

With the new laws out of California and New York, The California Consumer Privacy Act (CCPA) and Stop Hacks and Improve Electronic Data Security (SHIELD), the types of privacy and protection defined under the General Data Protection Regulation (GDPR) over in the EU is now directly applicable here in the US. Redgate Software wants to help you with your data classification. Go here to take part in our EAP of a new product: https://www.red-gate.com/products/dba/sql-data-catalog/eap

The importance of ensuring that you know which service pack or cumulative update you have installed can't be over emphasized. I discuss why this important and how Redgate is trying to help.

Go here to learn more: https://monitor.red-gate.com/estate/versions

I teach an all-day course on SQL Server Query Tuning Tools. This video explains some of the topics that you'll learn in the course and why you should attend.

You can find my full schedule of courses, their location and dates, here: https://www.scarydba.com/upcoming-speaking-engagements/

I was asked what I think a DBA has to do to survive in the current environment, so here are a few suggestions.

SHOW MORE

Created 7 months, 2 weeks ago.

60 videos

CategoryScience & Technology

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