Markus (6/20/2016)

---

I attended a Microsoft event about SQL 2016 and have read a lot of information about this new release. It does appear this is the best version yet....

Ivan Arjentinski (6/20/2016)

---

The dev effort is usually not simply for embracing the new features. Most of the dev effort is to keep our apps running and supporting both newer and...

roger.plowman (6/20/2016)

---

I would have thought the lack of a GO after the GRANT would have left permissions unchanged for the final SELECT. This is something I've run into with SQL...

Try fn_dblog

http://www.sqlskills.com/blogs/paul/using-fn_dblog-fn_dump_dblog-and-restoring-with-stopbeforemark-to-an-lsn/

http://www.sqlskills.com/blogs/paul/using-fn_dblog-fn_dump_dblog-and-restoring-with-stopbeforemark-to-an-lsn/

For both, you'll need to provide code. I'm not sure why #1 wouldn't return something without more detail.

For #2, are you sure this fires? I'd add logging code to your...

I agree with Scott. Don't worry about this.

Luis got it.

Essentially the online version of TFS. Has VCS, build, release, work tracking, etc. It's really slick, and I like it. It's the equivalent of TFS Server 2015 Update...

Well, my navigations through the world of VSTS are complete, or at least, working.

As much as I like the system, finding information and understanding exactly what's happening is hard. I...

chris 24158 (6/17/2016)

---

The latest series of posts you enjoy so much from Microsoft says:

I can’t emphasize this patch enough. There is a MSVC, runtime library patch needed by...

Start here: http://www.sqlservercentral.com/stairway/110890/

It's not really query and find the data, it's automatic partitioning, moving data to another instance of SQL Server. There's a difference, and it's a valuable tool to have.

I just...

Do you mean just have Firstname in the query without knowing it's below Recipient/Customer?

No. The path is the path. In the Nodes, you've set the top level for that...

XML is case sensitive.

This should help you get moving

SELECT

t.b.value('(MsgID)[1]', 'NVARCHAR(1000)') AS MSGID

, t.b.value('(MsgTime)[1]', 'NVARCHAR(1000)') AS MsgTime

,...

GSquared (6/15/2016)

---

This can turn into a complex question. The rule-of-thumb that I try to follow on things like this is: The more clever the solution has to be, the...

Yes and no. I'll be doing some content here to explain how this works and how you can use it, but I'd encourage you to play with it in a...