If you're migrating your data into a new configuration, I wouldn't do it in a single set as you're describing. Instead, break it apart and move only 100k rows at...

Assuming you're outputting to a file, you can just open the file and you'll be immediately viewing the live data. That may not be a lot easier, but it works.

ThomasRushton (11/21/2016)

---

Grant Fritchey (11/18/2016)

---

For the second time this year, I successfully got a Linux VM running with SQL Server on it. Last time I just did the install & walked...

I would only recommend this switch after an...

Ad Hoc:

SELECT * FROM Table;

If this is run from SQL Server Management Studio, Reporting Services, Integration Services, or through code from an app, it's ad hoc because it's not in...

For the second time this year, I successfully got a Linux VM running with SQL Server on it. Last time I just did the install & walked away. This time...

jasona.work (11/18/2016)

---

Grant Fritchey (11/18/2016)

---

jasona.work (11/18/2016)

---

So someone dug in to how MS has SQL2016 working on Linux[/url], only to find that *horrors* they're using essentially a containerization type solution. Just...

jasona.work (11/18/2016)

---

So someone dug in to how MS has SQL2016 working on Linux[/url], only to find that *horrors* they're using essentially a containerization type solution. Just enough Windows kernel...

Quest had a tool like that once upon a time. I think it's long been discontinued.

For testing the running of a procedure, it's not hard to write a quick PowerShell...

Two tools that I would suggest that can help with this (you're still going to have to do a lot of work to understand exactly what is being documented) are...

Yeah, you're recompiling all the plans after that runs. It might not be that big a deal. It really depends on your system, the code, all sorts of factors. Also,...

Ed Wagner (11/17/2016)

---

I didn't make it through the entire presentation, but I read the announcement - thank you for...

Another third party tool to check out is Minion Ware. They have a free version of an index management software that does a fantastic job of managing your indexes.

I'm not sure then.

I have never attempted to set up replication to Azure SQL DB. I suppose it will work since it's in the documentation. I'd strongly suggest testing it and setting it...