Monthly Archives: July 2016

PowerSQL – Get SQL TraceFlag SQL Service and Config Information

Posted on July 26, 2016 by Prashanth Jayaram

Get SQL Server configuration, service info, start type along with enabled Trace Flags of local or remote servers. This script outputs sql server configuration, service, start type, Service Account along with startup trace flags. The script will work on SQL … Continue reading →

Posted in PowerShell, SQL | Tagged , , | 2 Comments

SQL – MultiServer SQL Inventory – PowerShell

Posted on July 19, 2016 by Prashanth Jayaram

Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of the servers you manage.This inventory can take any number of forms but, ideally, will allow some aggregation of information. When … Continue reading →

Posted in PowerShell, SQL, Uncategorized | Tagged , , , , , | Leave a comment

SQL vs NoSQL

Posted on July 15, 2016 by Prashanth Jayaram

Introduction Despite the traditional relational DB world, there’s also a trend for NoSQL. The NoSQL databases that enable storing unstructured and heterogeneous data. The scalability features have risen it’s popularity to a greater extent in the current market. Horizontal scaling … Continue reading →

Posted in MongoDB, NoSQL | Tagged , , , | 2 Comments

Tips to Fix Database Consistency Errors – Reported By DBCC CHECKDB

Posted on July 11, 2016 by Andrew Jackson

Overview While working on SQL Server, sometimes users get stuck in annoying situations when database become inaccessible. After executing DBCC CHECKDB command to check the problem, user gets database consistency errors. Causes Behind DBCC CHECKDB Consistency Errors The reason behind … Continue reading →

Posted in Backup and Restore | Leave a comment

Why MongoDB?

Posted on July 6, 2016 by Prashanth Jayaram

MongoDB is Object-Oriented, simple, dynamic and scalable NoSQL database. It is based on the NoSQL document store model, in which data objects are stored as separate documents inside a collection instead of storing the data into columns and rows of … Continue reading →

Posted in MongoDB | Tagged , | 1 Comment

Securing MongoDB – User Administration

Posted on July 1, 2016 by Prashanth Jayaram

The db.createUser(user, writeConcern)Β method used to create users.We need to provide the username, password and roles The definition of createUser as follows { user: “<name>”, pwd: “password>”, customData: { <User Tag> }, roles: [ { role: “<role>”, db: “<database>” }, { … Continue reading →

Posted in MongoDB | Tagged , , , , | Leave a comment