FLX SQL

dbatools Badge Ribbons at PASS Summit

• by alevyinroc

• FLX SQL

One of the (many) fun things to do at PASS Summit is to check out the ribbons people have attached to their badges. Some are witty or goofy, others...

2017-10-05

T-SQL Tuesday #92: Lessons Learned the Hard Way

• by alevyinroc

• FLX SQL

This month’s T-SQL Tuesday is hosted by Raul Gonzalez and he’s asked everyone to share things we might be a bit embarrassed about:
For this month, I want you...

2017-07-11

Don't Forget the Network

• by alevyinroc

• FLX SQL

A few weeks ago I was looking at a query and got tripped up by the network and my own forgetfulness. It was a pretty simple query with a...

2017-06-12

I Finally Get Cross Apply!

• by alevyinroc

• FLX SQL

For years I’ve looked at various queries online in sample code, diagnostic queries using DMVs, and the like and seen CROSS APPLY in the FROM clauses. But I’ve never...

2017-05-22

Adding Application Name to Invoke-SqlCmd2

• by alevyinroc

• FLX SQL

In a previous post, I expressed some frustration over Invoke-SqlCmd not setting an Application Name for its ODBC connection, leaving us with the generic .NET SqlClient Library when looking at active sessions...

2017-01-20

2 reads

Make Your Application's Name Heard

• by alevyinroc

• FLX SQL

Odds are, you’ve got more than one application or script accessing your database or SQL Server instance at any given time. You’re probably stacking them on a small number...

2017-01-02

Name Your Defaults So SQL Server Doesn't

• by alevyinroc

• FLX SQL

Something in SQL Server that isn’t always obvious to beginners is that when you create a default value for a column on a table, SQL Server creates a constraint...

2016-01-19

Don't Trust the Wizard

• by alevyinroc

• FLX SQL

If you need to move data from one table into a new table, or even tables in a database into another database, the Import/Export Wizard in SQL Server Management...

2015-11-11

Padding Fields for Fixed-Position Data Formats

• by alevyinroc

• FLX SQL

Fixed-position data formats will seemingly be with us forever. Despite the relative ease of parsing CSV (or other delimited formats), or even XML, many data exchanges require a fixed-position...

2015-04-22

Connecting SQLite to SQL Server with PowerShell

• by alevyinroc

• FLX SQL

This post is part of Ed Leighton-Dick’s SQL New Blogger Challenge. Please follow and support these new (or reborn) bloggers.
I’m working with a number of SQLite databases as extra data...

2015-04-07