User Posts: Sachin Diwakar
0
Backup of OLAP Database using Powershell
0

In this article I would like to explain another method to take the backup of OLAP databases via PowerShell. It will help out to take the backup of multiple ...

0
BigData Really…
0

Hi guys, I was thinking since a long time to write blogs on big data. So, it is my first blog on BIGDATA. As a DBA, I always think where will I be after 5 ...

0
PowerShell : Copy a table from one server to another
0

In general, a DBA like us gets requests to copy a table data from one SQL Server instance to another. In that case, a DBA first sees the amount of data present ...

0
Learn Powershell with Vimal Lohani
0

Vimal Lohani sharing his knowledge and experience of Powershell in an exclusive series "Introduction to Windows PowerShell" SN Topic Description ...

0
Script : Who deletes the databases?
0

Hello Readers, Before starting, let me give you some background about this problem. I used to support few servers which had more than 1000 small databases. ...

0
Introduction to Windows PowerShell (Part3)
0

Hi guys, I am sorry for late due to busy work schedule. But now i am here to fulfill my promise - Today we will discuss about PowerShell scripts & there ...

0
How to check SQL Server connection without SSMS?
0

There are times when you need to verify SQL Server Connectivity from a machine there is no SQL Server Management Studio or any tool available. Not to worry, ...

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

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.