4. Setup 2 nodes alwayson availability group
a) Enable alwayson on both 2 nodes
enable-sqlalwayson -Path "SQLSERVER:\SQL\SQL2012-01\DEFAULT"
enable-sqlalwayson -Path "SQLSERVER:\SQL\SQL2012-02\DEFAULT"
b) Restore...
2013-06-25
2,261 reads
CTP 1 of SQL Server 2014 was released this evening. If you have an MSDN or TechNet account you can...
2013-06-25
681 reads
As I mentioned in my blog post describing the new features in the next version of SQL Server (see SQL Server...
2013-06-25
1,218 reads
It is here! the first CTP for SQL 2014 is available for download from the Technet evaluation centre... Just downloaded...
2013-06-25
597 reads
In our daily life, we use the statistics to take the decision. In the same way SQL server optimizer use...
2013-06-25
11,037 reads
Terminate a SSIS package after specific time interval.
There are several ways you can execute scheduled SSIS package/job they are:
A) SQL...
2013-06-25
8,990 reads
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...
2013-06-25
23 reads
Industry experts will tell you that virtualization of your environment is not done to improve performance, it's done to make...
2013-06-25
4,478 reads
Baselines can be any set of metrics that have been recorded to give you an understanding of what is the...
2013-06-24
2,911 reads
I had a client recently that needed me to get the direction a student’s GPA was headed on a regular...
2013-06-24
756 reads
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Comments posted to this topic are about the item Checking the Error Log II
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers