Viewing 15 posts - 1 through 15 (of 36 total)
Probably worth considering not hardcoding the SubId into the package either, but rather using the DDS name/description:
SELECT @SubId=SubscriptionID FROM dbo.Subscriptions WHERE Description='DDS_Name'
EXEC dbo.AddEvent @EventType = N'TimedSubscription', , @EventData = @SubId
June 30, 2016 at 5:23 am
I tend to simply add Windows AD groups as logins and don't bother with any associated role.
I'm curious what value a role adds?
(I'm aware the main thrust of your editorial...
May 13, 2016 at 12:27 am
Aren't the release problems you descibe what proper source control systems and processes are there to address?
Source control branching, coupled with a high level database management system, such as...
April 9, 2015 at 3:03 am
Lawrence Moore (9/12/2014)So can someone explain how a synonym is superior to a view?
Lawrence Moore (9/12/2014)
A SYNONYM can be to any object, including stored procedures and functions. I don't think...
September 15, 2014 at 2:24 am
I played around with synonyms for a while, then came to the conclusion that they really offer no advantages over views.
So can someone explain how a synonym is superior to...
September 12, 2014 at 4:38 am
Excellent article. Very comprehensive and informative.
Will be very useful in future to have comprehensive comparison data side by side in one place.
June 8, 2012 at 3:47 am
How about using this for a TSQL based solution?:
SELECT DISTINCT(local_tcp_port) FROM sys.dm_exec_connections
September 8, 2011 at 2:22 am
I am using sql 2005 and I find in this address a possible solution.....
This looks like a nice automated solution, based on triggers....
May 26, 2011 at 3:57 am
May 25, 2011 at 3:28 am
fmendes (5/24/2011)If we add a timestamp/rowversion column will the CHECKSUM_AGG() not always give accurate results?
Yes I believe you are right, but this raises the question of what value the CHECKSUM_AGG()...
May 25, 2011 at 3:25 am
BTW I was thinking more about your post, and it also occurs to me that if you have a datetime column maintained by triggers, then you could simply use the...
May 23, 2011 at 2:12 pm
I'd be very careful using the sys.tables.modify_date field.
In my experience, it is not always kept up to date in realtime.
For example, try the following:
CREATE TABLE test1 (i INT, vc1...
May 23, 2011 at 10:57 am
It's a very good point you raise. Of course you are correct. However, I think it's still worthwhile highlighting the shortcomings of the CHECKSUM functions to further encourage the...
May 23, 2011 at 10:49 am
Many thanks for your post.
It is true that DMVs offer lots of useful information, some of which could be applied for requirements discussed in my article.
However, DMVs typically require...
May 23, 2011 at 8:06 am
That would cover inserted rows only, but not cater for updates on the row, nor row deletions.
May 23, 2011 at 6:30 am