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
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 "
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:
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
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/
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 make several recommendations for how to get started in SQL Server with the installation.
SQL Server Developers Edition: https://www.microsoft.com/en-us/sql-server/sql-server-downloads
Installing SQL Server: https://docs.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-from-the-installation-wizard-setup?view=sql-server-2017
SQL Server Management Studio 17: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
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/
Created 7 months, 2 weeks ago.
|Category||Science & Technology|
Primarily focused on the Microsoft Data Platform, Redgate Software, DevOps and lots of things related to IT.