MySQL Error Log Management in DevOps OperationsWhen it comes to the development and operations (DevOps), one thing stands out as a critical aspect […] 14 décembre 2023 dans Sites anglophones étiqueté Homepage / MySQL 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
Exploring PostgreSQL IndexesIn this blog, we continue our exploration on PostgreSQL indexes which we started here. In that article, […] 11 décembre 2023 dans Sites anglophones étiqueté Homepage / PostGreSQL 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
Understanding SQL Join TypesUnderstanding how to join the data in one table to another is crucial for any data analyst […] 4 décembre 2023 dans Sites anglophones étiqueté Homepage / PostGreSQL 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
When an update doesn’t updateTell me if you’ve heard this one before: I changed data from my application, but when I […] 27 novembre 2023 dans Sites anglophones étiqueté Homepage / T-SQL Coding / T-SQL Programming / Theory and design 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
Source Control with GIT, Power BI and Microsoft FabricSource control is fundamental when dealing with projects and sharing code between multiple developers. Power BI present […] 22 novembre 2023 dans Sites anglophones étiqueté BI / fabric / Homepage par simple-talk.com
What is Microsoft Fabric all about?In this article, we will introduce Microsoft Fabric and how it relates to Power BI Premium Capacity […] 22 novembre 2023 dans Sites anglophones étiqueté BI / Homepage 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
Strategies for queries against bit columnsRecently someone posted a question where they couldn’t quite figure out how to construct a predicate based […] 20 novembre 2023 dans Sites anglophones étiqueté BIT / Homepage / t-sql / T-SQL Programming 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
Getting Started with MongoDBMongoDB is a scalable database management system that stores data as documents in a collection, rather than […] 13 novembre 2023 dans Sites anglophones étiqueté Homepage / NoSQL 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
The NTILE FunctionThe SQL NTILE() is a window function that allows you to break a table into a specified […] 9 novembre 2023 dans Sites anglophones étiqueté Homepage / Theory and design 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
Moving SQL Server To The Cloud: Modernizing Stack Overflow for ...Earlier this year, we migrated the entire Stack Overflow for Teams platform to Azure. This was a […] 6 novembre 2023 dans Sites anglophones étiqueté Database Administration / Homepage / migration / Upgrades 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
Getting connected to PostgreSQL for the first timePostgreSQL continues to be all the rage in 2023, whether in “vanilla” form of the fully open-source […] 3 novembre 2023 dans Sites anglophones étiqueté Homepage / PlanetPostgresqlRyanBooz / PostGreSQL par simple-talk.com
SQL Endpoints and Lakehouse UI Differences and Access SecretsThere are some differences and secrets between the UI of a SQL Endpoint and the UI of […] 30 octobre 2023 dans Sites anglophones étiqueté BI / Data Lake / Homepage / lakehouse / Microsoft Fabric / Power BI par simple-talk.com
Pike’s Market to Pikes Peak: The PASS Summit is Worth ...Recently I spoke at SQL Saturday Denver. The day after the conference we went to visit Pikes […] 26 octobre 2023 dans Sites anglophones étiqueté Editorials / Homepage 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
Exporting and Importing Data into SQL Server Using FilesThere are plenty of applications and tools available that allow for the movement of data in and […] 23 octobre 2023 dans Sites anglophones étiqueté Homepage / T-SQL Programming par simple-talk.com
Don’t use DISTINCT as a “join-fixer”I’ve quietly resolved performance issues by re-writing slow queries to avoid DISTINCT. Often, the DISTINCT is there […] 16 octobre 2023 dans Sites anglophones étiqueté Homepage / t-sql / T-SQL Programming 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
A Beginners Guide To MySQL Replication Part 6: Security Considerations ...This article is part of Aisha Bukar’s 6 part series: A Beginners Guide to MySQL Replication. The […] 12 octobre 2023 dans Sites anglophones étiqueté Homepage / MySQL par simple-talk.com
PostgreSQL Indexes: What They Are and How They HelpIn the previous blog in this series, we learned how to produce, read and interpret execution plans. […] 9 octobre 2023 dans Sites anglophones étiqueté Homepage / MySQL / PlanetPostgreSQLHenriettaDombrovskaya par simple-talk.com
First Normal Form Gets No RespectDr. Codd first described the relational model in a paper in Communications of the ACM (CACM 13 […] 5 octobre 2023 dans Sites anglophones étiqueté Homepage / Theory and design 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
Normalize strings to optimize space and searchesWhile this article is specifically geared to SQL Server, the concepts apply to any relational database platform. […] 2 octobre 2023 dans Sites anglophones étiqueté Homepage / Normalization / Performance / T-SQL Programming par simple-talk.com
T-SQL Fundamentals: Controlling DuplicatesWhen people start learning a new field, for example T-SQL, it’s tempting to spend very little time […] 28 septembre 2023 dans Sites anglophones étiqueté Homepage / SummitSpeaker2023ItzikBenGan / T-SQL Programming / Theory and design 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
MySQL joinsTables in a MySQL database are commonly related to one another, often in multiple ways, and it […] 25 septembre 2023 dans Sites anglophones étiqueté Homepage / MySQL / stateofdatabaselandscapesurvey par simple-talk.com
Analyze and Tune SQL Server StatisticsOver the years, SQL Server Statistics have been discussed in countless blog posts, articles, and presentations, and […] 22 septembre 2023 dans Sites anglophones étiqueté Database Administration / Homepage 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
Alternatives To SQL-2022 Built-in function GREATESTIf you haven’t already heard, SQL 2022 has introduced a new built-in system function called GREATEST. Simply […] 18 septembre 2023 dans Sites anglophones étiqueté Homepage / stateofdatabaselandscapesurvey / T-SQL Programming 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
Microsoft Fabric: Using notebooks and table partitioning to convert files ...When Microsoft Fabric was born, the only method to convert files to tables was using notebooks. Nowadays […] 13 septembre 2023 dans Sites anglophones étiqueté Data Lake / data platform / lakehouse / Microsoft Fabric / notebook / Power BI / Uncategorized par simple-talk.com
SQL Server Row Level Security Deep Dive. Part 3 – ...Previous sections gave a brief introduction to RLS, including some common use cases. They also showed how […] 10 septembre 2023 dans Sites anglophones étiqueté BenJohnston_RLS / Blogs / RLS / RLS Performance / RLS Troubleshooting par simple-talk.com
Working with MySQL constraintsMySQL provides a set of constraints that you can include in your table definitions to help ensure […] 7 septembre 2023 dans Sites anglophones étiqueté Homepage / MySQL / stateofdatabaselandscapesurvey par simple-talk.com
Microsoft Fabric: Lakehouse and Data Factory in Power BI environmentMicrosoft is merging Data Factory and Power BI Dataflows in one single ETL solution. It’s not a […] 6 septembre 2023 dans Sites anglophones étiqueté Azure / Homepage / stateofdatabaselandscapesurvey par simple-talk.com
Orchestrating a MySQL Container on KubernetesIf you’ve been using MySQL for a while and want to learn how to orchestrate MySQL containers, […] 5 septembre 2023 dans Sites anglophones étiqueté Containers and Virtualization / Homepage / MySQL / stateofdatabaselandscapesurvey par simple-talk.com
SQL Server Row Level Security Deep Dive. Part 2 – ...The previous section in this series was an introduction to Row Level Security (RLS) and some use […] 3 septembre 2023 dans Sites anglophones étiqueté Access Predicate / BenJohnston_RLS / Blogs / RLS / Security Policy par simple-talk.com