sean 93151 (12/21/2015)

---

The last I knew you couldn't Audit individual actions in SQL if you used AD groups. We have resorted to a PowerShell script which reads the membership of...

Phil Parkin (11/20/2015)

---

(snip)

My preference is to make the end date 'midnight on the day after the final day of the period' and then use < in any comparisons.

For example, for...

rick.foster (11/18/2015)

---

Nice except the Fiscal Year to Date will not return correct results when the Fiscal Year is not in the same year as the current date. If the current...

Fernando Margueirat-273899 (11/18/2015)

---

Thanks for this great tip!

One small change that I would make to avoid the "DR.EndDate+1" part and still be able to easily link to dates in other...

Phil Parkin (11/18/2015)

---

eavesdm (11/18/2015)

---

Good stuff. It should be coded better, though, perhaps; given the international audience and user-base and the long-established international standard ISO 8601 (https://xkcd.com/1179/) shouldn't...

Desh Maharaj (11/18/2015)

---

Hi. Thanks for that. it is very help full. But, Mostly in Financial reporting, it is required to present the reports by Month1, Month2, Month3....Month60 as separate columns...

eavesdm (11/18/2015)

---

Good stuff. It should be coded better, though, perhaps; given the international audience and user-base and the long-established international standard ISO 8601 (https://xkcd.com/1179/) shouldn't this have...

RickNPHX (11/5/2015)

---

May I ask, what kind of application does this support in your case? I can understand easy enough that the GUID involved in the merge technique causes undesirable...

jim.drewe (11/5/2015)

---

Thank you for providing this. I had to implement transactional replication without training and it wasn't pleasant. I still struggle with some aspects of it, especially the...

RickNPHX (11/5/2015)

---

Sounds like a nightmare headache to me. I don't get what the advantage would be, or what kind of applications you would need multiple subscriptions on multiple servers for....

You're welcome. Glad that you like it.

gregwhite83 (11/5/2015)

---

Great Article when implementing peer to peer replication how did you find the latencies, and how wildly do they fluctuate for you? .. I know this is a "it...

We use ManageEngine's ServiceDesk Plus; however there are other tools that rock. Sysaid is one. OTRS is free and has a good ITSM module.

Thanks for the endorsement. It is a tough job keeping up with events without doing catch-up at review time.

John.

Thanks again! I will evaluate it.

JT