Skip to main content

Posts

Showing posts from May, 2012

How to Give your .NET application HA

By David PostlethwaiteI was at a meeting the other week when someone mentioned that you could specify two SQL Servers in a .NET connection string. I hadn’t heard of this before and did some investigation and found out a bit more.

In your SQL connection string you can specify a second SQL Server – a failover partner. What happens is if the primary server stops responding then your .NET application will automatically start trying to connect to the alternate SQL server.

This is ideal when you are using SQL mirroring, not only will the SQL server failover but your .NET application will failover as well

The syntax is shown below

ConnectionString=”ProviderName= System.Data.SqlClient; Data Source=Server1; Failover Partner= Server2; Initial Catalog=NorthWind ; Integrated Security=True;”

Learning Tree: SQL Server DBA Skills Upgrade

I’m very lucky in my work as freelance consultant and trainer I get to travel the world, and last week I was delivering Learning Tree course 2105 SQL Server 2012: DBA Skills Upgrade in Ottawa Canada. I’m not only a Learning Tree instructor for this course but I’m also the course author which means I get to deliver the course for the first several events worldwide. This is pretty cool, at least I think it is and last week was the fourth time I have delivered this course in a different country in the last nine months.These four events have run across Europe and North America and have taken me from Washington DC to Vienna to London and now Ottawa. I think its a pretty cool course,  covering several of the new features in SQL Server 2012 including AlwaysOn Availability Groups, New features in Performance (Column Store indexes), File Table and Semantic Search, User defined server roles, enhancements to SQL Server Auditing and much more besides.What I enjoy most from teaching SQL Server cou…

Books for Learning Transact SQL

I got asked a question recently about what books I would recommend for learning T-SQL. I posted a couple months back about me book list for SQL Server 2012. You can find that post here. In terms of T-SQL I have a couple of books that I Like1. Microsoft SQL Server 2008 T-SQL Fundamentals (PRO-Developer)2. Inside Microsoft SQL Server 2008: T-SQL Querying3. Inside Microsoft SQL Server 2008: T-SQL Programming (Pro-Developer)If you have any book recommendations for learning TSQL that are not listed here please leave a comment and let me know

The Importance of Regular Blogging

Between my old website, which I started back in 2007 (which has since disappeared) and my blog, which I switched to in 2009 I have been writing and publishing content regularly for a at least 5 years. I enjoy writing on my blog I use my blog to document what I have learned about SQL Server and other technology. Its a great way to document what you do, it can act as a great future reference when you can’t remember how do something you can just go to your blog and look it up. You can even send co-workers to your blog if they need to know how to do something and you have written a post on that subject.It can also serve as great tool to supplement your CV/Resume when looking for a new job. If you have a CV that lists a bunch of skills that you say you have and you also include a link  to your blog that demonstrates your SQL Server skills it can help you secure a job over the next candidate.If you really get to grips with blogging it can actually help you start your own consultancy busines…