Monthly Archives: July 2016

PowerSQL – Get SQL TraceFlag SQL Service and Config Information

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

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

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 , , , | 1 Comment

Tips to Fix Database Consistency Errors – Reported By DBCC CHECKDB

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?

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

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