Category: Resources – SQL Server

How long until SSAS Tabular starts up? Real soon now, or maybe never!

How long until SSAS Tabular starts up? Real soon now, or maybe never!

This article is based on my experiences with SQL Server Analysis Services Tabular, together with large SSAS Databases (Cubes) – i.e. over 100Gb. Your experiences might differ, as “classic” SSAS works differently, and you may be lucky enough to be working with relatively small Databases. SSAS appears to start quickly When starting SQL Server Analysis…

Read More Read More

Troubleshooting additional SQL Server Components

Troubleshooting additional SQL Server Components

Today, I am introducing a series of articles on troubleshooting various components of SQL Server.   My experience has been largely with the SQL Engine (“proper” SQL Server), but there are so many additional products that have become part of SQL Server. They are available under the same licence and unfortunately, the expectation is that…

Read More Read More

T-SQL Tuesday #131: An Analogy

T-SQL Tuesday #131: An Analogy

This month, the T-SQL Tuesday invitation is from Rob Volk. Rob has asked for an Analogy that you use to describe concepts. This works well for me as I use analogies a lot, today I’ve gone with… “I drive the truck” I once put together a presentation on the subject of “what is a DBA”.…

Read More Read More

Query Plan says “Just do nothing”

Query Plan says “Just do nothing”

How many times do you ask someone to do something and get the response “I’m not doing that – there’s no point”. Turns out SQL Server does that sometimes too – as I was reminded recently.   After spending time examining query plans using SentryOne Plan Explorer, I was faced with the following improbable Plan…

Read More Read More

DataRelay 2019

DataRelay 2019

I had a great time on Friday at Data Relay in Bristol. This article is about what I learned. I have tried to include links, either to presentations, slides or just example of the speakers previous work. I will update with further links as and when I get them. Data Relay (formerly known as SQL…

Read More Read More

Azure Learning and my Learnings

Azure Learning and my Learnings

It’s no secret that I’m keen to investigate new technologies. While my job is almost completely related to “on premises” versions of SQL Server, I’m hugely interested in what the future brings. Learning about new technologies can be difficult without a project in mind or specific manufacturer training. Trawling through Youtube for training can be…

Read More Read More

Follow on Feedly

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close