SQLStudies

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

sp_DBPermissions V2.0

by Kenneth Fisher

SQLStudies

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

by Kenneth Fisher

SQLStudies

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

by Kenneth Fisher

SQLStudies

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.

by Kenneth Fisher

SQLStudies

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?

by Kenneth Fisher

SQLStudies

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?

by Kenneth Fisher

SQLStudies

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

by Kenneth Fisher

SQLStudies

I recently had the task of collecting job activity for the purposes of turning it into a report for some...

2013-09-05

15,966 reads

When I run “Script as” it isn’t (or is) … How do I fix it?

by Kenneth Fisher

SQLStudies

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!

by Kenneth Fisher

SQLStudies

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

SQLStudies

DBA Myths: You can’t use an alias in a DELETE statement

sp_DBPermissions V2.0

sp_SrvPermissions V2.0

Brad Shultz’s blog on reviewing your database

DBA Myths: You can’t use an alias in an UPDATE statement.

Certifications: What are they good for?

How do the fixed Database and Server roles map to more specific permissions?

A T-SQL query to get current job activity

When I run “Script as” it isn’t (or is) … How do I fix it?

The most important skill to practice when preparing for any certification exam!

Blogs

Audit – Security Compliance Frameworks (Part 1)

Restore SQL Server Database to an OrbStack Container

Day of Data Baton Rouge Slides and Code

Forums

ALAMAT BCA KCU SUDIRMAN Telp 08218200174

ALAMAT BCA KCU KUNINGAN Telp 08218200174

ALAMAT BCA KCU PURI INDAH Telp 08218200174

Question of the Day

SQL Server Certificates