Tim

I speak and write about data and security

USA Joined on Apr 19, 2021 https://www.youtube.com/user/sqlinsix

Work

Consultant

Data tools within Azure cloud; social engineering in security

Data and security

24 posts published

0 comments written

5 tags followed

Tim

Apr 18

Quick Databricks' Cloning Tip

#data #databricks

1 min read

Tim

Apr 1

Quick Databricks Meta-Information Tip

#data #databricks

1 min read

Tim

Mar 24

Will AI End All of Us?

#ai #development

1 min read

Tim

Oct 28 '21

Connecting A Data Factory To An Existing Runtime In Azure

#azure #database #tutorial

2 min read

Tim

Oct 7 '21

T-SQL: How To UNION ALL Tables and Why

#sql #database #tutorial

2 min read

Tim

Oct 1 '21

Solving Data Differentials With LEFT JOINs

#sql #database #tutorial

3 min read

Tim

Sep 26 '21

Transaction Log Becoming Full Due To Replication

#tutorial #sql #database

2 min read

Tim

Aug 26 '21

T-SQL: How To Use DENSE_RANK()

#sql #tutorial #database

2 min read

Tim

Aug 21 '21

T-SQL: How To Use PARTITION BY and Why

#sql #database #tutorial

2 min read

Tim

Aug 13 '21

T-SQL: How To Use ROW NUMBER() and Why

#sql #tutorial #database

2 min read

Tim

Aug 6 '21

T-SQL: How To Write A CROSS JOIN and Why

#sql #tutorial #database

2 min read

Tim

Jul 30 '21

T-SQL: How To Write A FULL OUTER JOIN

#sql #tutorial #database

2 min read

Tim

Jul 23 '21

Hive SQL: How To Write A LEFT SEMI JOIN

#sql #tutorial #database

2 min read

Tim

Jul 16 '21

T-SQL: How To Write A Cross Apply and Why

#sql #tutorial #database

2 min read

Tim

Jul 9 '21

T-SQL: How To Write A Self Join and Why

#sql #tutorial #database

2 min read

Tim

Jul 2 '21

Hive SQL (and T-SQL): How To Write A Left Anti Join and Why

#sql #tutorial #database

3 min read

Tim

Jun 17 '21

T-SQL: How To Write A Left Join and Why

#sql #tutorial #database

2 min read

Tim

Jun 10 '21

T-SQL: How To Write An Inner Join and Why

#database #sql #tutorial

2 min read

Tim

Jun 3 '21

Data Factory Error - "Found More Columns Than Expected"

#azure #cloudskills #data

2 min read

Tim

May 27 '21

Comparing Files In PowerShell - 2 Approaches

#powershell #tutorial #troubleshooting

3 min read

Tim

May 13 '21

Defaults and Using SELECT * INTO When Copying or Testing Functionality

#database #testing #sql

2 min read

Tim

May 6 '21

SQL Server: The Identifier Is Too Long; Max Length Is 128

#sql #tsql #azure

2 min read

Tim

Apr 22 '21

How To Find Unused Stored Procedures In SQL Server

#sql #programming #codequality

3 min read

Tim

Apr 19 '21

What Are Sim-Swap Attacks?

#security #cybersecurity #mobile #linkability

1 min read

DEV Community

Tim

Badges

Three Year Club

Writing Debut

Two Year Club

One Year Club

16 Week Writing Streak

8 Week Writing Streak

4 Week Writing Streak

Skills/Languages

Available for

Quick Databricks' Cloning Tip

Quick Databricks Meta-Information Tip

Will AI End All of Us?

Connecting A Data Factory To An Existing Runtime In Azure

T-SQL: How To UNION ALL Tables and Why

Solving Data Differentials With LEFT JOINs

Transaction Log Becoming Full Due To Replication

T-SQL: How To Use DENSE_RANK()

T-SQL: How To Use PARTITION BY and Why

T-SQL: How To Use ROW NUMBER() and Why

T-SQL: How To Write A CROSS JOIN and Why

T-SQL: How To Write A FULL OUTER JOIN

Hive SQL: How To Write A LEFT SEMI JOIN

T-SQL: How To Write A Cross Apply and Why

T-SQL: How To Write A Self Join and Why

Hive SQL (and T-SQL): How To Write A Left Anti Join and Why

T-SQL: How To Write A Left Join and Why

T-SQL: How To Write An Inner Join and Why

Data Factory Error - "Found More Columns Than Expected"

Comparing Files In PowerShell - 2 Approaches

Defaults and Using SELECT * INTO When Copying or Testing Functionality

SQL Server: The Identifier Is Too Long; Max Length Is 128

How To Find Unused Stored Procedures In SQL Server

What Are Sim-Swap Attacks?