Interesting question about a topic I have used rarely , even if I have attended several sessions in Technet days.

I have had to dive in the depth of my memory...

Easy question for me as I remember to have given a bad reply among the SMO-DMO forum ( MSDN forums ) when I begun to post actively on this forum...

Even if I have followed 3 sessions about MDS , I have never used it. So I am very lucky to have choosen the correct answer.

Thanks for this QOT. When...

Thanks for this question. I have given a bad answer , but I am pleased because I have learnt something today.

Easy question as the possibilty to add/remove members to database roles was introduced in SQL Server 2012. So the question about the version is useless as ( if I am...

I have been lucky when I have done my choices as I have not used SQL Server Agent since 2 years.But after 5 minutes , I have done my choice...

jan.dewettinck (8/9/2015)

---

Thanks for the question

Not sure if the following link provides a better explanation.

https://msdn.microsoft.com/en-us/library/ms187928.aspx

I based my answer on the part about the style which says that the...

Easy question as I have attended to a session about the mirroring 2 years ago and the lecturer began ( in a clever way ) by giving the list of...

Uwe Ricken (8/1/2015)

---

Hi Steve,

seems to be NONE of the given examples are correct 🙂

USE [mydb]

GO

ALTER DATABASE [mydb]

MODIFY FILE

(

NAME=N'OldName',

NEWNAME=N'NewName_01'

);

GO

I assume that you have...

Thanks for this easy question ( I got a similar question during an interview and I remembered that I hesitated only for the choice between Date and Time ).

dwain.c (6/25/2015)

---

patricklambin (6/25/2015)

---

Excellent article , easy to understand ( nice for the readers for which the English language is not the mother tongue as for me ).

Just a surely stupid...

Excellent article , easy to understand ( nice for the readers for which the English language is not the mother tongue as for me ).

Just a surely stupid question (...

Easy question as I have read yesterday the article about this topic. at[/url]

And I was surprised to see twice the same topic with the same author.

I am not liking JSON...

I have forgotten to tell you that you can use PowerShell to create job.

A possibly useful link :

from the SQL Server Central site.

tristan.keaster (6/17/2015)

---

Hello,

I'm brand new to the forum and extremely green when it comes to SQL, I'm using SSMS 2012. I have multiple queries that are run daily(I also have...