Useful article, thanks.

• This reply was modified 5 years, 8 months ago by  Andy Hogg.
• This reply was modified 4 years, 12 months ago by  Andy Hogg.
• This reply was modified 4 years, 12 months ago by  Andy Hogg.
• This reply was modified 4 years, 12 months ago by  Andy Hogg.
• This reply was modified 4 years, 12 months ago by  Andy Hogg.
• This reply was modified 4 years, 12 months ago by  Andy Hogg.

As previously stated, the answer is incorrect.

Nice article Thomas, thanks.

Hi Steve, am I misreading this?

The correct answer is recognised as:-

GROUP BY Person HAVING COUNT(DISTINCT Played) = 3

I agree with that.

But then in the subsequent explanation, one of the other...

Hi FTdenaliFTdenali.

Yes the direct upgrade path that you desire is possible I believe.

You have got to be kidding me!!! :w00t:

1) Storing dates as strings.

2) Storing financial values as floats.

I feel dirty now...

Hi Siva,

The message "The transaction log for database XXXX is full due to 'AVAILABILITY_REPLICA' " can sometimes be an indicator that the AG replication is not able to send (or...

In case this has been bugging anyone else, version 3 of the Kerberos Configuration Manager has now been released which supports SQL Server 2014 🙂

Great article and a very clear and detailed explanation - thank you very much.

Have just seen this exact same problem with a 4 replica AlwaysOn Availability Group.

Sure enough the disk...

Or indeed if you're from an Oracle background how about:-

http://www.amazon.co.uk/Microsoft-Server-2008-Administration-Oracle/dp/0071700641/ref=sr_1_1?ie=UTF8&qid=1351932054&sr=8-1

or

http://www.amazon.co.uk/Microsoft-Server-Administration-Oracle-ebook/dp/B0049SOOMO/ref=sr_1_2?ie=UTF8&qid=1351932054&sr=8-2

How about this:-

http://www.amazon.co.uk/Oracle-Database-Administration-Microsoft-ebook/dp/B004323A1M/ref=sr_1_3?ie=UTF8&qid=1351931658&sr=8-3

I haven't read it so can't tell you if it is any good or not.

If you do read it, post back here and let us know.

Hi Burzin,

When using https with NLB and SSRS, the trick is to create the certificate for the name of the NLB URL as opposed to the physical names of the...

I think you could do worse than look at Idera SQL Diagnostic Manager.

It has plenty features that I find very useful.

You’d need to check out the product yourself to see...

Jako,

From what you've said, it sounds like your ideal partition key would be a combination of year and week. Unfortunately multiple columns for a partition key are not allowed.

However one...