Tag Archives: microsoft sql server

Joys With Datetimes

Sometimes we need to generate current timestamp in a special format (e.g. suffixes for backup files). If we are unlucky that requested format is not supported by CONVERT function and SQL Server version is 2008 R2 and older this might … Continue reading

Posted in Microsoft SQL Server | Tagged , , , , | Leave a comment

T-SQL vs. MDX

Although MDX has some similarities with T-SQL these languages are in many ways different. MDX is an acronym for MultiDimensional expression. Nowadays MDX is implemented in many non-Microsoft analytical platforms. Like T-SQL MDX in SQL Server has two usages: Expression … Continue reading

Posted in Microsoft SQL Server | Tagged , , | Leave a comment

Integration Services Data Feed Publishing Components

First time I heard of Data Feed Publishing Components was at PASS summit this month. I was immediately interested in this new component. It basically allows you to hide SSIS complexity and overhead from your users by exposing data through … Continue reading

Posted in Microsoft SQL Server | Tagged , , , , , | 2 Comments

When stored procedure slows down

This post will be about stored procedure that began to slooooow down. Background info I came across a datamart with ETL loading processes last year. Both of those were very poorly written (Currently after my changes it is a little … Continue reading

Posted in Microsoft SQL Server | Tagged , , , | 2 Comments

How to be a good SQL Consultant

Sometimes I wonder whether I am doing my best. As a consultant I am always facing something new or unexplored. Therefore I must keep myself up to date with: SQL authorities I am following Brent Ozar and SQL skills. Theirs … Continue reading

Posted in Microsoft SQL Server | Tagged , | 1 Comment

SQL Server does not start with %%17051 error

SQL Server might not start from all variety of reasons including permission issues, master database not available or corrupted, service account issues, etc. In this article I will talk about diagnose of failed service start and how to fix %%17051 … Continue reading

Posted in Microsoft SQL Server | Tagged , , , | 9 Comments

Microsoft SQL Server Myth #2

Shrinking your transaction log makes your backups smaller. FALSE

Posted in Microsoft SQL Server Myths | Tagged , , , , | 2 Comments