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
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.
#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.
#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
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
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:
ICO Warning to Canadian company:
You should read the GDPR. Here's a link to it:
The ICO says self-reporting of breaches is increasing:
The French are warning that block chain technology, in and of itself, could be leading to GDPR breaches:
#gdpr #compliance #privacyandprotection
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:
#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
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 "
#redgate #sqldatamasker #masking
Created 9 months, 3 weeks ago.
|Category||Science & Technology|
Primarily focused on the Microsoft Data Platform, Redgate Software, DevOps and lots of things related to IT.