When creating tables, your ability to automate this process and to control it through T-SQL code is vital. Coding table creation is faster than through the GUI. Ensuring that you can automate table creation also makes it possible for you to be more efficient in general. This video walks through the basics of table creation using T-SQL.

For more information on the CREATE TABLE command, please refer to Microsoft documentation: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql

#sqlserver #fundamentals #createtable

Anyone who has used SQL Prompt from Redgate knows that it formats your T-SQL and gives you wonderfully feature complete type-ahead. However, SQL Prompt has a whole lot more functionality that you might not know about. This video explores that and shows all sorts of useful tips and tricks for how SQL Prompt can not only make your code look pretty, but make it cleaner and more functional overall.

#redgate #sqlprompt #tipsandtricks

The Ransomeware attack against Arizona Beverages illustrates several common problems in information technology management. It happens so often, some type of disaster occurs in an IT environment. People reach for the backup. The backups are not there, or they are there, but are corrupt, or they are there and no one knows how to restore them. Also, the fact that you have out of date operating systems that you're not patching. These two issues are so frequent, you would think we'd learn from them. Yet, here we are again.

For details on the hack, go here: https://techcrunch.com/2019/04/02/arizona-beverages-ransomware/

#backups #ransomware #fundamentals

I'm just beginning to explore how to use notebooks within Azure Data Studio. I'm sharing with you as I learn. This technology has a lot of potential.

Here is Gianluca Sartori's blog post which I mention in the video:
https://spaghettidba.com/2019/03/20/generating-a-jupyter-notebook-for-glenn-berrys-diagnostic-queries-with-powershell/

#azuredatastudio #notebooks #sqlserver

SQL Server has a system of dynamic management views (DMV) that let you see the suggested missing indexes. However, those are not tied in any way to a query. You can use the Query Store to get the missing index information and tie it to a query. This video shows how.

#querystore #sqlserver #performancetuning

Servers manage databases and databases are where you keep data. The place where data is stored is tables. We'll start exploring data storage by creating a table using the SQL Server Management Studio GUI. We also introduce the concepts of columns and data types as well as the beginnings of a discussion around null values.

This is an introductory, fundamentals course which I'm building over time. If this is useful, please hit the like and the subscribe, but most importantly, leave a comment.

#sqlserver #fundamentals #table

The March update for Azure Data Studio is out and it is huge. Lots of new material including PostgreSQL support, Notebooks and PowerShell support. Read more about it here:
https://cloudblogs.microsoft.com/sqlserver/2019/03/18/the-march-release-of-azure-data-studio-is-now-available/

Check out Gianluca's notebook implementation here:
https://spaghettidba.com/2019/03/20/generating-a-jupyter-notebook-for-glenn-berrys-diagnostic-queries-with-powershell/

#azuredatastudio #azure #postgresql

I don't see nearly enough people making noise about this. The California Consumer Privacy Act enforcement starts in January of 2020, which is just nine months away. You need to assess whether or not the CCPA applies to your organization and then evaluate if you can meet the requirements. I give a good overview of who the CCPA applies to, businesses that must meet it's requirements and some exceptions in this video.

#ccpa #gdpr #compliance

So often I get asked how to improve performance within SQL Server. I make a set of suggestions only to be told that no changes can be introduced. Well, without changes, you can't improve performance. In this video I review exactly what you need to do in order to improve performance within SQL Server. There are only two choices and you have to pick one.
#sqlserver #performancetuning #querytuning

There has been a bit of bad information shared on this very particular topic, including by me. I want to take a moment to get this clear so that we know exactly who is covered by the GDPR and, further, where they are covered. This is very important information to help you ensure compliance with the law.

#gdpr #compliance #privacy

Very frequently I hear people complaining that the database is running slow and therefore SQL Server is horrible. Yet, they don't have any referential integrity, primary keys, indexes or enforced foreign keys. Using tools incorrectly and then blaming the tool for the outcome is a horrible approach that will lead to pain. A Rant

A new report from the lawfirm DLA Piper has researched public records from the EU and has compiled a very useful report on how many breaches there have been, their causes, and the fines levied, if any. I review it in part in this video, but you should read the whole thing:
https://www.dlapiper.com/en/us/news/2019/02/dla-piper-gdpr-data-breach-survey/

#gdpr #privacyandprotection #cpp

I sometimes fall behind on Redgate tools and lose track of what the latest updates are. In this video I review all the changes made to SQL Provision and walk through the core functionality to reintroduce myself to the topic.

#sqlprovision #redgate #sqlclone

