Before starting, let me give you some background about this problem. I used to support few servers which had more than 1000 small databases. Worst part was that ...
Our Versus Series is a comparsion series of blogs. Here, we will try to compare one concept with another or one feature with another.
Datatype conversion is a common scenario that we face while writing SQL queries.
Cast and Convert are two functions provided by SQL for this purpose. But what is the difference ...
SQL DBA Cheatcode is a series or you can say a collection of those SQL Server scripts which we find very useful while troubleshooting issues day to day. These scripts are ...
I am here adding few more feathers to our SQL DBA Cheatcode series hat. If you have not read our others blogs of this series, you may do it by clicking the links ...
Today, I am trying to put down few but very useful index related scripts. I have used these scripts many times with different versions of SQL Server.
Recently, it was encountered that one of the jobs which was running fine since ages has started failing with below error message.
Executed as user: ...
Today, I tried to consolidate a list of restrictions that are applied to system databases. Restrictions are nothing but the operations that you "can not" perform ...
This post is targeted for those who are keen or new to DBA profession. Based on my experience I tried to write about DBAs and Possible career paths related to it.
Who is a ...
An attempt has been made to write a short script to find out SQL Server Orphan Logins. By the way, I am not sure if Microsoft has any term like "Orphan Login" ...
Few days ago, I was looking for a script to find out who all have access to SQL Server via AD Groups. There are a couple of good scripts available for this ...
Lets talk about Traces and System procedures that are very useful for a DBA Routine.
Interview Questions on Trace Flags
What are trace flags?
Trace flags are used ...
In this blog, I am taking a different approach. It’s very common that interviewer promptly asks another question from your answers only. Performance ...
Today, I thought of writing interview questions on SQL Server Performance Tuning. I tried my best to touch upon many areas however Performance Tuning is ...
March towards SQL Server. This is a series of interview questions & answers on a new topic every day for SQL DBAs. Special thanks to Parvinder Pal for his enormous efforts ...
Database fundamental book is what we read in Graduation but we never cared and never understood the importance of this book. Lets read it again now!
You can read PayPal FAQs if there is any doubt.
I think its always a good idea to create a report. This kind of report must be delivered to DBA’s Distribution list for weekly/monthly review.
Looks like copy paste issue. Script runs fine. I just tried it and even I can see that variables are there.
Pls try again..
I agree with you Varun – thats how it should be.
Can you please post your career summary at our Forum?
Many SQL DBAs/HRs are connected using this forum, definetly you will get help.
I am not sure if I can answer your questions. While hiring – everyone thinks of hiring the best resource.
You may follow us on twitter and Facebook.
Thanks for your inputs.
Can you please let me know what exactly you are looking for other than below?
mdf, ndf, ldf are the file extensions used for data and log files of a database. SQL Server holds exclusive lock on these files.
We will try to create a write up on this topic.
We thank you to all those who posted videos on youtube. Like you are doing, we also want to help SQL server community.