As you might know, Microsoft announced a few weeks ago that they will release a fully working SQL Server product on Linux! If you want to see how SQL Server on Linux works, and how it feels to run queries against it, please checkout the following video, which was published 2 weeks ago on Channel […]
SQL Server on Linux – first preview! Read More »
Today I have uploaded SQL Server Quickie #36 to YouTube. This time I’m talking about Cross Joins in SQL Server. [viral-lock message=”Like or share to get the source code.” tweet=”SQL Server Quickie #36 – Cross Joins by @Aschenbrenner:” url=”https://www.SQLpassion.at/archive/2016/06/07/sql-server-quickie-36-cross-joins”]You can find the script used during the demonstration here as a download.[/viral-lock] Thanks for your time, -Klaus
SQL Server Quickie #36 – Cross Joins Read More »
I have already blogged a few times about In-Memory OLTP and why I don’t yet recommend this technology currently to my customers. Today I want to talk a little bit more about the memory requirements behind In-Memory OLTP, and what happens if you have too little memory. It’s all about Memory! We all know that
In-Memory OLTP and too less Memory Read More »
A few weeks ago I released a SQL Server Quickie about Crash Recovery in SQL Server. There was one interesting comment about whether the Recovery Model of the database influences Crash Recovery and if you would lose transactions in the Recovery Model Simple. Therefore I want to take this point today and talk in more
Crash Recovery & Recovery Models Read More »
Time goes by, and today I’m very proud to announce all upcoming SQLpassion workshops for fall 2016: SQL Server Query Tuning Workshop November 7 – November 11 in Utrecht/Netherlands SQL Server Performance Tuning Workshop October 31 – November 4 in Copenhagen/Denmark November 21 – November 25 in Zurich/Switzerland November 28 – December 2 in Frankfurt/Germany
SQLpassion Workshops in Fall 2016 Read More »
