What goes around comes around : T-SQL Tuesday #129
I almost died. I’m sure a lot of you already know this but just to be clear, I should have. ... Continue reading
2020-08-11
25 reads
Kenneth Fisher
I created a table and SQL created a schema and a user.
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)
401 reads
End an ALTER DATABASE immediately if anyone is in the database.
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)
679 reads
HAL0004 – I don’t feel well Dave
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
50 reads
Non-SQL Tips and tricks – #tsql2sday 127 Rollup
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)
497 reads
Azure SQL Database Query Editor
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
168 reads
Adding people’s names to a blog post can be rather tedious.
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
22 reads
SQL Homework – June 2020 – DML Triggers
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)
339 reads
What I learned from “The boy who cried wolf”
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)
482 reads
The Azure Portal search bar : T-SQL Tuesday #127
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
68 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers