Category Archives: SQLServerPedia Syndication
-
Adding people’s names to a blog post can be rather tedious.
Leave a commentJune 18, 2020 by Kenneth Fisher
I blog a fair amount and do you want to know what the most annoying part of the process is? …
Continue reading -
Non-SQL Tips and tricks – #tsql2sday 127 Rollup
3June 16, 2020 by Kenneth Fisher
I was thrilled to host TSQL Tuesday this month (#127) and I my prompt was non-SQL tips and tricks. Now …
Continue reading -
End an ALTER DATABASE immediately if anyone is in the database.
5June 11, 2020 by Kenneth Fisher
The development team has told me they’ve shut down the application, there are no more connections and I can go …
Continue reading -
The Azure Portal search bar : T-SQL Tuesday #127
Leave a commentJune 9, 2020 by Kenneth Fisher
Happy T-SQL Tuesday! Number 127. Wow. Over 10 and a half years. Talk about incredible. I’m actually hosting this time …
Continue reading -
SQL Homework – June 2020 – DML Triggers
Leave a commentJune 4, 2020 by Kenneth Fisher
Triggers. Blech. Triggers are a really really cool feature of SQL Server, that are continuously misused and cause all kinds …
Continue reading -
TSQL Tuesday #127 Invite – Non SQL Tips and tricks
39June 2, 2020 by Kenneth Fisher
How about for this months TSQL Tuesday let’s do another month of tips and tricks. But just to be a …
Continue reading -
What I learned from “The boy who cried wolf”
2May 28, 2020 by Kenneth Fisher
I was thinking about the story The boy who cried wolf earlier today and realized that it has some lessons …
Continue reading -
Use session_context to create a “variable” that lasts between batches.
15May 26, 2020 by Kenneth Fisher
The other day I had a brief conversation with Itzik Ben-Gan (about|twitter) on twitter and I have to tell you …
Continue reading -
Connecting to Azure SQL Database: Requested tenant identifier ‘00000000-0000-0000-0000-000000000000’ is not valid.
5May 20, 2020 by Kenneth Fisher
The other day I got this rather interesting error while connecting to an Azure SQL DB. I was connecting using …
Continue reading -
Negative (-) is an operator and will affect the order of operations.
7May 18, 2020 by Kenneth Fisher
An interesting question came to my attention the other day. A strange operation problem in SQL Server: -100/-100*10 = 0 …
Continue reading
SQL Studies 