Microsoft continues the maintain an aggressive release cycle with Azure Data Studio. The new update released in February 2019 includes some small adjustments to the core product and a bunch of support for SQL Server 2019.

#azuredatastudio #azure #sqlserver

Azure Data Studio is a great tool. Part of what makes it great is the ease with which you can add functionality through extensions. This video demonstrates two ways to add extensions through the GUI and by downloading *.vsix files.

Here's a great blog post on how Buck Woody is setting up his Azure Data Studio.

For those interested in Azure Data Studio, I have several more videos available:
https://www.youtube.com/playlist?list=PLz1K0IeusjkKVPo7hbh_FiwU-O9vAoKyE

#azuredatastudio #sqlserver #extension

A rough and ready exploration of SQL Konferenz in Darmstadt Germany. I walk you around the vendor floor and community zone. We talk with several speakers, attendees and vendors. If you want an idea of what it's like at this great event, now you know. -- Watch live at https://www.twitch.tv/gfritchey

For more on SQL Konferenz: https://sqlkonferenz.de/default.aspx

PASS Deutschland: https://www.sqlpass.de/

Azure Groups: https://www.meetup.com/topics/azure/de/

#sqlkonferenz #redgate #pass

In this video I show more extensions, source control and additional functionality that is possible within Azure Data Studio. I also show a few things that don't quite work right. -- Watch my show live at https://www.twitch.tv/gfritchey

For more on how to set up Source Control in Azure Data Studio: https://www.youtube.com/watch?v=EHjyNpTa5_A

#azuredatastudio #azure #sqlserver

Friends don't let friends upgrade to SQL Server 2014.

In this video I explain why upgrading to SQL Server 2014 can be problematic. I then offer reasons why upgrading to SQL Server 2016/2017/2019 is preferable. I also outline how to do the upgrades to these more advanced versions of SQL Server. You don't have to upgrade to 2014 and there are a lot of reasons why you shouldn't.

#sqlserver #sqlserver2014 #querystore

Wells Fargo has been offline for two days at the point I type this, affecting ATMs, online banking, credit cards and direct deposit. Despite the fact that people can't get their money or make transfers, Wells Fargo is still levying fines (which they say they'll refund). All this because they have not done their disaster recovery testing. After watching my video, go read this blog post from Allan Hirt: https://sqlha.com/another-day-another-outage

#disasterrecovery #backups #wellsfargo

Unfortunately, some of this recording from a live stream on Twitch was truncated. However, what's there covers using Azure Data Studio to manage Docker, run PowerShell and manage a SQL Server instance running inside a Linux Container. I also show how to do a restore in Linux. -- Watch live at https://www.twitch.tv/gfritchey

#twitch #sqlserver #azuredatastudio

Depending on which security focused forum you reference, SQL Injection is in the top 20 data vulnerabilities, top 10, or #1. Regardless of how it falls, it is probably one of the easiest to fix and we've had solutions in place for 20 years. Here I discuss what I think may be the root cause of all the problems.

You can see the Quora question and answers here:
https://www.quora.com/Why-after-20-years-of-knowing-exactly-how-to-prevent-it-is-code-being-written-that-allows-SQL-injection-to-occur
#sqlinjection #protection #security

I've been experimenting more and more with containers and slowly moving towards adopting them as a very easy way to build a fast testing environment. The SQL Server containers on Docker work very well. You can even use Azure Data Studio to connect to them. However, don't make the fundamental mistake I made in the video.

Here's a good intro to setting up your first container:
https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker?view=sql-server-2017

#azuredatastudio #docker, #containers

A live stream from Twitch of a from scratch install of Docker to Windows followed by running a SQL Server instance in a container. This is the future of testing and development. Get started now. I'll show you how. -- Watch live at https://www.twitch.tv/gfritchey

I'll be presenting a regular session, a Redgate session, and most important of all, a full day of training at SQLBits 2019 in Manchester in the UK. In this video I talk about some of the details of what I'm going to present during that all day event. Follow this link for all the details:

https://sqlbits.com/information/event18/SQL_Server_Tools_for_Query_Performance_Tuning2/trainingdetails

#sqlbits #querytuning #performance

It's shocking when you hear about unsecured databases online. It's even more shocking when you hear about multiple instances of unsecured databases within a week. I find it hard to say this because it seems obvious, but you really should put a password on your databases, regardless of what kind of data storage you use. Here are some recent stories about bad use of passwords:

https://techcrunch.com/2019/01/23/financial-files/
https://www.itgovernance.co.uk/blog/70000-affected-in-bq-data-breach
https://www.zdnet.com/article/dailymotion-discloses-credential-stuffing-attack/

#gdpr #security #password