PowerShell for Searching Database Objects Part I

February 22, 2013 3 comments

Here is ProwerShell 3.0 Script for searching database object based on their names. We will use AdventureWorksLT2012 database, and will look for SQL Server objects name containing “user” for table level objects only explicitly excluding Federations, because this throws an error. Basically we are going to achieve output below SQL query with ProwerShell Script. Read more…

PowerShell for Creating a Database

February 19, 2013 6 comments

This script explains creating a MS SQL Server database with default properties using PowerShell V3.0. In this script we are going to create a database called “PSDB”, by assuming that this database does not yet exist in current instance. Read more…

PowerShell and SQL Server Works Together

February 18, 2013 5 comments

Before I write anything about PowerShell and MS SQL Server, we need to understand few important concepts and terminology which will help us to identify that PowerShell and MS SQL Server works together. Read more…

PowerShell V3 What’s New?

February 15, 2013 3 comments

In this article I’m going to list some of the notable features introduced in PowerShell V3.0

  • WorkFlows

PowerShell V3 introduces Windows PowerShell Workflow (PSWF), which helps automate the distribution, orchestration, and completion of multi-computer tasks, freeing users and administrators to focus on higher-level tasks. PSWF leverages Windows Workflow Foundation 4.0 for the declarative framework, but using familiar PowerShell syntax and constructs. Read more…

Categories: Powershell Tags: ,

PowerShell Script to Send Email (multiple recipients)

February 15, 2013 14 comments

In this article I will try to wrap how to PowerShell to manage your SQL Server Notifications. And this is very much regular scenario for most of the SQL Server DBA’s to generate notifications when issues arise. There are many ways that we can handle these notifications, but one of the simplest and most reliable and the most common way is email notifications. Read more…

NoSql vs Relational Database

February 11, 2013 1 comment

In my last article I tried to explain NoSQL Do’s and Don’ts. Now it’s time to summarize the criteria that would represent an endorsement for either NoSQL or relational databases. And these criteria are going to break down into a few different areas like financial, issues of demand or load on the system, and the type of work, the workload that the system needs to take on. Read more…

NoSQL Do’s and Don’ts

February 5, 2013 2 comments

In this article I’ll be explaining about Do’s and Don’ts about NoSQL. Essentially I will be talking about the set of circumstances, the scenarios where NoSQL Database makes the most sense and the scenarios where it really doesn’t make a lot of sense and where relational databases would in fact be more appropriate. By sketching out the different scenarios for the different types of databases, you’ll then be in a good position to understand, based on whether your requirement is exposed to one set of scenarios, the other set or both, whether NoSQL databases are appropriate for your organization and for your requirements. Read more…

Social Media and Sentiment Analysis

January 23, 2013 1 comment

Recently sentiment analysis has gained much attention and interest to huge proportions which is also being fuelled by the many social media platforms mushrooming each day. And sometimes we actually do not understand how this is going to help? But before this we need to understand what sentiment analysis is and how it really works? Read more…

What is Graph Databases?

January 14, 2013 Leave a comment

This is last item is NoSQL Categories Breakdown series, in this article I will explain about Graph Databases which is one of the subcategory in NoSQL databases. Specialty of Graph Databases is they work really great for tracking relationships and that’s why this category is great fit for social network applications or just about anything where relationships are playing really important roles. And relationships can be thought of in an expansive way because you know how relationships costs in RDBMS. In Graph Database one relationship is about ownership or control and with we can pretty much represent just any data from that database. Read more…

What is Wide Column Stores?

January 13, 2013 1 comment

As mentioned in my earlier article for Key-Value Stores, wide column stores have tables which contains columns. The small difference is that Wide Column Stores takes a hybrid approach mixing the declarative characteristics game of relational databases with the key-value pair based and totally variables schema of key-value stores. Wide Column databases stores data tables as sections of columns of data rather than as rows of data. Read more…

%d bloggers like this: