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,756 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,756 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,183 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,651 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)
4,611 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,624 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,396 reads
Once upon a time in a version of SQL far far away we had system tables that were easy to...
2014-05-05
720 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,396 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)
2,051 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,724 reads
By James Serra
Originally published April 2022; substantially updated July 2026. This post is a complete replacement...
The idea behind Azure SQL Developer is for anyone to build, iterate, and test...
By Steve Jones
I’m sure many of you are using AI regularly, perhaps chatting, perhaps using some...
Comments posted to this topic are about the item Can You Really Downgrade from...
Comments posted to this topic are about the item What is CPU Usage?
Comments posted to this topic are about the item Limiting Checkpoints
If I use the -k parameter with a number after it, what does this change in SQL Server?
See possible answers