Power BI: Refreshable Excel Files in PBI Service
Ever since Excel made its debut in the 1980’s, it has been used as a quick way for end users to input and manipulate data on their own without...
2024-05-14
7 reads
Ever since Excel made its debut in the 1980’s, it has been used as a quick way for end users to input and manipulate data on their own without...
2024-05-14
7 reads
This month is a great topic to me. I think growing and improving your career is a skill that most of us could improve, especially in our younger years....
2024-05-14
Once upon a time, I used to think of difficult technical questions to ask candidates for a DBA position. However, over time I came to understand that in most...
2024-05-14
2 reads
My blog has been quiet lately. I recently wrapped up a master’s program (more details on that soon, once the formal graduation is behind me) and have been immersed...
2024-05-14
5 reads
Picture this, your data ingestion team has created a table that has the sales for each month year split into different columns. At first glance, you may think “what’s...
2024-05-13 (first published: 2024-05-10)
28 reads
Another security fundamentals topic is authentication versus authorization. For those who have a clear understanding of the difference between the two, like with Recovery Point Objective (RPO) vs. Recovery...
2024-05-13 (first published: 2024-05-03)
39 reads
I did a post last month titled RTO and RPO are myths unless you've tested recovery, but I only briefly covered what RPO and RTO are. This post goes...
2024-05-13 (first published: 2024-05-10)
147 reads
In information security (INFOSEC), there several foundational concepts and principles. One of the ones that’s introduced almost immediately is called the CIA triad or the Information Security Triad. While...
2024-05-13 (first published: 2024-04-26)
186 reads
Introduction Full-Text Search in SQL Server is a feature that provides linguistic search capabilities against text data in SQL Server tables. It allows for searching of character-based data types...
2024-05-13
23 reads
Test Data Management (TDM) is essential in software development to ensure your application runs smoothly and reliably across different environments. When deploying applications in Azure, Test Data Management can...
2024-05-13
8 reads
By Steve Jones
This month is a great topic to me. I think growing and improving your...
By Brian Kelley
Once upon a time, I used to think of difficult technical questions to ask...
By DataOnWheels
Ever since Excel made its debut in the 1980’s, it has been used as...
Hello I need help on writing this query. This is what i need. I...
We've been testing out Azure SQL Managed Instance and created SSIS packages to run...
Greetings, I need to transform data returned in a query from several tables as...
If I want to enable a trace flag for a specific query, how do I do it?
See possible answers