Viewing 15 posts - 12,496 through 12,510 (of 39,936 total)
1433, the standard SQL port is used by Microsoft.
You can specify this as : mhknbn2kdz.database.windows.net, 1433
May 20, 2013 at 11:02 am
Brandie Tarvin (5/20/2013)
Am I the only person in the world who didn't have issues with Vista and prefer it to Windows 7?
Outside of MS employees? Perhaps. I didn't see it...
May 20, 2013 at 9:43 am
You need to specify the database as "AdventureWorks2012".
May 20, 2013 at 9:38 am
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
Viewing 15 posts - 12,496 through 12,510 (of 39,936 total)