I don't know how you do it. I can't read tech books without falling asleep. I use them as reference to learn something new or relearn something I've...

Spent all last week at DevIntersection 2015, concentrating on the SQL track since I am a DBA. I can tell you based on the questions coming from other attendees...

We are not using dacpacs. DB projects are way too kludgy for the DB sizes we typically deploy and, as I understand it, are required if you intend to...

Rodney, I'm in a similar boat in that I've worked with replication but don't understand the technology very well. Shoot, I've even set it up and fixed it without...

Steve, I would love to do a write up on it, but alas, it is not my project and I don't have the necessary details to write anything worthwhile. ...

We're actually building out our "lake" using CDC and cherry picking the pieces and parts to fill a data warehouse. The warehouse is then exposed via the new"er" power...

Ummmm...the failure messages.

I used the script provided earlier in this thread. Yes, it was a varchar(max) and the resulting query built out to somewhere between 12k and 13k characters.

Well I tried and couldn't get it to work. So if you know the secret, please share. I spent half a day trying and it kept failing.

Neat script but it has some issues. You can't execute the sql generated once the character string gets over 8000. You can't even print it without a lot...

Not sure if I got a bad version of the script, but it doesn't work right - infinitely loops. The problem is line 76; it assumes every chunk to...

Why not a linked server?

Here's my situation and you can tell me what you'd do. I just started at a new company. I'm part of a...