DBA Myths: You can’t use an alias in a DELETE statement
Recently I wrote about the myth that you can’t use an alias in an UPDATE statement. You can of course,...
2013-09-24
883 reads
SQLStudies
sp_DBPermissions V2.0
Last month I posted my stored procedures sp_SrvPermissions and sp_DBPermissions. I’m posting V2.0 of each with a few fixes. The...
2013-09-23 (first published: 2013-09-18)
2,461 reads
sp_SrvPermissions V2.0
Last month I posted my stored procedures sp_SrvPermissions and sp_DBPermissions. I’m posting V2.0 of each with a few fixes. The...
2013-09-23 (first published: 2013-09-18)
2,089 reads
Brad Shultz’s blog on reviewing your database
This is possibly the best blog I have every read on the subject of reviewing a database. It is witty,...
2013-09-17
709 reads
DBA Myths: You can’t use an alias in an UPDATE statement.
I’ve found a very common belief among users of T-SQL (both DBAs and Developers) is that you can’t use an...
2013-09-16
883 reads
Certifications: What are they good for?
Since Microsoft decided to drop the MCM/MCA program there has been an enormous amount of discussion about the program and...
2013-09-11
546 reads
How do the fixed Database and Server roles map to more specific permissions?
I recently asked what the difference is between granting SELECT to a user (at a database level) and adding the...
2013-09-09
1,034 reads
A T-SQL query to get current job activity
I recently had the task of collecting job activity for the purposes of turning it into a report for some...
2013-09-05
15,967 reads
When I run “Script as” it isn’t (or is) … How do I fix it?
When I run “Script (say table) as” it isn’t (or is) (say generating scripts for indexes). How do I fix...
2013-09-03
773 reads
The most important skill to practice when preparing for any certification exam!
I like practice tests. Once I feel like I’m getting ready to take a certification exam I start taking an...
2013-08-28
1,029 reads
Blogs
AI Experiments: Claude Solved a DAB Issue
By Steve Jones
I’m sure many of you are using AI regularly, perhaps chatting, perhaps using some...
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...
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