Viewing 15 posts - 16,291 through 16,305 (of 39,970 total)
On the cheap, you can look here: http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/vcspart1/523/
Red Gate's Source Control supports a lot of VCS systems with the latest release and integrates nicely with SSMS.
Disclosure: I work for Red...
May 5, 2011 at 2:32 pm
Interesting idea. Sounds like a reasonable strategy for your business. I'd be concerned about having to recovery with Compellent at another location, but that's separate.
One other question for you: do...
May 5, 2011 at 2:07 pm
mohammed moinudheen (5/5/2011)
Great question Steve.To be frank, I never thought on these lines.
Me either, but it makes some sense that you might want to mirror your publications. I think not...
May 5, 2011 at 11:17 am
HowardW (5/5/2011)
May 5, 2011 at 10:53 am
http://www.ssrstips.com (5/4/2011)
I would agree that the overall security structure when you get to many admin tasks is confusing, and it's not well designed from an ergonomic standpoint. It's as flexible...
May 5, 2011 at 10:44 am
Craig Farrell (5/4/2011)
I work for a living, dangit, they meet rarely and at a really bad time for me. I don't usually leave the office before 6.
I might make...
May 5, 2011 at 10:42 am
GilaMonster (5/5/2011)
Fal (5/5/2011)
Thanks for this Steve. I was beginning to get worried that no one could list a single item/thing guaranteed to hit tempdb regardless of memory.
Bear in mind...
May 5, 2011 at 10:41 am
Usually it's the latter, but opening connections doesn't affect the transaction log. If you have login auditing running, it will enter data in the SQL Server Error log and potentially...
May 4, 2011 at 9:33 pm
http://www.ssrstips.com (5/4/2011)
May 4, 2011 at 10:31 am
If it's for high level administrators, then why not this?
Create procedure MoveDate
@id int
as
insert Final
select *
from temp
where temp.id = @id
May 4, 2011 at 10:17 am
There isn't a good way to figure out what's in tables. If I create a C0101 table, SQL Server has no idea what I store in there. You're depending on...
May 4, 2011 at 10:16 am
DTS isn't really built for this. It would be more like something you would do in a web page or reporting services. To make this work you would have to...
May 4, 2011 at 9:17 am
If there is an application, or a specific set of data you are looking to find, here's what I'd suggest. Make note of some values that you want to query...
May 4, 2011 at 9:06 am
Viewing 15 posts - 16,291 through 16,305 (of 39,970 total)