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, lots of people blog their thoughts on a common topic. This month’s T-SQL Tuesday is all about the use of dynamic SQL. I use Dynamic SQL a lot…
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…
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…
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…
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.