Introduction While I’ve been a regular attendee at SQL Bits (going back to the original conference in 2007), this year I did something different. This was my first time volunteering – becoming a SQLBits Helper. I’m lucky to already know some people who are experienced SQLBits Helpers. They helped me out by answering some…
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 Gethyn Ellis (b|t) who is asking us to share the “best piece…
In the cloud, no one can hear you scream! Have you ever accidentally locked yourself out of a Server by reverting to default settings on Windows Firewall? I haven’t done it personally, but I’ve seen how much of an issue that it can be. It’s easily done. When making changes in Windows Defender Firewall,…
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…
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.