Save yourself from despair with full database documentation

Your ability to document thoroughly will determine your efficiency and productivity when it comes to managing your SQL Server databases. Aside from the question of productivity, there’s always the concern of having to come…

DBA Roadmap Seminar review

Our usual step when seeking for advice is to search the internet for relevant topics. There is no shortage of…

Who are the sysadmins in this sql server?

Sysadmins are pretty much powerful in the SQL Server environment. They can put the whole SQL Server infrastructure under their control. That said, it is important to know who else has this fixed server role.

Your SQL Server database just failed, can you restore the backup?

It’s one thing to be able to backup a database, it’s another thing to be able to restore it into an operational database in case of failure. We can run a simple TSQL to check the validity of a backup file. We can do…

Review of “Start Here! Learn Microsoft Visual C# 2010”

Disclaimer: I wrote this review as a participant to O’Reilly Blogger Review Program.

If you’ve never seen a programming code in your life and want to build a simple program without really trying to learn how…

Limiting user access to your database

There are situations where you need to grant SELECT permission to a particular user and limit that access to a particular OBJECT, say a TABLE.

Here’s a quick way of accomplishing this. In this example we’re using the AdventureWorks2008R2…

The evolving role of the database professional

The role of the database professional is quickly evolving to conform with the ever changing demands of the business world. The new game of the data pro is adaptation.

10 must follow blogs that might not be in your list

There are few memes going around in the SQL world. Probably the most popular of them is TSQL Tuesday (#tsql2sday). Of course, there’s Meme Monday (#mememonday) and also Un-SQL Friday. Another meme that has been gaining traction is #Meme15…