parkrun, for the uninitiated, is a free, friendly organised 5k run that takes place on a Saturday morning at 9:00. It’s not a race, but it is timed and you will get a result, so long as you’ve registered once with parkrun and you take along your Barcode. While SQLBits delegates are unlikely to want…
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 from Raul Gonzalez (b|t) who is asking us to reveal all about our use…
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…
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.