FLX SQL

Three Ways to Create a Temp Table

• by alevyinroc

• FLX SQL

Taking it back to SQL 101 today because I recently saw something that floored me. I’m a big fan of temp tables. I use ’em all over the place...

2020-06-23

54 reads

Three Ways to Create a Temp Table

• by alevyinroc

• FLX SQL

Taking it back to SQL 101 today because I recently saw something that floored me. I’m a big fan of temp tables. I use ’em all over the place...

2020-07-06 (first published: 2020-06-23)

555 reads

Checking for SQL Server Updates with dbatools

• by alevyinroc

• FLX SQL

It turns out I was doing this all wrong for months. For the longest time, I’ve been checking my SQL Server instances to see what needs patching with Test-DbaBuild...

2020-04-28

1 reads

User Defined Types and Temp Tables Gotcha

• by alevyinroc

• FLX SQL

This tripped me up a few weeks ago, but once I stopped and thought about for a moment it made total sense. I was trying to copy some data...

2020-04-02

Modernizing Your T-SQL: Trimming Strings

• by alevyinroc

• FLX SQL

This is one of several posts on modernizing T-SQL code with new features and functionality available in SQL Server. Last year, you finally retired the last of your SQL...

2020-03-17

T-SQL Tuesday #124 – I’m a Query Store Newbie

• by alevyinroc

• FLX SQL

T-SQL Tuesday is a monthly blog party hosted by a different community blogger each month, and this month Tracy Boggiano (blog | twitter) asks us to talk about Query...

2020-03-11

1 reads

Modernizing Your T-SQL: The Sequence Object

• by alevyinroc

• FLX SQL

This is one of several posts on modernizing T-SQL code with new features and functionality available in SQL Server. Last year, you finally retired the last of your SQL...

2020-03-10

2 reads

Modernizing Your T-SQL: String Aggregation

• by alevyinroc

• FLX SQL

This is another in a group of several posts on modernizing T-SQL code with new features and functionality available in SQL Server. SQL Server 2016 gave us the STRING_SPLIT()...

2020-02-18

1 reads

Modernizing Your T-SQL: Splitting Strings

• by alevyinroc

• FLX SQL

This is the first of several posts on modernizing T-SQL code with new features and functionality available in SQL Server. Last year, you finally retired the last of your...

2020-02-03

T-SQL Tuesday #118 – Your Fantasy SQL Feature

• by alevyinroc

• FLX SQL

It’s early September, which means it’s time for T-SQL Tuesday! This month’s topic comes from Kevin Chant (blog | twitter). Our mission, should we choose to accept it (click...

2019-09-10