You need to learn the concepts in the exam guides and then practice things in SSMS (adding users, other objects, editing them, making backups, etc.). those skills are needed on...

Congrats and likely you'll learn about a lot of things besides databases and SQL. That can only be good and help you in other positions.

The advice above is great and...

This absolutely should be tested, but if the drive letters are the same, you should be ok. SQL stores these in the master database, as seen by the OS.

To be...

Almost certainly this will be left in memory if it's queried with any frequency, no need to pin it.

First, licensing is a legal thing, so you should work this out with corporate legal counsel and Microsoft.

However, from what I understand

1. CALs are device or user. Can be set...

I did 443, then 444, then 441, then 431. 431 was the hardest to me.

Agree with the comments directly above as well.

It should increase as you work with more data. You can set a limit if needed in the server properties in SSMS.

definitely seems like 3186 is the limit for x64 environments.

I'd go SP2 + Cumulative updates if you have issues. Be sure you test this on another server to be sure...

There's a few other log products (Lumigent, LogPI), but Apex is probably the cheapest and will help you find this out if you have the logs or backups.

Is this installation access?

I've had Dynamics say this and we got around it by creating the database first and manually creating the logins. Once they were there, surprise, Dynamics saw...

And you want a happy job!

Be honest, even with personality conflicts. Explain it simply, and unemotionally. Tell them you didn't get along, the manager didn't seem to trust you or...

Stuff like this I'd import the entire thing into varchar columns in a staging table. then you can process it inside SQL, looking for the correct datatypes. (IsNumeric, etc.)

Hey, I started the site and then moved to the remote ranch :hehe: More my wife's idea, but I enjoy it.

If you're a senior DBA, do you want more career...

Late to the thread, but first congrats on the job and on the job you are doing. Sounds like you really are an asset to the company.

I have to plug...

It depends on your process and business rules. I've seen this handled with shadow tables, slowing down the updates (smaller batches), or even adding to the table as new rows,...