Tomaž Kaštrun


SQLServerCentral Article

Manage Your Business Rules in T-SQL Query

Motivation At some point in the carrer, we have come across the problem of hard-coded values in SELECT or WHERE clauses.  And we all agree that these hardcoded values must be parametrised. This bad habit usually backfires when we need to troubleshoot a query. These hardcoded values are usually a business role baked in the […]

4 (1)

You rated this post out of 5. Change rating

2022-10-18 (first published: )

10,836 reads

SQLServerCentral Article

Playing popular game of Wordle using T-SQL

Popular and addictive game of Wordle is now written in Transact SQL script. With this script, you can now  play this game on Microsoft SQL Server, using your favourite editor - SSMS, ADS, VS Code, and enjoy playing the game during free time, or whilst waiting for the other SQL query to complete.

You rated this post out of 5. Change rating

2022-01-19

569 reads

SQLServerCentral Article

Playing popular game of Wordle using T-SQL

Popular and addictive game of Wordle is now written in Transact SQL script. With this script, you can now  play this game on Microsoft SQL Server, using your favourite editor - SSMS, ADS, VS Code, and enjoy playing the game during free time, or whilst waiting for the other SQL query to complete.

You rated this post out of 5. Change rating

2022-01-19

4,334 reads

SQLServerCentral Article

Creating Markdown Formatted Text for Results from T-SQL

Markdown documents are becoming increasingly more popular and relevant with the emergence of notebooks. Markdown is a markup language for creating formatted text. It is widely used in tools for collaboration, tools for creating documentation and notebooks. Formatting is easy to understand, readable, simple to adopt, and agnostic. I can use a markdown document on […]

You rated this post out of 5. Change rating

2021-11-29

9,466 reads

Blogs

Refreshed in Tuscany

By

I returned last Sat, 15 Jun, from 9 weeks of crazy travel. It wasn’t...

The Community is YOU, Not Any Organization

By

As I type this, we’re leaving behind spring, and all the amazing events that...

Polyglot Persistence

By

I’ve seen the term polyglot persistence floating around Redgate a bit recently in the...

Read the latest Blogs

Forums

Sub Queries Optimization

By ralahari

(SELECT Column1 FROM Table1) as --5 Table1_1 ON table3.Column1  = Table1_1.Column1 LEFT JOIN (SELECT...

UNION ALL Optimization

By ralahari

select Colum1 , Colum2  from  table 1 Union All select Colum1 , Colum2  from ...

Case Statement Optimization

By ralahari

CASE WHEN ( Table1.Column IN (@Parameter1) OR b.cat3 = 1 OR (Table1.Column='XXXX' AND SV.Column...

Visit the forum

Question of the Day

Dropping a Logon Trigger

I created this trigger for testing on SQL Server 2022:

CREATE TRIGGER checksteve
ON ALL SERVER 
FOR LOGON  
AS  
BEGIN  
IF ORIGINAL_LOGIN()= N'ARISTOTLE\Steve'
 PRINT 'Steve logged in'
END;  
GO
Now I want to drop it. What do I run?

See possible answers