Viewing 15 posts - 76 through 90 (of 448 total)
I'd be interested in knowing if anyone is able to get this working via some front-end interface that sits between the database and somewhere else. Something that could interpret a...
August 19, 2015 at 3:54 pm
We rename as needed, but use the Refactoring tool in SSDT to handle a lot of those details for us - changing the affected columns, procs, views, etc. Ideally we...
June 16, 2015 at 1:15 pm
I also didn't see anything about the PK being disabled so assumed that the insert would fail due to it being a duplicate PK attempt. Even reviewing the answer, I...
June 11, 2015 at 11:47 am
Well, we used SSDT SQL Projects for our databases. We used Git for version control, but could have used anything - it's just files behind the scenes. To push the...
June 3, 2015 at 3:56 pm
mcmangold (6/2/2015)
I am not sure what VCS stands for in the phrase "There are people that follow a change script process, producing and saving .Sql files for all changes...
June 2, 2015 at 9:53 am
No worries. I didn't know exactly when the Ola comparison was released last time. I remember it being there by the time I got around to looking for it and...
June 1, 2015 at 5:05 pm
Sean/Jen, does MinionWare support archiving/purging of backups to an Azure storage container? Do you have a compare/contrast with Ola's solution like you do for your Re-Index solution?
I appreciate your work...
June 1, 2015 at 4:14 pm
hakim.ali (5/19/2015)
john.leediii (5/19/2015)
Hakim, we did try suppressing the errors (71562,71502,72014,72045,70558,71558,71005,71561) - they still show up in the Error List, even if prefixed with SQL.
Yes, looks like you can only suppress...
May 19, 2015 at 4:02 pm
hakim.ali (5/19/2015)
Peter Schott (5/19/2015)
May 19, 2015 at 10:36 am
We were in a similar situation, but I was able to use SQLPackage to extract a dacpac from all existing databases, then used that extracted dacpac as the DB reference...
May 19, 2015 at 10:16 am
Wouldn't it make sense to use DDL triggers to capture all schema changes at that point and log all of the changes to some DB to which the normal users...
April 17, 2015 at 11:45 am
Steve,
Are there any recommendations or best practices for getting started with TSQL Unit tests? That seems like the next logical progression for our processes, but I'm never quite...
April 9, 2015 at 12:42 pm
Appreciate the pointer on T4 support, Jack. I've know about the concept for a while, but adding that to my toolkit now. It looks pretty cool, if still "an opportunity...
March 27, 2015 at 8:52 am
SSMS - main tool as I do a lot of ad-hoc queries
SSDT - main dev tool. Everything that we push to our servers has to be in an SQL Project...
March 27, 2015 at 8:03 am
We started using MongoDB to cache data for our front-end to make it a little easier to present and not constantly hit the OLTP system while working with that data....
March 10, 2015 at 8:13 am
Viewing 15 posts - 76 through 90 (of 448 total)