Dennes Torres in Blogs The signs of a new era: Prompt Injection More than 20 years ago, I wrote a book about SQL Injection and how dangerous it can be. Probably you... 05 June 2024 2 min read
Louis Davidson in Blogs Powershell and SQL on the River We are having a conference in Chattanooga, TN on Aug 16 and 17, the primary topics of which are clearly... 01 June 2024 2 min read
Dennes Torres in Blogs Purview and Microsoft Fabric: Better Together Microsoft create Purview, a data governance solution. Since Microsoft Fabric was in preview, there was a promise of a deeper... 29 May 2024 2 min read
Blogs Dennes Torres in Blogs The Evolution of Time Travel in Fabric Data Warehouse The May Microsoft Fabric updates bring new about Time Travel in a Data Warehouse. This is good but surprising because... 24 May 2024 3 min read
Blogs Dennes Torres in Blogs Workspace Identity and Resource Instance Rules: More than simple features Sometimes, when a new feature is announced, it’s in fact hiding bigger changes on the entire environment. This is exactly... 22 May 2024 3 min read
Dennes Torres in Blogs Data and SaaS : Who owns your company’s Data? On the era of SaaS, I see many companies hiring a lot of SaaS services. They create a dependency on... 15 May 2024 2 min read
Blogs Louis Davidson in Blogs T-SQL Tuesday #174: Your Favorite Job Interview Question? T-SQL Tuesday is something I don’t participate in nearly enough. When I saw Kevin Feasel’s invitation for this months topic,... 14 May 2024 8 min read
Blogs Dennes Torres in Blogs Edit The JSON of a Fabric Pipeline A Fabric Pipeline uses JSON as source code. They are also saved in repositories as JSON. We first idea we... 08 May 2024 1 min read
Blogs Dennes Torres in Blogs PySpark Secrets to use with Fabric PySpark is a powerful language for data manipulation and it’s full of tricks. Let’s discover some of them. Control the... 30 April 2024 3 min read
Blogs Dennes Torres in Blogs 4 Reasons to use KustoDB for Real-Time When implementing real-time ingestion, we usually implement an architecture called lambda. Using the lambda architecture, KustoDB in Microsoft Fabric is... 23 April 2024 2 min read
Ben Johnston Building a Culture of Data: The Technical Aspects In the first part of this two-part series, I covered the mostly non-technical aspects of building a data culture. While... 19 April 2024 13 min read
Blogs Dennes Torres in Blogs Exploration Experience: Saving and Creating Datasets I have been talking about Data Exploration in Power BI on many of my sessions, specially the sessions about Data... 17 April 2024 2 min read
Blogs Dennes Torres in Blogs Azure OpenAI and RAG Security The most watched videos on my youtube channel are related to security. Azure SQL Networking Secrets and Cloud Security: Secure... 10 April 2024 3 min read
Ben Johnston in Culture Building a Culture of Data One of the major trends in enterprise computing, and really in enterprises themselves is an increased emphasis on data. My... 04 April 2024 19 min read
Blogs Dennes Torres in Blogs Dynamic Partitioning and a Simple Incremental Load Let’s consider a simple statement for partitioning and save a table in a lakehouse: df.write.mode("overwrite").format("delta").partitionBy("Year","Month","Day").save("Tables/" + table_name) Let’s consider we... 03 April 2024 2 min read
Blogs Dennes Torres in Blogs Creating a Single JSON File for Configuration using Notebooks On the blog Fabric Notebook and Deployment Pipelines I explained a technique to keep notebooks configuration values in JSON files... 27 March 2024 2 min read
Blogs Louis Davidson in Blogs Lies you should believe: There are no dumb ideas When I was a brainstorming ideas for a series of posts, it took me back to a brainstorming session we... 22 March 2024 3 min read
Blogs Dennes Torres in Blogs Model Optimization: Available In MDX Property Power BI Semantic Models have a property called Available In MDX. Each field in the model has this property and... 20 March 2024 3 min read
Blogs Sheila Romans in Blogs The Benefits of Volunteering at SQL Saturdays How it all started After attending PASS Summit in 2022 my husband set a goal to speak at as many... 14 March 2024 5 min read
Blogs Dennes Torres in Blogs 5 Secrets about Dataflows Gen 2 Dataflows Gen 2 are the new version of Power BI dataflows. There are so many changes in relation to the... 13 March 2024 5 min read