Microsoft SQL Server Database Engine
First seequality session is behind us! We spoke about query plans – i hope you enjoy. Below i attached my presentation for the session. In next week or two i try to upload video that i recorded during the session…
Read more
I have never have a requirements to remove the SQL Server Analysis Services instance before, up to yesterday. When i faced up with removing the SSAS instance for the first time i didn’t know that this is not so easy. I…
Read more
It is very common scenario when we want to create temporary or standard table based on TSQL statement. If we want to achieve something like this we can use SELECT INTO FROM syntax. It has very interesting feature – it…
Read more
Few days ago I have faced up with a problem during publishing the database project created in Visual Studio 2012 for SQL Server 2014 directly from windows command line. I am not the only one that got the error Deploy72002 error. You can…
Read more
Have you ever tried to concatenate few fields? in most cases your result was null? It is default behaviour of SQL Server because NULL value cannot be compared with any type of data. Sometimes we need to change this behaviour…
Read more
{:en}Today I would like to write few words about SQL Servier Services. This topic is quite easy but some people doesn’t know basic things about services. We can manage services with two simple administration tools: Windows Services SQL Server Configuration…
Read more