Viewing 15 posts - 31 through 45 (of 162 total)
IMHO, even "CREATE or ALTER objectname" can/should be reduced to just "CREATE objectname". Visual Studio database projects / SSDT has had this for years. Just issue the create statement, and...
November 29, 2016 at 8:02 am
lshanahan (6/7/2016)
June 7, 2016 at 7:40 am
John Hick-456673 (5/6/2016)
Creating indexes for data in other environments that does not conform to a production-like spread just does not make any sense and accomplishes nothing.
Yes, it does - it...
May 6, 2016 at 6:07 pm
Thanks for sharing your thoughts Daniel, but I really can't agree with index creation / maintenance being outside the purview of development and in the care of admins only. I...
May 6, 2016 at 9:41 am
Nice trick, thanks for sharing.
March 22, 2016 at 8:28 am
I've used in in the past for specific projects, not a big fan because of its chatty and distracting nature. Between email and IM, my communication needs are met.
March 9, 2016 at 1:29 pm
The good people at Red-Gate seem to be working on this...
http://www.red-gate.com/products/dlm/ssdt-extensions/#reference-manager
January 22, 2016 at 1:29 pm
Has anybody on this thread heard anything about Microsoft adding data to the declarative nature of SSDT projects? Sure would be a neat feature.
January 19, 2016 at 9:46 am
Thanks for the article. One of the worst pieces of advice I heard early in my career was: "Code is its own documentation." Fortunately, I never agreed with that.
December 21, 2015 at 9:13 am
It doesn't happen just with audits either. At a previous gig with a company staffed by very technically capable people, a company that is in the software business, I once...
December 1, 2015 at 8:19 am
Keep things simple, use Active or IsActive, and not InActive UNLESS there is a small subset of records with that value which helps a crucial filtered index...
October 23, 2015 at 10:16 am
WayneS (5/6/2013)
So, I cannot think of any way of doing this. Perhaps other readers have a solution?
Dynamic SQL?
October 16, 2015 at 2:11 pm
Good article, thanks.
October 16, 2015 at 2:08 pm
robert.sterbal 56890 (9/14/2015)
So is this an area Red-Gate is trying to determine if they can do another ingenious solution?
Great question. Red-Gate: are you?
September 14, 2015 at 7:32 am
I'm going to play devil's advocate, and ask this question: why bother with creating or maintaining the ER diagram? What purpose does it serve after the very initial design stages?...
September 11, 2015 at 8:04 am
Viewing 15 posts - 31 through 45 (of 162 total)