SQL Server Quickie #42 – Recovery Model FULL
Today I have uploaded SQL Server Quickie #42 to YouTube. This time I’m talking about the Recovery Model FULL in SQL Server. Thanks for your time, -Klaus
SQLServer
First steps with SQL Server on Linux
As you might know, a few weeks ago Microsoft released the first public CTP version of SQL Server that runs directly on Linux! Therefore it was time for me to cross the bridge and install my first ever Linux installation so that I could play with SQL Server on it. In this blog post I …
SQL Server 2016 SP1 Standard Edition = Enterprise Edition!?
Last week Microsoft made a historic announcement regarding SQL Server: with the introduction of the Service Pack 1 the Standard Edition of SQL Server offers you the same features as the Enterprise Edition. You don’t trust me? Just look here. This changes the whole game in the market for relational databases and is mostly a …
SQL Server 2016 SP1 Standard Edition = Enterprise Edition!? + read more
Why the Recovery Model SIMPLE is a really bad idea
A few weeks ago one of my blog readers asked in a comment if it is a good idea to set the Recovery Model of the model database to SIMPLE, and if there are any downsides of that approach. I can’t emphasise it enough, but using the Recovery Model SIMPLE for a OLTP workload (which …
Why the Recovery Model SIMPLE is a really bad idea + read more
SQL Server Quickie #41 – Recovery Mode SIMPLE
Today I have published SQL Server Quickie #41 on YouTube. This time I’m talking about the Recovery Mode SIMPLE in SQL Server. Thanks for your time, -Klaus
