Sachin Diwakar | DBA THINGS - Part 42
User Posts: Sachin Diwakar
0
What is Bids2008InstalledCheck?
0

Checks if any of SQL Server 2008 Business Intelligence Development Studio installation exists.

0
What is AclPermissionsFacet?
0

Checks if the SQL Server registry keys are consistent.

0
What is ServerCoreBlockUnsupportedSxSCheck?
0

Checks if an earlier version of SQL Server is currently installed.

0
What is WmiServiceStateCheck?
0

Checks whether the WMI service is started and running on the computer.

0
What is ThreadHasAdminPrivilegeCheck?
0

Checks whether the account running SQL Server Setup has administrator rights on the computer.

0
What is SetupCompatibilityCheck?
0

Checks whether the current version of SQL Server is compatible with a later installed version.

0
What is RebootRequiredCheck?
0

Checks if a pending computer restart is required. A pending restart can cause Setup to fail.

0
What is NoRebootPackage?
0

This rule determines whether the computer has the required update package for .NET Framework 2.0 or .NET Framework 3.5 SP1 that is needed for a successful ...

0
What is MediaPathLength?
0

Checks whether the SQL Server installation media is too long.

0
What is HasSecurityBackupAndDebugPrivilegesCheck?
0

Checks whether the account that is running SQL Server Setup has the right to back up files and directories, the right to manage auditing and the security log ...

0
What is ServerCorePlatformCheck?
0

Checks if this version of SQL is supported on the currently running Windows Server Core OS.

0
What is ServerCore64BitCheck?
0

Checks if this version of SQL Server is 64bit.

0
What is NoRebootPackageDownLevel?
0

This rule determines whether the computer has the required update package for .NET Framework 2.0 or .NET Framework 3.5 SP1 that is needed for a successful ...

0
What is Master Data services?
0

This service includes Master Data Services, the platform for integrating data from disparate systems across an organization into a single source of master data ...

0
What is SQL Client connectivity SDK?
0

Includes SQL Server Native Client (ODBC / OLE DB) SDK for database application development

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.