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
873 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,447 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,076 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
880 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
530 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,019 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,431 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
764 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,022 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
Advice I Like: Praise
By Steve Jones
Don’t reserve your kindest praise for a person until their eulogy. Tell them while...
Forums
Change Tracking Data Retention Options
Comments posted to this topic are about the item Change Tracking Data Retention Options
Using the FP-Growth Algorithm to Mine Useful Patterns in Data
Comments posted to this topic are about the item Using the FP-Growth Algorithm to...
Is there a way to have dynamic table headers?
Hi everyone I have a SP which compares two tables and outputs mismatching entries:...
Question of the Day
Change Tracking Data Retention Options
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=4 xxx);What are the possible choices for xxx? See possible answers