T-SQL Tuesday #153 – The Conference That Changed Everything For Me

T-SQL Tuesday #153 – The Conference That Changed Everything For Me

Introduction T-SQL Tuesday is the blog party started by Adam Machanic (b|t) over a decade ago and is now maintained by Steve Jones (b|t) on tsqltuesday.com. Each month, ots of people blog their thoughts on a common topic. Month #153 is hosted by Kevin Kline with the topic of “The Conference That Changed Everything For…

Read More Read More

SQLBits 2022 – London

SQLBits 2022 – London

I went to SQLBits 2022 last week, returning with feelings of joy, inspiration, a cold and a swollen ankle! Here follows a long rambling essay about my experiences, peppered with a collection of random photos from random people. I learned loads at SQLBits, from a technical perspective, I picked up a lot of knowledge but…

Read More Read More

EXCEPT Operator Troubles (RowGoal)

EXCEPT Operator Troubles (RowGoal)

Sometimes, queries just go bad. They can take you on a Journey. Not always a Journey that you want to go on, but so long as you’re learning then “The Journey is the reward”. I’ve seen a lot of queries recently that use the EXCEPT operator. Frequently used in Data Warehouses to process Slowly Changing…

Read More Read More

SSAS – Force into loading Databases

SSAS – Force into loading Databases

When the SQL Server Analysis Services (SSAS) Tabular Service is started, it can take a long time before it is ready to be queried. This can cause delays to Service, not to mention confusion. This Blog Post will explain what is happening during this time and a method that can be used to improve. It’s…

Read More Read More

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

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