SQLBits 2023
Super excited that I was selected to speak at SQLBits 2023. The conference is taking place 14-18 March 2023 in Wales. I have never been to Wales and am...
2023-01-06 (first published: 2022-12-23)
233 reads
Angela
- Website: https://sqlswimmer.com/
- LinkedIn: https://www.linkedin.com/in/angelahenrydba
Unable to Validate Source Query in Tabular Editor
I recently encountered the error, “Unable to validate source query” when trying to refresh the metadata for the tables in my tabular model using Tabular Editor. I immediately googled...
2022-03-14 (first published: 2022-02-22)
170 reads
Power BI Learning Opportunity at SQLBits
If you’ve been thinking about learning Power BI, I have a wonderful opportunity for you. I will be presenting, along with my friend and colleague Michael Johnson (Blog |...
2022-02-24
12 reads
Bits Buddies
SQLBits is fast approaching, in fact, Training Days start 2 weeks from today, on March 8, 2022. I’ve attended SQLBits before, as well as other large conferences, but I...
2022-02-22
20 reads
I Still Can’t Believe It!
I received my MVP award letter from Microsoft today. This will make the fourth time I’ve been awarded and I still can’t believe it. I just wanted to help...
2021-07-01
20 reads
Data Saturday #8–Southwest US
I am very excited to announce that I will be speaking for Data Saturday #8 – Southwest US, coming up on Saturday, May 15, 2021. I will be delivering...
2021-05-08
10 reads
Data Weekender v3.1
I am super excited about this new version of Data Weekender, coming up on Saturday, May 15, 2021. This will be the third time I have been selected to...
2021-05-08
15 reads
It’s Not Horrible, It’s Just Very Sad
This is a non-technical post, but a necessary one for me. If you’re only interested in technical content, that’s okay, you can stop reading, I won’t be offended (heck,...
2020-08-25
39 reads
When Your Azure Data Catalog App Won’t Connect
This year I created a new presentation for introducing Azure Data Catalog. I love this product and think it has so much potential and everyone should be using it! ...
2020-06-15 (first published: 2020-05-26)
209 reads
I’m Speaking at #SQLSatBrisbane
I’ve always wanted to go to Australia, in fact we have a trip planned for Martin’s 60th birthday in a couple of years. But with all that’s happened in...
2020-05-18
49 reads
Blogs
AI Step 1
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
Beginner’s Guide: Building a Dockerized Todo App with React, Chakra UI, and Rust for Backend
In a containerized app, React and Chakra UI provide a robust and accessible user...
A New Word: Nachlophobia
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
Forums
Call dynamic sql storedprocedure from SSIS execute sql task
hi, I have a table called Rules Create table Rules ( Id int ,...
Migrating database with many orphan users.
I am currently upgrading a very old database running SQL Server 2008 to SQL...
Active and Active Cluster
Hi Team, I am planning to apply security updates for SQL Server 2016 on...
Question of the Day
The Funny SELECTs
What is returned from this query?
SELECT
( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate > '01/01/2011' AND soh.OrderDate < '01/01/2012') AS OrdersIn2000
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate > '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2001
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate > '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2002; See possible answers