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,990 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,621 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,392 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,975 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,710 reads
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
By DataOnWheels
I can’t believe it’s finally here! A way to have Excel live in OneDrive...
By Steve Jones
This image is from 2010, and it goes along with my last post of...
Comments posted to this topic are about the item Unlocking Data Transformation: My journey...
Comments posted to this topic are about the item Putting the Player with the...
Comments posted to this topic are about the item Your Security Checkup, which is...
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers