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
SQLStudies
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,601 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,396 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
720 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,724 reads
The default autogrowth settings do NOT come from the Model database.
I recently saw a question about How to inherit autogrowth settings. They commented that while the new database GUI seemed...
2014-04-28
1,158 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: Confusion
I started reading about collations after I had a recent run in with them. As I read I started to...
2014-04-23
542 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,050 reads
Blogs
Audit – Security Compliance Frameworks (Part 1)
By Vinay Thakur
This blog series on Audit/Compliance/Security, this is first blog where we would discuss about...
Restore SQL Server Database to an OrbStack Container
In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...
Day of Data Baton Rouge Slides and Code
By Steve Jones
Thanks to everyone for attending my talk today at Day of data Baton Rouge...
Forums
Can You Really Downgrade from Enterprise to Standard and Save Thousands? Here's What Happened
Comments posted to this topic are about the item Can You Really Downgrade from...
What is CPU Usage?
Comments posted to this topic are about the item What is CPU Usage?
Limiting Checkpoints
Comments posted to this topic are about the item Limiting Checkpoints
Question of the Day
Limiting Checkpoints
If I use the -k parameter with a number after it, what does this change in SQL Server?
See possible answers