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…
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…
Why use Linked Servers with SQL Server Analysis Services? One way of connecting to a SQL Server Analysis Services (SSAS) Server is using a Linked Server. My initial use of a Linked Server for SSAS was to create a script to loop through all of the Databases on the Server, performing the same action on…
Recently, I made a decision to sort out all of the storage that I have. A box full of old hard drives – from broken PCs or leftover from upgrades. These drives contain photos and videos together with backups galore, but no real way of telling what is held where, and certainly no backup strategy…
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…
T-SQL Tuesday was started some time ago by Adam Machanic whereby lots of people blog their thoughts on a common topic. Month #132 is hosted by Taiob Ali. This month we will share how each of us is coping with a global pandemic. These subjects are in no particular order, written in a rush without time…
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…
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”.…
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…
An issue was reported with one of my SQL Servers that required it to be rebooted. After the reboot, I logged on to SQL Server Management Studio (SSMS) to check the SQL ErrorLog to ensure that all was well. Unfortunately, I was met with an error when I tried to open the ErrorLog: “Failed to…
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.