Blog Posts

Implicit Conversion Fail

• by Jason Brimhall

• SQL RNNR

Implicit conversions are not uncommon in the computing world and can be viewed as kind of a fail-safe for when we don't quite follow decent practices when designing the...

2019-06-18 (first published: 2019-05-31)

292 reads

Scalar Valued Functions in SQL Server 2019

• by Klaus Aschenbrenner

• Klaus Aschenbrenner

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...

2019-06-18

20 reads

Trailing Spaces in SQL Server

• by Bert Wagner

• Bert Wagner

Watch this week’s episode on YouTube. A long time ago I built an application that captured user input. One feature of the application was to compare the user’s input...

2019-06-18

13 reads

Trello For The User Group

• by Andy Warren

• SQLAndy

I’m trying Trello this year to manage both SQLSaturday and our other events. Part of that is giving the whole team visibility of the work that remains to be...

2019-06-18

9 reads

What You Need to Know About Data Classifications in Azure SQL Data Warehouse

• by Meagan Longoria

• Data Savvy

Data classifications in Azure SQL DW entered public preview in March 2019. They allow you to label columns in your data warehouse with their information type and sensitivity level....

2019-06-18 (first published: 2019-05-30)

201 reads

Container: More on Volumes

• by Grant Fritchey

• The Scary DBA

In my last post I showed how you can create a volume with your container. I then showed a few things you can with a container using a volume....

2019-06-17 (first published: 2019-05-28)

170 reads

Demo: Predictive Modeling using R and SQL Server Machine Learning Services

• by Arjun-Sivadasan

• SQL Roadie

Late last year, I wrote a series of articles about Predictive Modeling using R and SQL Server Machine Learning Services. At the time, I thought MLS was an underutilized...

2019-06-17 (first published: 2019-05-28)

402 reads

It’s interesting how an OR short circuits.

• by Kenneth Fisher

• SQLStudies

I recently did a post on the case expression short circuting and received a very very interesting comment from Chad ... Continue reading

2019-06-17

18 reads

Public Role Permissions – Back to Basics

• by Jason Brimhall

• SQL RNNR

If you are being serious in your role, then the amount of times you grant permissions to the public role should either be a) never, b) when you want...

2019-06-17

10 reads

SQL Server Containers Are Boring

• by Grant Fritchey

• The Scary DBA

Not really, but sort of. The beauty of containers, at least in a dev/test environment, is the ability to spin them up while you need them and then throw...

2019-06-17

25 reads