Thom Andrews

"Database Administrator" for a small Insurance Broker in England.

I use the quotes as, being a small business, although my role is called Database Administrator, you often need to be a jack of all trades for small companies. As a result I have exposure to Network Administration, Web Development, and some server maintenance (mainly the Ubuntu servers at the office); so although I'm not trained I've had to assist enough times to know what I'm looking for or at (which greatly helps when a problem isn't SQL Server based).

SQL Server enthusiast, however, little to no experience on with any other RDBMS. Linux and Windows user, with VB.Net experience, and enjoy to dabble in PoSH and Bash. I can read C#, it is a .Net language after all, but I'm hopeless at writing it; for some reason it's always escaped my grasp. I can't even blame it on the compulsory semi-colons as (one day) they'll be compulsory in T-SQL too (bring it on SQL Server 2037!).

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

SSIS task that runs a PowerQuery

By pietlinden

is there a good tutorial on how to get SSIS to run a PowerQuery...

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 ...

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