Thank you for the suggestion however I have tried this and there is no improvement.

By default...

This blog covers conditional formatting, its pretty simple

https://blogs.msdn.microsoft.com/davidlean/2009/02/16/sql-reporting-how-to-conditional-color-14-the-basics-report-expressions-custom-code/

for example in:

=iif( Fields!myField.Value < 0, “Red”, “Black”)

Its been a while since I enabled TDE on anything outside of DEV. Its a CPU intensive operation so there is no way to guess at how long its...

Its been a long time since I relied on the tablediff utility so it may well be a bug introduced since I last used it.

These days I'm fortunate enough to...

Figured this out, the column is a ntext column, so once converted to a NVARCHAR(MAX) and using queryout with BCP the data is written to file in the...

Did you include the -c (Compare column-level differences) or the -q (Perform a fast comparison by only comparing row counts and schema) switch in your command?

rightontarget (4/21/2016)

---

Hello,

Today, I am able to connect from SQLServer 2K8 to MySQL servers inside the company by using MySQL Connector/ODBC and running the following:

EXEC('SELECT * FROM OPENQUERY (system_dsn_name, SELECT .......

arkiboys (4/19/2016)

---

Hello,

I do not know much about sql server DBA tasks but my next project will be to setup a Dev, UAT environment.

Currently there is a production server.

There will be...

We are using clustering in a 2 node active \ passive configuration.

However having just re-read the thread I can see why your confused. I see now the...

GilaMonster (4/19/2016)

---

RTaylor2208 (4/19/2016)

---

During fail over though the instance will take slightly longer to come online as it will perform an upgrade \ downgrade between versions. You'll see this reported...

jayoub (4/15/2016)

---

Can we failover to a lower version of SQL Server?

Currently mirroring is configure on two servers

Principle SQL Server 2008 R2 SP3 (10.50.6220)

Mirrored SQL Server 2008 R2 SP3 (10.50.6000)

Will we...

Potentially yes, it all depends on what your trigger is doing and what proportion of "hits" are selects compared to updates \ inserts \ deletes.

If you share your code...

This is possible using extended events, server side trace or SQL server profiler.

If your new to this SQL server profiler is the easiest way but i will mention that you...

AWS-Architect (3/10/2016)

---

Support and ongoing upgrades are included, and it works with RDS SQL Server Web Edition. Supporting your custom solution won't cost less. I am an independent consultant. It works...

zheliazkoff (3/10/2016)

---

Check out the Cloudbasic RDS SQL AlwaysOn tool from the AWS Marketplace (https://aws.amazon.com/marketplace/pp/B00OU0PE5M/ref=_ptnr_blg_’blg5’ ). It is designed to do exactly what you need - continuously replicate data from your...