SQL Server 2012 AlwaysOn Availability Groups setup scripts - Part 2

3. Install SQL Instance
   a) Configure the firewall setting on both 2 nodes.
echo Default Instance
netsh advfirewall firewall add rule name="SQLServer"...

Exploring Excel 2013 for BI Tip #9: Adding Calculated Members

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...

Share t-sql snippets to the team with SQL Prompt

Red-Gate SQL Prompt is a plugin for SQL Server Management Studio that makes the developers life easier when writing t-sql....

SQL Server 2012 AlwaysOn Availability Groups setup scripts - Part 1

Here are some scripts which can be used for setting up 2 nodes AlwaysOn Availability Groups, you can make your own...

First steps with Extreme Transaction Processing – Hekaton

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
A few hours...

SQl Server 2014 CTP1

CTP 1 of SQL Server 2014 was released this evening. If you have an MSDN or TechNet account you can...

The Secret to Keeping Your Cool Like an Experienced Production DBA

Your actions as a Database Administrator can make the difference between a disaster being a minor nuisance or a major problem.

In this post I share with you what I...

The Secret to Keeping Your Cool Like an Experienced Production DBA

Your actions as a Database Administrator can make the difference between a disaster being a minor nuisance or a major...

Natural Born Killers (The series) – Day 6 Sargability

To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL...

SQL Server 2014 CTP1 Released

It is here! the first CTP for SQL 2014 is available for download from the Technet evaluation centre... Just downloaded...