SQLStudies

HAL0004 – I don’t feel well Dave

• by Kenneth Fisher

• SQLStudies

It’s another HAL! Every once in a while (4 times now) I come up with a terrible terrible idea for ... Continue reading

2020-06-29

42 reads

Azure SQL Database Query Editor

• by Kenneth Fisher

• SQLStudies

I was working on a couple of Azure databases the other day. One was an Azure SQL DB and the ... Continue reading

2020-06-24

157 reads

I created a table and SQL created a schema and a user.

• by Kenneth Fisher

• SQLStudies

Demo first and then I’ll explain what happened. First thing I did was run this script: CreateUsers.bat It’s a quick ... Continue reading

2020-07-08 (first published: 2020-06-22)

333 reads

Adding people’s names to a blog post can be rather tedious.

• by Kenneth Fisher

• SQLStudies

I blog a fair amount and do you want to know what the most annoying part of the process is? ... Continue reading

2020-06-18

2 reads

Non-SQL Tips and tricks – #tsql2sday 127 Rollup

• by Kenneth Fisher

• SQLStudies

I was thrilled to host TSQL Tuesday this month (#127) and I my prompt was non-SQL tips and tricks. Now ... Continue reading

2020-06-26 (first published: 2020-06-16)

472 reads

End an ALTER DATABASE immediately if anyone is in the database.

• by Kenneth Fisher

• SQLStudies

The development team has told me they’ve shut down the application, there are no more connections and I can go ... Continue reading

2020-06-30 (first published: 2020-06-11)

617 reads

The Azure Portal search bar : T-SQL Tuesday #127

• by Kenneth Fisher

• SQLStudies

Happy T-SQL Tuesday! Number 127. Wow. Over 10 and a half years. Talk about incredible. I’m actually hosting this time ... Continue reading

2020-06-09

56 reads

SQL Homework – June 2020 – DML Triggers

• by Kenneth Fisher

• SQLStudies

Triggers. Blech. Triggers are a really really cool feature of SQL Server, that are continuously misused and cause all kinds ... Continue reading

2020-06-18 (first published: 2020-06-04)

309 reads

TSQL Tuesday #127 Invite – Non SQL Tips and tricks

• by Kenneth Fisher

• SQLStudies

How about for this months TSQL Tuesday let’s do another month of tips and tricks. But just to be a ... Continue reading

2020-06-02

13 reads

What I learned from “The boy who cried wolf”

• by Kenneth Fisher

• SQLStudies

I was thinking about the story The boy who cried wolf earlier today and realized that it has some lessons ... Continue reading

2020-06-12 (first published: 2020-05-28)

458 reads