Technical Article

Encryption Example

Here in this T-sql tip I'am trying to compare the word "Hijacker" with two cases(line 3 and 4). Now they are in same when you compare the case (letter to letter), now you change the case of word "Hijacker" in either of the lines and run this SQL statements it will return different results. This […]

You rated this post out of 5. Change rating

2002-01-05

667 reads

Technical Article

Granting Access Permissions...

Usually when we recreate or rename a table we need to give the appropriate access permissions to the SQL users...this is very common in database under development environment where frequently table structure changes and we have to recreate it....we can accomplish this with Enterprise Manager but what will you do if Enterprise Manager fails to […]

You rated this post out of 5. Change rating

2001-12-18

829 reads

Blogs

Using Flyway with Feature Flags

By

There is a nice article at Harness.io on their use of feature flags and...

Microsoft Build event announcements on Fabric

By

There were a number of Microsoft Fabric announcements at Microsoft Build yesterday that I wanted to...

6 Can’t-Miss Basic SQL Courses to Learn in 2024: Your Fast Track to Data Mastery

By

Ready to dive into the world of SQL? Whether you're dreaming of a lucrative...

Read the latest Blogs

Forums

Monitoring if something is deleted in DB

By Martass

Hello, I have long-term task, which came one year ago, and just now I...

LOGON Trigger Count

By Steve Jones - SSC Editor

Comments posted to this topic are about the item LOGON Trigger Count

Invisible Downtime

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Invisible Downtime

Visit the forum

Question of the Day

LOGON Trigger Count

I have the need in SQL Server 2022 to create a complex set of checks for logins. I want to use Longon triggers, but I'd like to separate out logic. How many Logon Triggers can I create?

See possible answers