The text data type is deprecated. You should use Nvarchar(max).

You can right click on an individual report and deploy it rather than deploying the whole project. Deploying a single report will also deploy any shared datasources/set used by that...

Not sure exactly what you are looking as you didn't post any expected outputs but try the below which adds a column for type (in or out) and uses union...

I also hate XML.

There is also a course on the MVA for specifically XML and SQL server and I think the course I previously linked to covers it.

Make sure...

It is OK to reveal your score if you want to or discuss the top 3 weakest areas from your score record.

You shouldn't discuss anything to do with the format...

Ah Ok so you have hidden rows? What is the expression you are using to hide the rows? For example if the rows were being hidden by the following expression

=IIf(Fields!Field1.Value...

Have you tried RowNumber()?

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

You appear to have forgotten to post the error.

You need visual Studio in order to develop SSIS packages. If you don't have Visual Studio then the link below will install a "shell version" to allow you to develop...

It's Windows XP embedded though not the bog standard Windows XP install. So the security risk could be minimised by only having the components required to function - though depends...

Unless I have missed something is this just a simple grouping? If so does the below work - you may need to fix any syntax errors as I created it...

Check SQL Server Agent, see if any jobs are scheduled to run at that time.

You could also create an alert that fires if the log size increases over a certain...

You really need to post some sample data

You could use isdate()

declare @Table table

(DateColumn nvarchar(20))

insert into @Table

select '2015-01-01' union all

select '31/01/2015' union all

select '01/31/2015' union all

select '2015-01-01 00:00:00' union all

select '2015-01-01...

If you don't want to create the Prod cert onto dev then your options, as far as I know, are:

Set up some form of integration to export / import the...

Luis Cazares (1/4/2016)

---

That's not spam.

He's asking for books that cover the topics, not brain dumps.

I'm not sure how would I prepare for the exam, but a good start is...