Import Databases to Azure SQL Database
I recently spoke at a conference and was asked what is the easiest way to import databases to Azure SQL Database. Therefore, I wanted to share how I do...
2020-03-12 (first published: 2020-03-04)
610 reads
John Sterrett
Import Databases to Azure SQL Database
I recently spoke at a conference and was asked what is the easiest way to import databases to Azure SQL Database. Therefore, I wanted to share how I do...
2020-03-04
Allow users to start/stop Azure VMs
Today I wanted to cover how you can grant the least privilege required to stop, start or restart an Azure VM. This is also a fun great example of...
2020-02-10 (first published: 2020-02-04)
2,634 reads
Allow users to start/stop Azure VMs
Today I wanted to cover how you can grant the least privilege required to stop, start or restart an Azure VM. This is also a fun great example of...
2020-02-04
Previous SQL Server Updates
Hello everyone, this is John your Austin SQL Server Consultant here and today I am going to answer a question that comes up often so I wanted to blog...
2020-01-20 (first published: 2020-01-09)
447 reads
Previous SQL Server Updates
Hello everyone, this is John your Austin SQL Server Consultant here and today I am going to answer a question that comes up often so I wanted to blog...
2020-01-09
Free SQL Server Training Videos
Hello everyone! This is your SQL Server Consultant in Austin, TX and due to some posts on twitter about SQL PASS recordings costing $999 I wanted to share some...
2019-12-27
68 reads
Free SQL Server Training Videos
Hello everyone! This is your SQL Server Consultant in Austin, TX and due to some posts on twitter about SQL PASS recordings costing $999 I wanted to share some...
2019-12-27
5 Game Changers with SQL Server 2019
Microsoft made SQL Server 2019 Generally Available this week we want to share some videos and code examples of our favorite new features. Most of these will make your...
2019-11-05
105 reads
5 Game Changers with SQL Server 2019
Microsoft made SQL Server 2019 Generally Available this week we want to share some videos and code examples of our favorite new features. Most of these will make your...
2019-11-05
Blogs
Fail activity in Azure Data Factory and Why would I want to Fail
By Rayis Imayev
(2021-Nov-30) I heard a story about a young person who was asked why she was...
Hiding Email with a Dynamic Data Masking Function–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Get SQL Server 2022 Now: It’s Called Azure
If you’re like me, your palms went into a cold sweat to get your...
Forums
Arithmetic overflow error converting expression to data type datetime when selec
I have such an issue. I want to select a column PDWEDT (it is...
inner join give me huge data when package id equal package id from another table
I work on sql server 2014 i face issue when join two tables as...
Upgrade in place error (2017 to 2019) - invalid name space.
Upgrade stops with an invalid namespace error (that was it, no error codes of...
Ask SSC