JzInqXc9Dg

thats always the REAL hangups.... ;)

dns / host file and all that crap...

of course it always comes down in the end to the "IT stuff"

thnx

its even faster than i thought it would be

across the ocean to another domain. #feelsgoodman

finally got my first replicated db working

hooo my god

docs.microsoft.com/en-us/sql/relational-databases/…

MS docs mentions it will increase performance... just wondering what factors play into HOW MUCH of an increase it will be... gb size? frequency of transactions and how big those transactions are, etc im sure all play a role

how big of a performance increase can result from separating the data and log files?

hi all

hey.. i appreciate it! :D

and im already feeling like ive got some insanely powerful knowledge

im BARELY into it

cool! cya

so im finding myself here more often now :)

but im starting to focus a bit more on dba activities these days

i definitely have too - more so on SO to be honest

i just registered for the live class season pass the other day. and the recorded classes. super pumped about it all

and i see @sp_BlitzErik - hi there, lol

lol, came in here - as im watching brent ozar's "how to think like the sql server engine" - to ask what the general opinion toward brent's training materials were to this group

id take hating it over regretting it

true

haha

will i hate it?

so - am i going to regret setting up Sql Replication?

maybe all the docs are assuming you are renaming a server in which connections have already been made to what will become the old name

that seems really weird compared to all the documentation I've read - but maybe also indicates this should be a smooth operation???

" any connections that used the old computer name must connect by using the new name." -> well, as far as I can tell the original renaming of the server must have been done before anything else was connected. everything seems to already be using the "new name"

and yes, near brussels

@TomV all good Tom. they are able to handle anything that happens on site

im just not physically there to remedy anything and ill be doing it at about 4am their time - but they have been tipped off and will be ready to firefight if need be! :)

that is generally what i'm expecting..

got it, that makes sense

^ yes that is precisely what I'm going to do

good ole "that box"

ok cool

hahah

I'm going to do the fix tonight and both I and my Euro colleague believe there should be little to no other systems effected. hoping that is actually true :)

@billinkc can you elaborate any on the "nightmare" that was caused by that server that was renamed?

else i would have just done it Lol

which, ironically is the cause of me even "asking" to do the replication in the first place

and also successfully made them aware of the liiiiiitle servername issue that will need to be solved first ;)

@billinkc got the green light to do the replication (this is HQ of course, so i "needed" that)

i figured all replication was done physically

didn't realize this distinction

oh interesting

that does that mean? "logical level" and "level of physical log record" ?

in reading about database mirroring: "Unlike replication, which works at the logical level, database mirroring works at the level of the physical log record. "