Thanks...

Apologies if my following question is answered on a FAQ somewhere (if so - I cant find it) but what is the rule here regarding thread bumping? If the thread...

Read this.

http://blogs.microsoft.com/next/2015/05/27/always-encrypted-sql-server-2016-includes-new-advances-that-keeps-data-safer/">

http://blogs.microsoft.com/next/2015/05/27/always-encrypted-sql-server-2016-includes-new-advances-that-keeps-data-safer/

You have to issue Analysis Services queries - MDX based. Have a google.

A really high level one is usually based from $SYSTEM.MDSCHEMA_CUBES

During the setup you will have an option (tick box) = Create new login if necessary and assign it rights to the MSX. Tick that, if that is against your...

How about import the data in a local SQL database and use data sync services to connect Local SQL Db ( On earth SQL ) To SQL Azure DB? This...

what does SSF mean?

Justin Manning SA (6/1/2015)

---

Why not set up Always On with a secondary read, or enable SQL mirroring between the two instances?

With Mirroring, you can create a daily snapshot of...

Hi ,

I took these exams to move from the MCITP to MCSE, I used the Syllabus to drive my revision then used all sorts of books to learn.

Be aware of...

A quick Bing search will help you??

MAX / MIN settings - https://technet.microsoft.com/en-us/library/ms180797(v=sql.105).aspx"> https://technet.microsoft.com/en-us/library/ms180797(v=sql.105).aspx

LPIM (Article is 2008 based but still is a good read )

I don't why this happens but I seem to fix these issues by adding my AD account to the site settings.

Repairing a suspect DB?...

I agree with Grant I have used Jonathan Kehayias's Extended Events script to get an idea of blocking, I just changed it slightly because I knew the database_ID that I...

That is the ideal scenario where the...

Excellent I like the sound of that. I have booked the week off as annual leave and booked the hotel so I am ready to rock and roll... Hopefully I...