Escaping from a runaway Logon trigger
Most people know that logon triggers can be dangerous if you aren’t careful. And if you didn’t know, well, logon...
2014-05-27 (first published: 2014-05-19)
1,753 reads
Most people know that logon triggers can be dangerous if you aren’t careful. And if you didn’t know, well, logon...
2014-05-27 (first published: 2014-05-19)
1,753 reads
If you have spent any time looking around my site, you will notice that I love study materials and in...
2014-05-26
1,179 reads
Typically when you see a heading like this you know the answer is “No” or “False” but in this case...
2014-05-21
2,638 reads
When granting or denying permissions to the tables within a database you have two options. You can either add the...
2014-05-20 (first published: 2014-05-15)
3,995 reads
It’s T-SQL Tuesday again and this month our host is Boris Hristov (b/t). He has asked us to discuss Interviewing....
2014-05-16 (first published: 2014-05-13)
1,622 reads
When you start up an instance do you rely on the CHECKDB entry in the error log of SQL Server...
2014-05-13 (first published: 2014-05-07)
2,391 reads
Once upon a time in a version of SQL far far away we had system tables that were easy to...
2014-05-05
717 reads
I started reading about collations after I had a recent run in with them. As I read I started to...
2014-05-02 (first published: 2014-04-23)
2,393 reads
I had a recent run in with collation problems and it got me started reading about them. As I read...
2014-04-30 (first published: 2014-04-21)
1,976 reads
Most DBAs and developers I’ve talked to over the years have felt that TRUNCATE TABLE is an instant DELETE. However...
2014-04-30
2,711 reads
By DataOnWheels
It has been a while since my last T-SQL Tuesday blog. When I saw...
The last T-SQL Tuesday of the year is hosted by my good friend Mike...
By Steve Jones
This month Mike Walsh hosts T-SQL Tuesday. It’s been quite some time since he...
Hi So I have the below select query that won't return results if I...
Seeing this message repeated every 10 seconds in the RSHostingService_yyyy_mm_dd_hh_mm_ss.log file. Can anyone advise:...
I have a view where I am casting a datetimeoffset(7) field to smalldatetime or...
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers