Devising the Perfect Index for Your Use Case – MySQL ...Introduction If you’ve been following SimpleTalk for a while, you will be aware that I’ve recently blogged […] 11 septembre 2024 dans Sites anglophones étiqueté B-Tree Indexes / Blogs / Clustered Index / Composite Index / covering index / Databases / Descending Index / Fulltext Indexes / Hash Index / MariaDB Server / MySQL / MySQL Database / MySQL Server / Percona Server / Spatial Indexes / SQL Index / Unique Index par simple-talk.com
What Did AI Ever Do for Me?Let me start with a simple confession, and I hope it’s not too shocking for anyone; I’m […] 9 septembre 2024 dans Sites anglophones étiqueté AI / Blogs / Conferences / Editorials / General / PGConf / PGConfEU par simple-talk.com
Microsoft Fabric and PySpark: Coding tricks to improve your solutionsPySpark has some unconventional syntaxes which provide power to the development process, making it easier. We talked […] 4 septembre 2024 dans Sites anglophones étiqueté Blogs / development / Microsoft Fabric / notebook / PySpark / Python par simple-talk.com
Choosing Data Types and Column OptionsAn entire post on choosing the correct data types either seems like overkill or much needed and […] 31 août 2024 dans Sites anglophones étiqueté Architecture / Back to Basics / Blogs / Data Types / Design par simple-talk.com
The Big IT Outage: Where are we going?As you all know about, just a few weeks ago we had the big CrowdStrike global IT […] 28 août 2024 dans Sites anglophones étiqueté Blogs / Opinion par simple-talk.com
Auditing SQL Server – Part 4 – Database Configuration AuditThis continues my series on auditing SQL Server. The fist parts covered discovery and documentation, server level […] 20 août 2024 dans Sites anglophones étiqueté audit / benJohnston_Audit / Blogs / Database par simple-talk.com
Thoughts Before Speaking at the Software Architecture ConferenceTomorrow, August 15, I have yet another conference where I’ll speak about MySQL’s performance. To be more […] 14 août 2024 dans Sites anglophones étiqueté Blogs / books / Database Administration / Databases / Hacking MySQl / MySQL / Software Architecture Conference / Speaking par simple-talk.com
Auditing SQL Server – Part 3 – SQL Server Configuration Audit This is the continuation of my […] 25 juillet 2024 dans Sites anglophones étiqueté audit / benJohnston_Audit / Blogs / Configuration / SQL Server par simple-talk.com
Auditing SQL Server – Part 2 – Hardware AuditThis is the second part of my series on auditing SQL Server. In the first part, I […] 17 juillet 2024 dans Sites anglophones étiqueté audit / Azure / benJohnston_Audit / Blogs / SQL Server par simple-talk.com
T-SQL Tuesday #176 Roundup of adviceThere was a lot of great advice, and I really wonder how much of this I would […] 16 juillet 2024 dans Sites anglophones étiqueté Blogs / Opinion / TSQL Tuesday par simple-talk.com
T-SQL Tuesday #176: One piece of advice you wish Past ...After so many years, here in July 2024, I am finally hosting T-SQL Tuesday. The challenge One […] 2 juillet 2024 dans Sites anglophones étiqueté Blogs / Career / Professional Development / TSQL Tuesday par simple-talk.com
Auditing SQL Server – Part 1 – Discovery and DocumentationInheriting a server, whether as an inexperienced user or an experienced DBA, has many challenges. It’s very […] 6 juin 2024 dans Sites anglophones étiqueté Azure SQL Database / Blogs / SQL Server / sql server auditing par simple-talk.com
The signs of a new era: Prompt InjectionMore than 20 years ago, I wrote a book about SQL Injection and how dangerous it can […] 5 juin 2024 dans Sites anglophones étiqueté AI / Azure / Blogs / co-pilot / Large Language Model / openai / System Prompt / User Prompt par simple-talk.com
Powershell and SQL on the RiverWe are having a conference in Chattanooga, TN on Aug 16 and 17, the primary topics of […] 1 juin 2024 dans Sites anglophones étiqueté Blogs par simple-talk.com
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 […] 14 mai 2024 dans Sites anglophones étiqueté Blogs par simple-talk.com
PySpark Secrets to use with FabricPySpark is a powerful language for data manipulation and it’s full of tricks. Let’s discover some of […] 30 avril 2024 dans Sites anglophones étiqueté Blogs / Microsoft Fabric par simple-talk.com
Building a Culture of Data: The Technical AspectsIn the first part of this two-part series, I covered the mostly non-technical aspects of building a […] 19 avril 2024 dans Sites anglophones étiqueté Blogs / Culture / Data culture / Homepage par simple-talk.com
Exploration Experience: Saving and Creating DatasetsI have been talking about Data Exploration in Power BI on many of my sessions, specially the […] 17 avril 2024 dans Sites anglophones étiqueté Blogs / Data Exploration / Microsoft Fabric / Power BI par simple-talk.com
Azure OpenAI and RAG SecurityThe most watched videos on my youtube channel are related to security. Azure SQL Networking Secrets and […] 10 avril 2024 dans Sites anglophones étiqueté Azure / Blogs / openai / Security par simple-talk.com
Dynamic Partitioning and a Simple Incremental LoadLet’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) […] 3 avril 2024 dans Sites anglophones étiqueté Blogs / lakehouse / Microsoft Fabric par simple-talk.com
The Benefits of Volunteering at SQL SaturdaysEditor note: The call for volunteer and speakers is open at on the Pass Data Community Summit […] 14 mars 2024 dans Sites anglophones étiqueté Blogs / Career par simple-talk.com
Reverse Creating the PBIP file from Source ControlOn my article about Source Control with GIT, Power BI and Microsoft Fabric, I illustrate how to […] 6 mars 2024 dans Sites anglophones étiqueté Blogs / Git / Microsoft Fabric / Power BI / Source Control / Uncategorized par simple-talk.com
Friendly Deletes in SQL ServerOne of the first things you learn when working with SQL Server, and other transactional based SQL […] 1 mars 2024 dans Sites anglophones étiqueté Blogs / DELETE Statement / Performance / SQL Server par simple-talk.com
Feature Flags in Data ProjectsMy motivation for writing this summary was an interaction with a project owner that didn’t understand why […] 1 février 2024 dans Sites anglophones étiqueté ADF / Blogs / CI/CD / Feature Flags / Power BI / SSIS / SSRS par simple-talk.com
Adding a new AI usage policy to Simple-TalkI used to think plagiarism was my worst thing to deal with as an editor. That is […] 26 janvier 2024 dans Sites anglophones étiqueté Blogs par simple-talk.com
Working on Technology Off the ClockI have always spent time learning relational databases on my own, non-work time. As the years have […] 16 janvier 2024 dans Sites anglophones étiqueté Blogs / Editorials par simple-talk.com
Semantic Model: More than a Simple Name ChangeThe animation on the top of this article tries to track the evolution of the enterprise architecture […] 10 janvier 2024 dans Sites anglophones étiqueté Blogs / Data Warehouse / lakehouse / Microsoft Fabric / Power BI / Semantic Model par simple-talk.com
Being A Bit Less Comfortable in 2024I hate coming up with ideas for editorials, but my last editorial of the year gives me […] 3 janvier 2024 dans Sites anglophones étiqueté Blogs / Editorials par simple-talk.com
Warehouse Load Patterns – Part 2 – Load PatternsThis continues and finishes my two-part series on warehouse load patterns. There are many methods to transfer […] 31 décembre 2023 dans Sites anglophones étiqueté BenJohnston_ETL / Blogs / ETL / load patterns par simple-talk.com
Fabric Notebooks and Deployment PipelinesOn my article about Fabric source control extended features, I explained how Microsoft included the notebooks on […] 13 décembre 2023 dans Sites anglophones étiqueté Blogs / data platform / Deployment Pipelines / Microsoft Fabric / notebook / Power BI par simple-talk.com
SQL Server: Optimize for Ad Hoc Workloads – use or ...I used to believe this option was something almost absolute: it should be enabled as best practice. […] 6 décembre 2023 dans Sites anglophones étiqueté Blogs / optimization / SQL Server par simple-talk.com
Microsoft Fabric: Extended Source Control FeaturesThe source control features in Microsoft Fabric are evolving every day. The PBIP feature included in Power […] 29 novembre 2023 dans Sites anglophones étiqueté Azure DevOps / Blogs / Git / Microsoft Fabric / Power BI par simple-talk.com
Warehouse Load Patterns – Part 1 – Requirements and General ...No matter the ETL tool used, there are some basic patterns to follow when transferring data between […] 26 novembre 2023 dans Sites anglophones étiqueté Blogs / Data Warehouse / ETL / requirements analysis par simple-talk.com
Updates about Database Projects for Microsoft Fabriccomp A few weeks ago, I wrote a blog about Database Projects for Microsoft Fabric. It’s an […] 26 novembre 2023 dans Sites anglophones étiqueté Azure Data Studio / Blogs / Data Warehouse / Database Project / Microsoft Fabric par simple-talk.com
Back home from the PASS Data Community SummitWhat a week it was. While it wasn’t my first in person conference this year, it felt […] 21 novembre 2023 dans Sites anglophones étiqueté Blogs / PassDataSummit2023 par simple-talk.com
PASS Summit 2023 – Community Keynote – AIOps and ChatGPT ...Last but not least, the Community Keynote. Hang on to your hats, this is going to be […] 17 novembre 2023 dans Sites anglophones étiqueté Blogs par simple-talk.com
PASS Summit 2023 – Redgate Keynote – The New Database ...Day 2 is here! Sitting here at the bloggers table waiting for the keynote to commence! <image […] 16 novembre 2023 dans Sites anglophones étiqueté Blogs par simple-talk.com
PASS Summit 2023 – Microsoft Keynote – Limitless growth, limitless ...CEO of Redgate: Jakub Lemik: This year’s theme is Connect, Share, and Learn. Tomorrow will be People […] 15 novembre 2023 dans Sites anglophones étiqueté Blogs par simple-talk.com
Autonomous Databases?I was talking to some people today about the concept of Autonomous Databases. The idea is that […] 15 novembre 2023 dans Sites anglophones étiqueté Blogs / Editorials par simple-talk.com
An editor’s biggest headache: PlagiarismAs an editor working with other people’s technical writing for many years, you might guess that either […] 10 novembre 2023 dans Sites anglophones étiqueté Blogs par simple-talk.com
Fabric Data Warehouse News you need to knowMicrosoft Fabric, including the Data Warehouse, evolves faster than we can analyze and write about it. Here […] 8 novembre 2023 dans Sites anglophones étiqueté Blogs / data platform / Data Warehouse / Microsoft Fabric / Power BI par simple-talk.com
Creating an Azure PostgreSQL cluster and connecting to itOne of the technologies that my new job brought with it was learning about all the various […] 4 novembre 2023 dans Sites anglophones étiqueté Azure / Blogs / PostGreSQL par simple-talk.com
Database Projects for Microsoft Fabric Data WarehouseDatabase Projects for Fabric Data Warehouse is one of the most recent news of Fabric for SDLC […] 25 octobre 2023 dans Sites anglophones étiqueté Blogs / Data Warehouse / Database Project / Microsoft Fabric / Power BI par simple-talk.com
SQL Server Security PrimerSQL Server security structure, mechanisms and methods are very thoroughly documented in the Microsoft documentation, but it […] 15 octobre 2023 dans Sites anglophones étiqueté Blogs / Security and Compliance / SQL Security par simple-talk.com
Fabric: My Content compilationMicrosoft Fabric was first announced during Microsoft BUILD. Since then, I’m publishing content about Microsoft Fabric, creating […] 4 octobre 2023 dans Sites anglophones étiqueté Blogs / Data Lake / Data Warehouse / lakehouse / Microsoft Fabric / Power BI par simple-talk.com
SQL Server Row Level Security Deep Dive. Part 6 ...As seen in the previous section, there are several ways bad actors can attempt to bypass RLS. […] 3 octobre 2023 dans Sites anglophones étiqueté Auditing / BenJohnston_RLS / Blogs / RLS par simple-talk.com
Microsoft Fabric and the Delta Tables SecretsMicrosoft Fabric storage uses OneLake and Delta Tables, the core storage of all Fabric objects, as explained […] 27 septembre 2023 dans Sites anglophones étiqueté Blogs / Data Lake / Delta / lakehouse / Microsoft Fabric / Power BI par simple-talk.com
SQL Server Row Level Security Deep Dive. Part 5 – ...As mentioned in previous sections, RLS is an addition to security and should not be used as […] 25 septembre 2023 dans Sites anglophones étiqueté BenJohnston_RLS / Blogs / RLS / Side-channel attack par simple-talk.com
Microsoft Fabric: Checking and Fixing Tables V-Order OptimizationDownload the notebook used on this blog I explained in a previous article how the Tables in […] 20 septembre 2023 dans Sites anglophones étiqueté Blogs / data platform / Delta / lakehouse / Microsoft Fabric / Power BI par simple-talk.com
SQL Server Row Level Security Deep Dive. Part 4 – ...One of the primary reasons to implement RLS is to facilitate reporting and ease the administrative burden. […] 17 septembre 2023 dans Sites anglophones étiqueté BenJohnston_RLS / Blogs / Power BI / RLS / SSRS par simple-talk.com