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
Kenneth Fisher
Microsoft’s free virtual labs
If you have spent any time looking around my site, you will notice that I love study materials and in...
2014-05-26
1,181 reads
DBA Myths: A table with a primary key is not a heap
Typically when you see a heading like this you know the answer is “No” or “False” but in this case...
2014-05-21
2,643 reads
Granting or denying permissions to all of the tables within a database
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,323 reads
T-SQL Tuesday #54: Interviews!
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
Does SQL Server do a CHECKDB during an instance restart?
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,394 reads
Why is there a sysobjects when we already have sys.objects?
Once upon a time in a version of SQL far far away we had system tables that were easy to...
2014-05-05
719 reads
Collation: Confusion
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
Collation: Temporary objects and variables: Demonstration
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,018 reads
DBA Myths: TRUNCATE TABLE deletes all the rows of a table instantly.
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,714 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Ciluar Tlpn/wa:085373737551
Jl. Raya KS Tubun No.285, RT.03/RW.01, Ciparigi, Kec. Bogor Utara, Kota Bogor, DKI Jakarta...
BCA KCP Ambasador,Telp/Wa 0821.3111.159
Mal & Apartemen Ambasador, Jl. Prof. DR. Satrio No.R.18 Lantai Dasar, Kuningan, Karet Kuningan,...
BCA KCP Pejaten,Telp/Wa 0821.3111.159
Ruko, Jl. Pejaten Mas Raya Jl. Raya Pasar Minggu No.Km.20 No. 98F & 98G,...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers