Hmm, I was looking at the documentation here: https://msdn.microsoft.com/en-us/library/mt694156.aspx, which under the "How In-Memory OLTP features work so much faster" section has a subsection for Less...

I like that question a lot, keep them coming Marek!

Will DBCC TRACESTATUS really show other users' session-based trace flag?  The documentation reads to me that you will only see global or your session's trace flags.

I believe another way to do this is with Redgate's free SQL Search tool.  I regularly use this tool if I need to change something and I am unsure of...

Just considering the backup piece, I feel like this could lead to problems.  Right now we use instance level backup jobs which loop through all the databases sequentially and back...

You can also start up SQL Server using the -T3608 and -T3609 flags, then open SQLCMD and run the ALTER DATABASE tempdb MODIFY FILE...

What really sucks is when you're supporting a mess that is a back-end for third party software. You are powerless to fix any of the code and are limited...

That's pretty crappy documentation on Microsoft's part. I also found the answer on https://msdn.microsoft.com/en-us/library/hh231286.aspx, where it shows the example as

#Import the SQL Server Module. ...

GO 2

I've actually never seen this before, never knew you could tell it how many times to execute.

Oh, I missed the part about this being SQL Server 2016. When I run this on our 2008 R2 instance, I get:

Msg 1018, Level 15, State 1, Line 5

Incorrect...

You can easily put a StartDate and EndDate (as well as a current flag) into what you call the traditional row model of a data warehouse. I can't imagine...

The real question here is whether Prescott should continue starting for the Cowboys after Romo comes back from his injury. If you're the Cowboys, I think you trade Romo...

Good to see a DAX question. I'm getting into some Power BI development here at work and I've got to say, it can be quite confusing.