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 Access from your Applications to Azure SQL explain private endpoints from different points of views: Azure SQL and Function A …
Your Teammates Need the Fundamentals.
You’ve been reading my site for a while, watching videos, keeping up with the best SQL Server techniques. However, you’ve got a lot of other folks on your team who don’t have as much free time as you, or they’re just getting sta …
SQL Server Plan Cache Bloat Performance Impacts
The post SQL Server Plan Cache Bloat Performance Impacts appeared first on SQLServerCentral.
Using ChatGPT for T-SQL Code Reviews
For this month’s T-SQL Tuesday, Pinal Dave asked us if AI has helped us with our SQL Server jobs. For me, there’s been one instant, clear win: code reviews. I usually keep a browser tab open with ChatGPT 4, and I paste this in as a starting …
Using Common Table Expressions: Transforming and Analyzing Data in PostgreSQL, Part 2
In the first article in this transforming data series, I discussed how powerful PostgreSQL can be in ingesting and transforming data for analysis. Over the last few decades, this was traditionally done with a methodology called Extract-Transform-Load ( …
Giving Feedback on Microsoft Data Platform Tools
As a data professional, there is a set of tools that you use on pretty much a daily basis. Before I started as the editor of Simple-Talk, there were two Microsoft tools I used every day of the work week, and also for my hobby work: SSMS (SQL Server Man …
Joining Queries in Azure Data Factory on Cosmos DB Sources
This article illustrates how to join two queries using ADF (Azure data factory). Prerequisites First, prepare your data sources. Make sure you have at least two data sources (such as tables, files, or databases) that you intend to join together. Additi …
SQL Server Patching Using PowerShell DSC
Introduction In the previous article we have seen how to install SQL Server Management Studio (SSMS) using PowerShell DSC. In this article, we will explore how to use PowerShell Desired State Configuration (DSC) to automate the patching process for SQL …
Introduction to Python including Installation, Jupyter Notebooks and Visual Studio Code
The post Introduction to Python including Installation, Jupyter Notebooks and Visual Studio Code appeared first on SQLServerCentral.
[Video] Office Hours: Just Three Questions
Sometimes y’all post questions at https://pollgab.com/room/brento that require extended answers. Today, I’m hitting just 3 questions: Here’s what we covered: 00:00 Start 00:44 MyTeaGotCold: If storage is no issue, do I need to worry a …
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 load the data daily, with all th …
Who’s Hiring in the Microsoft Data Platform Community? April 2024 Edition
Is your company hiring for a database position as of April 2024? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must incl …
Use Fabric Data Factory to Load Data From a CSV File in Azure Blob Storage to Azure SQL DB
The post Use Fabric Data Factory to Load Data From a CSV File in Azure Blob Storage to Azure SQL DB appeared first on SQLServerCentral.
Building MongoDB Aggregations in MongoDB Compass
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the items in the series, click here. In the previous article in this series, I demonstrated how to build and run an aggregate statement in MongoDB Shell. An aggregate …
Announcing Fundamentals Week, May 6-10
You’ve attended some of my free online streams, read my blog posts, and you use the First Responder Kit. You enjoy my laid-back, humorous approach to sharing what I’ve learned over the years. You love live classes. You’ve tried watchi …