Viewing 15 posts - 12,526 through 12,540 (of 39,963 total)
Personally I like maintenance plans and being able to build some workflow into the maintenance. However, many of the tasks in maintenance plans I'd remove and use Execute T-SQL Tasks...
May 20, 2013 at 9:36 am
You might read this article. While it's about solving problems, it could be used to do the same with existing code: https://www.simple-talk.com/sql/t-sql-programming/solving-complex-t-sql-problems,-step-by-step/
May 17, 2013 at 12:14 pm
Make sure they talk versions of software, including hypervisors. Some of the old ones had issues. I'd also ask them to talk about performance goals. Not virtualization, but in terms...
May 17, 2013 at 12:12 pm
My own answer:
I use Subversion in some demos, usually those set up early with the Red Gate tools. This was the first open source VCS we supported.
However I've been working...
May 17, 2013 at 9:50 am
chrisn-585491 (5/17/2013)
I use better version control (Git & Mercurial) for my open source projects than I do for my work related ones. Tis a sad thought...
🙁
May 17, 2013 at 9:47 am
joe.eager (5/17/2013)
For users of the RedGate solution do you recommend Shared Database Development or Dedicated?I am leaning towards Dedicated, my coworker is leaning towards Shared.
dedicated.
Use a separate database for shared,...
May 17, 2013 at 9:47 am
call.copse (5/17/2013)
The only time I have not checked any code in recently is when...
May 17, 2013 at 9:43 am
jasona.work (5/16/2013)
Why isn't it Friday yet?
It's thursday-palooza. Hour late start for school 🙂
May 16, 2013 at 10:43 am
Rob Ashton (5/16/2013)
Two factor authentication would be nice, perhaps even some sort of approval process enabled that required multiple approvals for some changes.[/Quote]
It's funny that you mentioned this Steve,...
May 16, 2013 at 10:39 am
jpowell-918558 (5/16/2013)
what about in a replication environment when the subscriber has changed? is there a way to keep replication working when computer name changes?
AFAIK you need to reset replication. The...
May 16, 2013 at 9:27 am
MiguelSQL (5/16/2013)
May 16, 2013 at 9:25 am
Eric M Russell (5/16/2013)
There could also be honeypot tables. For example, the DBA could create tables with enticing names like [Employee_Salary] or [Customer_CreditCard] and then place an audit event with...
May 16, 2013 at 9:19 am
It's possible you are getting an error on the pathing that you don't see. The command will require that the account running SQL Server (service account) has rights to the...
May 16, 2013 at 9:15 am
This is very hard. There is no magic way for SQL Server to understand how any tables are related without constraints in place to enforce DRI. If the application developers...
May 16, 2013 at 9:13 am
I don't see it in the query, but as Eugene suggested, the error implies you had members.memberid_ in the query somewhere.
I'd double check that.
May 16, 2013 at 9:11 am
Viewing 15 posts - 12,526 through 12,540 (of 39,963 total)