SQL Introduction and basics

In simple terms, SQL is standard that is use to access database and for modifying data in the database. SQL introduction SQL is Structured Query Language, it allows to access data inside database. SQL follows an ANSI standard (American national standards institute). SQL lets you to communicate with database and using SQL you can Execute ...

SQL Server Database Audit feature in SQL SERVER 2014

Microsoft introduced audit feature in sql server 2008 which includes server and database level auditing. You can capture database objects, database level changes, lets say somebody deleted some records from your critical database, Bingo … means somebody is having DELETE permission on prod server apart from DBA, living in DANGER. As DBA we don’t allow ...

SQL Server 2014 – How to Create Memory Optimized table

In eariler post, you have learned how to use In-Memory OLTP Feature of SQL Server 2014 for your database. Here we will learn how to create memory optimized table in SQL Server 2014. Creating Memory is very simple similar to normal table. How to Create Memory Optimized table In Memory OLTP ? We will follow the step by ...

SQL Server 2014 – Limitation of Memory optimized tables

Every good things has some its pros and cons, so here are some of the limitions of In-Memory optimized tables in SQL Server 2014 Limition of Memory optimized tables Tables used in In-Memory OLTP feature of SQL Server 2014 are known as Memory optimized tables, SQL Server 2014 has some limitions for memory optimized tables Some datatypes ...

SQL Server 2014 – New Feature In-Memory OLTP Engine

SQL Server 2014 introduced many features to improve performance OLTP transactions, In-Memory OLTP is one of the most exciting feature in SQL Server 2014 which allows to move individual tables to special in-memory structures to improve query perfomance. What is In Memory OLTP Engine of SQL Server 2014 ? This is better than other in-memory solutions that require the ...

Start and Stop SQL Server Services using Command prompt

There are number of different ways to Start and Stop SQL Server services, you can using SQL Server Configuration Manger, SQL Server Mangement Studio, Sqlserver.exe, Command prompt and Windows Console . We will see how to start and stop SQL Server using Command Prompt. You can use Net Start and Net Stop command to Start and ...

Difference in Features of SQL Server 2012 Vs SQL Server 2014

SQL Server 2012 vs 2014 There are lots of new features added in SQL Server 2014 to improve query performance, main difference between SQL Server 2012 and SQL Server 2014 are listed in this article. * SQL Server 2012 supports upto 64 GB RAM, SQL Server 2014 supports 4 TB RAM. * SQL Server 2012 ...

SQL SERVER – Select Best Recovery Model for your database

Recovery model for sql server database is depends on customer requirement, SQL Server supports three recovery models, Full recovery, Simple recovery and bulk-logged recovery. Recovery models tells you whether How much data loss is acceptable by customer. SIMPLE RECOVERY If your database is not critical and Data loss is accepable by client after last full or differential backup than ...

SQL Server 2014 – Different Editions

Different Editions of SQL SERVER 2014 Select best SQL Server 2014 Editions for your environment to improve your business. Enterprise Edition SQL Server Enterprise delivers comprehensive high-end datacenter capabilities for demanding database and business intelligence requirements. Business Intelligence Edition SQL Server Business Intelligence empowers organizations to build and deploy secure, scalable and manageable self-service corporate BI solutions. Standard Edition ...

SQL Server 2012 -How to setup new Availability Group and Listener

Follow the below steps by step approach to setup new Availability Group and Listener using powershell Script in SQL Server 2012. 1. Before starting ensure that you have the AG name, listener name and IP address ready. 2. On a new instance, endpoint need to be created. Only one endpoint is needed per instance pair. If you ...