hitesh.ramchandani (8/16/2013)

---

Koen Verbeeck (8/16/2013)

---

Remember that you now gave everyone full access to your...

I don't think there is something similar at this site, but it would make an awesome feature.

Would you get any benefit if the data is sorted according to ID and empNo?

In my data warehouses I usually have three logins: an administrator group, a reader group and a writer group. I give permissions to those groups and it is up to...

I said use IS NULL to compare.

For example:

CASE WHEN myColumn IS NULL THEN do something ELSE do something else END

You cannot compare columns directly with NULL (myColumn = NULL will...

Use proxies in the SQL Agent...

Just add another CASE statement where you check if the expression is NULL with IS NULL. If it is, use the expression m / tt. You might want to put...

Remember that you now gave everyone full access to your data in the...

This makes me wonder when Gail will reach the SSC Guru level 🙂

Apparently a bug in the total leader board not showing the correct levels above SSChampion.

If you go to the thread mentioned in the reference, you see the correct level with...

Jan Van der Eecken (8/15/2013)

---

Hartelijk gefeliciteerd, Koen.

I need to start posting more replies so we...

Phil Parkin (8/15/2013)

---

jbowers (8/15/2013)

---

You state that the wizard method of project deployment "is of course not suited to deploy projects to the production server". As someone who is just upgrading...

Phil Parkin (8/15/2013)

---

mtassin (8/15/2013)

---

Hey Koen,

Nice article. I hope you'll at some point discuss the headaches of managing the execution logs of projects deployed to SSISDB. 🙂

Especially with the...

s_osborne2 (8/15/2013)

---

So i guess BIML will become your...

There's no benefit of creating a master package for just a single child.

However, if you have a lot of child packages, you can let them all run in parallel, cutting...