The Issue Recently one of our team members faced the following issue: We have SSAS Tabular model deployed in DirectQuery mode taking data from MSSQL server database. Suddenly SSAS...
2022-04-04
4 reads
Ve středu 9.3.2022 jsme se tradičně sešli nad novinkami ze světa dat, datových skladů, Power BI, Azure apod. Jestli jste chyběli (ale příště dorazíte, že? :D), zde je malý...
2022-04-04
1 reads
Two years ago at the start of the pandemic, I wasn’t feeling great about things. I saw that quite a few others weren’t all that thrilled about how things...
2022-04-04
29 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-04-01
20 reads
Have you ever needed to set a property or field to the last day of the month? This is a common business problem that can
2022-04-01 (first published: 2022-03-25)
395 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Lots of people have never worked with LocalDB,...
2022-04-01 (first published: 2022-03-28)
204 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-03-31
9 reads
This blog pos illustrates how Azure Data Explorer and Azure Synapse Analytics complement each other for near real-time analytics and modern data warehousing use cases. This solution is already...
2022-03-31
32 reads
In the previous blog post we created an Azure Data Explorer (ADX) cluster. In this blog post we will create a database that we will ingest data into, as...
2022-03-31
57 reads
I have written a lot about the magic of KQL and the brilliance of Azure Data Explorer. Now we should create a cluster of our own that hosts Azure...
2022-03-31
10 reads
In a containerized app, React and Chakra UI provide a robust and accessible user...
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
Have you ever wondered where a certain field is used in a report? Or...
Comments posted to this topic are about the item Lies You Should Believe -...
Comments posted to this topic are about the item A Strange Query
Hello, I am having database primary and secondary filegroup. Few tables/indexes are partitioned on...
What does this return?
SELECT x=1 WHERE (SELECT 1) IN ( 1, 2, 3)See possible answers