Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Archives: September 2014

PASS 24HOP AlwaysOn Questions Answered

I presented a session titled “SQL Server AlwaysOn Quickstart” on September 10th for the 24 Hours of PASS event.  You can view the session recording HERE if you missed it.  The session was a preview of the full session I will be presenting at the PASS Summit 2014 this November.… Read more

0 comments, 143 reads

Posted in Ryan Adams on 30 September 2014

I Must Be Doing Something Right – MVP Award

I am extremely excited to announce that I have just received the Microsoft MVP award for SQL Server for 2014.

For those that know what this whole MVP thing is there isn’t much more to say other than the headline:

I must be doing something right!




For… Read more

14 comments, 42 reads

Posted in WaterOx SQL on 30 September 2014

PASS Voting Extended Until October 14th

The Board of Directors has extended voting in the current election through October 14th. Read the post from President Thomas Larock about why and what you have to do to be eligible. Then head to Election HQ to review the candidates, ask questions, and read posts and endorsements from other… Read more

0 comments, 5,037 reads

Posted in SQLAndy on 30 September 2014

Speaking at Space Coast SQL Users Group on October 10th, 2014

I’ll be driving to Viera for the monthly Space Coast SQL Users Group meeting next week. Topic still to be decided, probably Learning Plans and something SQL, look for details on the web site today or tomorrow at

Read more

0 comments, 134 reads

Posted in SQLAndy on 30 September 2014

The Fallacy of Internal Access Only

In the wake of Shell Shock, I’ve seen some vendor advisories indicate that while their product is vulnerable, it’s only through the management interface but everything is okay because if best practices have been followed, the management interface isn’t/hasn’t been exposed to the Internet.

No, everything is not okay.… Read more

2 comments, 6,128 reads

Posted in Databases – Infrastructure – Security on 30 September 2014

IaaS, PaaS, and SaaS explained

You might be reading a lot about Cloud computing and see three acronyms frequently: IaaS, PaaS, Saas.  Cloud providers offer their services according to these three fundamental models:

Infrastructure-as-a-service (IaaS)

This is the most basic model which is essentially your virtual machines in a cloud data center.  You… Read more

0 comments, 291 reads

Posted in James Serra's Blog on 30 September 2014

VMware vCenter Web Client IP redirect solution

If you are working on a VMware vCenter Server v5.5 in an environment that has multiple segregated VLANs designed to isolate certain types of traffic, and find that the web client for your admin-facing interfaces keeps redirecting to an internal isolated IP address – and therefore fails – here’s the… Read more

0 comments, 115 reads

Posted in Technobabble by Klee from @kleegeek on 30 September 2014

Video: Walk & Talk #003 – RPO

What is the RPO?

And why does it matter?

Join me as I walk through Jefferson Patterson Park’s Indian village and discuss the Recovery Point Objective and what it means is respect to SQL Server.

Location: Jefferson Patterson Park

More info:

Read the full article here

The post Video:… Read more

1 comments, 112 reads

Posted in WaterOx SQL on 30 September 2014

Notes On SQLSaturday Orlando #318

Notes from a speaker/volunteer perspective:

  • It was a lot of fun to talk to the students at our Student to IT Pro Seminar. Interesting to hear their questions, easy to forget what it’s like to be a true beginner. 70 people in the seminar. Win!
  • I had about 20 in…

Read more

2 comments, 183 reads

Posted in SQLAndy on 30 September 2014

A real life table variable performance problem.


I’m sure we’ve all heard and read about the differences between table variables and temporary tables. In case you haven’t here’s one of many articles that you can read on the subject.

Anyway, there is a business process in one of my databases that calculates results via… Read more

2 comments, 562 reads

Posted in measure twice, cut once. on 30 September 2014

SQLServer 2008 R2 SP3 released, Now its testing and deployment time!

As promised Microsoft released SQL Server 2008 R2 SP3 last Friday, and now this is your opportunity to test and patch all the existing SQLServer 2008 R2 to this latest build.

SP3 will be the last and final service pack for SQL Server 2008 R2 ,and it will be a… Read more

0 comments, 175 reads

Posted in on 29 September 2014

What PASS is to me #sqlpass

I found out about the Professional Association for SQL Server (PASS) in 2008 when I attended my first PASS Community Summit “SQL Server Heroes UNITE”. For those who don’t know what the PASS Summit is, it is the largest SQL Server and BI convention in the world. A SQL Nerd… Read more

1 comments, 122 reads

Posted in Tim Radney - Database Professional on 29 September 2014

Making Better Presentations–Organize Things

This is part of a series of tips for speakers on how to make your presentations better.

Organization matters, and it makes a difference to how your presentation goes. The more organized you are, the better the experience for attendees. If you are very unorganized, then it becomes hard for… Read more

0 comments, 217 reads

Posted in The Voice of the DBA on 29 September 2014

Notes On Our First Student to IT Pro Seminar

This past week we did our first try at the Student to IT Pro Seminar, run concurrently with SQLSaturday Orlando. You can read why we did it at Some notes on the experience:

  • We registered 85, had about 70 attend
  • Mostly students, but we had a few from…

Read more

1 comments, 5,910 reads

Posted in SQLAndy on 29 September 2014

SQLSaturday Orlando Marketing Plan–Part 48

This past Saturday we held our eight annual SQLSaturday. I’ll write some notes about the event and post today or tomorrow. The final registration count after marking 20-30 people as cancelled (things got hectic, was hard to track) was 640 (vs 344 last year) and our best effort on attendance… Read more

0 comments, 123 reads

Posted in SQLAndy on 29 September 2014

Database default locations

One of the options you had when installing your instance was setting some default file locations.

  • Defaut data file location
  • Default log file location
  • Default backup file location

If you are new to installing SQL Server (and even if you aren’t) you might very well have skipped past these… Read more

4 comments, 6,463 reads

Posted in SQLStudies on 29 September 2014

SQL Server 2008 R2 Service Pack 3 Is Now Available !

Finally after a long waiting period, Microsoft release SQL Server 2008 R2 Service Pack 3, Same is now available for download at the Microsoft Support site. SQL Server 2008 R2 Service Pack 3 contains all the hotfixes released since the initial release of SQL Server 2008 R2 RTM.

I suggest… Read more

0 comments, 180 reads

Posted in MSSQLFUN on 29 September 2014

SQL Server Configuration Manager giving Error : The remote procedure call failed. 0x800706be

Issue : I am facing error “The remote procedure call failed. [0x800706be]” while trying to view SQL Services from SQL Server Configuration Manager.

Steps I perform to resolve the issue, Seems to be a WMI error :-

1) If using Window Server 2008 & above, Run command from command prompt… Read more

0 comments, 2,560 reads

Posted in MSSQLFUN on 29 September 2014

How to Make Sure Your Clients Can Connect to a Multi-Subnet Cluster

When you set up a multi-subnet cluster, whether it’s a Failover Cluster Instance or an Availability Group, you need to make sure you understand a few things in order for your applications to work properly after a failover. For the sake of our discussion, let’s assume we have a multi-subnet… Read more

2 comments, 134 reads

Posted in Matan Yungman on 29 September 2014

PASS Votes… A little bit more #passvotes

I am putting up an abnormal Saturday morning blog post in support of the actions taken by the PASS Board last night.

The story so far…

In order to eliminate all the excess ballots (I received 5 one year although I only used one) being sent to eligible members… Read more

1 comments, 141 reads

Posted in The Scary DBA on 27 September 2014

Older posts