User Posts: Sachin Diwakar
0
Introduction to Windows PowerShell (Part2)
0

In this session, We will learn how you can control the result or output of command prompt & will also learn few more commands- If you are new to ...

0
Introduction to Windows PowerShell (Part1)
0

Windows PowerShell is a configuration management framework to perform administrative tasks.This tool is developed by Microsoft & available from 2006.This ...

0
SQL Server Setup Discovery Reports & Related Queries
0

Microsoft Sql Server has given so many options to check which version of SQL installed on server. With this Discovery Report we can check how many instances ...

0
Series : Versus
0

  Our Versus Series is a comparsion series of blogs. Here, we will try to compare one concept with another or one feature with another. SN ...

0
CAST vs. CONVERT
0

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 ...

0
Series : SQL DBA Cheatcode
0

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. ...

0
SQL DBA Cheatcode Part 6 : Know your SQL Server
0

Hello Readers, 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 ...

0
SQL DBA Cheatcode Part 5 : Playing with indexes
1

Hello Readers, 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 ...

0
Misleading Message:  DBCC execution completed. If DBCC printed error messages, contact your system administrator
0

Hello Reader, Recently, it was encountered that one of the jobs which was running fine since ages has started failing with below error message. Message : ...

0
Proactive Monitor of System Database Files
0

Dear Readers, Today I am writing about a very common problem of Outages that are caused by system database data/log files growth. Problem: generally, ...

0
Keeping your Server Secure Part 1 : Login Password Policy
0

Dear readers,   Now we are going to cover very important activity from a DBA perspective. Database\Server Security is the one of the most important ...

0
System Databases : Restrictions Matrix
0

Dear Readers, Today, I tried to consolidate a list of restrictions that are applied to system databases. Restrictions are nothing but the operations that ...

0
Configure SSIS to use Named Instances
0

SQL Server family has various services like Database Services (SQL Server), Analysis Services, Reporting Services which supports Named Instance of the services ...

0
Question : Who is a DBA?
0

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 ...

0
SQL Server Day to Day issues- Part2
1

Here comes another issue that is being faced by DBAs frequently. (Read part 1 here) Issue- SQL Server Instance fails to start A number of problems can ...

Browsing All Comments By: Sachin Diwakar
  1. 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!

  2. You can read PayPal FAQs if there is any doubt.

  3. Sachin Diwakar April 23, 2015 at 7:09 am

    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.

  4. Sachin Diwakar June 16, 2015 at 10:37 am

    Looks like copy paste issue. Script runs fine. I just tried it and even I can see that variables are there.

    Pls try again..

  5. Sachin Diwakar June 7, 2015 at 8:11 pm

    I agree with you Varun – thats how it should be.

  6. Hi Balram,

    Can you please post your career summary at our Forum?
    https://www.facebook.com/groups/sqlserverdbaindia

    Many SQL DBAs/HRs are connected using this forum, definetly you will get help.

    Regards
    Sachin

  7. Sachin Diwakar April 9, 2015 at 9:06 pm

    Point taken

  8. Sachin Diwakar March 25, 2015 at 5:08 pm

    Hi Devesh,

    I am not sure if I can answer your questions. While hiring – everyone thinks of hiring the best resource.

    Thanks.

  9. Sachin Diwakar March 11, 2015 at 9:03 am

    You may follow us on twitter and Facebook.
    https://twitter.com/DBAThings
    https://www.facebook.com/dbathings

  10. Sachin Diwakar March 9, 2015 at 10:18 am

    Thanks for your inputs.

  11. Hi Shivam,

    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.