Tag Archive: SQL Server

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

There is a lot of post and signals that we shouldn’t use the “SELECT *” in the production code. You can easily find a good articles: here is one of them. I would like to wirte about one more things…Read more

In many scenarios developers must deal with many cubes in the same project and share dimensions between them. It’s easy to set up something like this but try to imagine situation when one cube musts be browsed by fiscal dates…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