TSQL Tuesday 127 - Non SQL Tips and Tricks - Windows
This month’s (#127) T-SQL Tuesday is brought by Kenneth Fisher (B | T) and he asked about Non SQL Tips and tricks. As a Windows user I know there...
2020-06-09
7 reads
Blog Posts
AWS RDS and SQL Server Deadlocks
What’s the story with AWS RDS and SQL Server deadlocks? I’m approaching AWS RDS like I was taking on a new role at a new organization. Do we have...
2020-06-08
75 reads
Daily Coping 8 June 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-06-08
12 reads
Data On Wheels – Merging Two Great Minds
I am very excited to announce that my daughter, Kristyna Hughes, will be joining the Data On Wheels team. Our fates and paths to this point seem parallel though...
2020-06-08
129 reads
Ghost is taking full backup and breaking my backup chain . Be careful with Azure VM backup on VM having SQL server installation
I believe that I have strong knowledge in SQL Server backup and recovery process, but recently there was an incident which shook my confidence. I was working on a...
2020-06-08 (first published: 2020-05-25)
1,798 reads
OPENJSON and an Alias
Using Aliases in T-SQL is very common. We can alias both Tables (FROM clause) and Columns (SELECT clause) and some other things too. It’s all pretty fundamental to writing...
2020-06-08
285 reads
OPENJSON and an Alias
Using Aliases in T-SQL is very common. We can alias both Tables (FROM clause) and Columns (SELECT clause) and some other things too. It’s all pretty fundamental to writing...
2020-06-08
13 reads
Reading an dataset in R
I got a dataset file the other day with an .rds extension. I had never seen this, but with a quick Google, I figured out this was a dataset...
2020-06-08
92 reads
Send a Database Query Result as Email via Logic App in HTML format using Azure Data Factory
(2020-June-07) It is a very simple concept, you have a database query result, either a direct database table output or a stored procedure returned result that needs ...
2020-06-08
2,576 reads
Social: A Small Step to Address Poor Past Behavior
Tl;Dr – This is about changing your main branch in git to main. However, please read and think about what I am saying here. When I started working with...
2020-06-08
40 reads
Blogs
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers