Power BI Auto Detect Relationship Failure
Power BI doesn't always detect relationships, and this article explains a bit about the problem.
2024-03-11 (first published: 2024-03-08)
1,353 reads
Uncategorized
Evolving Role of Data Professionals in Artificial Intelligence Era
Generative Al tools like Gemini and GPT promise to automate and augment knowledge-based work. Data professionals must adapt to this transformation by acquiring new skills and playing a central role in their organization's AI-driven future. Data preparation, curation, ethical sourcing and labeling, and collecting user feedback become crucial as high-quality data is essential for effective LLM based application.
2024-03-04
2,711 reads
What Every DBA Should Know about Always On Readable Secondaries
Learn a bit about the impact of readable secondaries, which you might not expect.
2024-02-23
5,879 reads
Redgate Summit: The Database Landscape
A series of Redgate events across the globe for data professionals who want to improve their skills and knowledge about Database DevOps, learn about moving to the Cloud, AI, and working across multiple databases. Redgate Summit aims to bring together database professionals who want to level-up their skills to navigate the increasingly complex database landscape. Learn more about emergent technologies, and reliably solve the complex challenges of database management across the entire DevOps lifecycle. Each event will all feature three separate tracks covering New and Future Technologies, Deep Dive Solutions, and Leadership, all promising to equip senior database professionals with the tools and insights needed to navigate the intricate landscape of 2024.
2024-02-23
Query Exercise: Improving Cardinality Estimation
Your challenge for this week is to tune a query. Say Stack Overflow has a dashboard that shows the top-ranking users in their most popular location. It’s even got an index to support it
2024-02-16
Attention SQLBits 2024 Attendees!
Microsoft will be featured at SQL Bits with a keynote speaker, a full day of training and a few other sessions. Register today for the conference in March and we hope to see you there.
2024-02-14
1,254 reads
Implementing functions and more fun in Spark Connect using gRPC and .NET
All Spark Connect Posts
Code
Goal of this post The goal of this post is to look at creating a SparkSession and a DataFrame that will wrap the Range relation and...
2024-02-10
41 reads
The Birth of Computing Was the Birth of Testing
Last year I had the most wonderful opportunity. I took part in Data Relay, an event in the UK which tours several cities. Wonderful time, but not the focus here. The very first one was held at the National Museum of Computing at Bletchley Park. Without a doubt, you've heard of Alan Turing, Enigma, and […]
2024-02-10
81 reads
Moving towards the DataFrame API using the Spark Connect gRPC API in .NET
All Spark Connect Posts
Code
Goal of this post So there are two goals of this post, the first is to take a look at Apache Arrow and how we can...
2024-02-05
90 reads
Resolving the MERGE statement attempted to UPDATE or DELETE the same row more than once error
I'm receiving the following error when attempting to run a T-SQL MERGE statement: "Msg 8672, Level 16, State 1, Line 123. The MERGE statement attempted to UPDATE or DELETE the same row more than once. This happens when a target row matches more than one source row.
2024-02-05
Blogs
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers