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,441 reads
Kenneth Fisher
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,075 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
701 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
876 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
527 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,012 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
14,665 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
759 reads
The effect of VLF size on shrinking the log.
I was wondering the other day how VLF (Virtual Log File) sizes effected shrinking the log file so I decided...
2013-08-29 (first published: 2013-08-26)
2,623 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,019 reads
Blogs
Master Advanced SQL: 2 Essential Courses for Every Data Analyst
If you're a data analyst, you already know that SQL isn't just a nice-to-have...
Friday Flyway Tips–State-based Deployments
By Steve Jones
Recently the Flyway Desktop (FWD) team release support for state-based deployments. These are similar...
A New Word: Insoucism
By Steve Jones
insoucism – n. the inability to decide how much sympathy your situation really deserves,...
Forums
The Costs and Rewards of Speaking
Comments posted to this topic are about the item The Costs and Rewards of...
Manage Elastic jobs in Azure using Azure Elastic Jobs Manager
Comments posted to this topic are about the item Manage Elastic jobs in Azure...
Takeaways from Data Grillen 2024
Comments posted to this topic are about the item Takeaways from Data Grillen 2024
Question of the Day
Inserting Transaction Marks
When is a transaction mark first inserted into the msdb.dbo.logmarkhistory table?
See possible answers