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
Database Subsetting and Data ExtractionLet’s start by defining a subset and why you would require a data subset? When dealing with […] 17 avril 2024 dans Sites anglophones étiqueté Database Administration / Homepage / Theory and design par simple-talk.com
Snake draft sorting in SQL Server, part 2In my previous post, I showed how to borrow a snake draft concept from fantasy football, or […] 15 avril 2024 dans Sites anglophones étiqueté Database Administration / Homepage / SQL Server / T-SQL Programming par simple-talk.com
Snake draft sorting in SQL Server, part 1I recently had a restore job where I needed to split the work up into multiple parallel […] 12 avril 2024 dans Sites anglophones étiqueté Database Administration / Homepage / SQL Server / T-SQL Programming par simple-talk.com
Fabric and Azure SQL in a few clicks: Mirroring a ...Finally, mirroring is available for Fabric! You can mirror an Azure SQL to Fabric. It works for […] 12 avril 2024 dans Sites anglophones étiqueté BI / Homepage / Microsoft Fabric par simple-talk.com
How to Use Any SQL Database With RustRust is emerging as a frontrunner for ensuring memory safety without sacrificing performance. Its growing popularity isn’t […] 11 avril 2024 dans Sites anglophones étiqueté Homepage / Rust / Web par simple-talk.com
Using Common Table Expressions: Transforming and Analyzing Data in PostgreSQL, ...In the first article in this transforming data series, I discussed how powerful PostgreSQL can be in […] 8 avril 2024 dans Sites anglophones étiqueté Homepage / PlanetPostgresqlRyanBooz / PostGreSQL par simple-talk.com
Giving Feedback on Microsoft Data Platform ToolsAs a data professional, there is a set of tools that you use on pretty much a […] 8 avril 2024 dans Sites anglophones étiqueté Editorials / Homepage / SQL Server par simple-talk.com
Building MongoDB Aggregations in MongoDB CompassThis article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […] 2 avril 2024 dans Sites anglophones étiqueté Homepage / MongoDB / NoSQL par simple-talk.com
SQL LogicIn this article, I will discuss the history and thinking behind several types of logic that are […] 29 mars 2024 dans Sites anglophones étiqueté Database Theory / Homepage / Theory and design par simple-talk.com
Pagination and ordering by large valuesPagination is a technique for limiting output. Think of Google search results, shopping the electronics category on […] 25 mars 2024 dans Sites anglophones étiqueté Homepage / T-SQL Programming par simple-talk.com
Department of Redundancy DepartmentEver wonder all the reasons that we use databases instead of file systems? While we don’t think […] 18 mars 2024 dans Sites anglophones étiqueté Homepage / Theory and design par simple-talk.com
Transforming and Analyzing Data in PostgreSQLIn our data hungry world, knowing how to effectively load and transform data from various sources is […] 12 mars 2024 dans Sites anglophones étiqueté Homepage / PlanetPostgresqlRyanBooz / PostGreSQL par simple-talk.com
Get the most out of SQL Server Agent logsIf you haven’t migrated your workloads to a managed database platform yet, you’re probably still relying on […] 11 mars 2024 dans Sites anglophones étiqueté Database Administration / Homepage par simple-talk.com
Serverless Authentication methods in web apps.Serverless authentication methods refer to approaches for managing user identity and access without the need for traditional […] 5 mars 2024 dans Sites anglophones étiqueté cloud / Homepage par simple-talk.com
The Value of Conference SpeakingEditor note: The call for speakers is open at on the Pass Data Community Summit 2024 Site, […] 4 mars 2024 dans Sites anglophones étiqueté Career / Homepage par simple-talk.com
Building MongoDB AggregationsThis article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […] 1 mars 2024 dans Sites anglophones étiqueté Homepage / NoSQL par simple-talk.com
Find and Replace Text in Strings in T-SQLString manipulation is an inevitable task for developers and data professionals alike. Despite all the best efforts […] 29 février 2024 dans Sites anglophones étiqueté Homepage / T-SQL Programming par simple-talk.com
Upgrade SQL Server on your workstationLately, I’ve seen many people struggling to upgrade their workstation to the latest version of SQL Server. […] 26 février 2024 dans Sites anglophones étiqueté Database Administration / Homepage par simple-talk.com
Database Feature TogglesIn software development the concept of feature toggles are used to selectively turn on and off features. […] 19 février 2024 dans Sites anglophones étiqueté Homepage / Software Delivery par simple-talk.com
Functions and Procedures: Learning PostgreSQL with GrantOne of the most useful constructs in SQL Server is the stored procedure. It gives you a […] 15 février 2024 dans Sites anglophones étiqueté Homepage / PlanetPostgreSQLGrantFritchey / PostGreSQL par simple-talk.com
Leave it better than you found itThis is for the folks who still have to log into remote machines and do work manually […] 12 février 2024 dans Sites anglophones étiqueté Database Administration / Homepage par simple-talk.com
Automating BCP with PowerShellI was talking with a good friend that has an environment with terabytes of information and to […] 9 février 2024 dans Sites anglophones étiqueté Homepage / PowerShell par simple-talk.com
Top-Down and Bottom-Up Approaches in Microsoft FabricNikola Ilic, best known as Data Mozart, published a great article and video about how to make […] 25 janvier 2024 dans Sites anglophones étiqueté Azure / BI / Homepage / Microsoft Fabric / Power BI / Semantic Model par simple-talk.com
State of the Database Landscape Results 2024Every year, Redgate surveys technologists to ask a big question (through lots of little questions, naturally.) This […] 23 janvier 2024 dans Sites anglophones étiqueté Career / Databases / Homepage / stateofdatabaselandscapesurvey par simple-talk.com
Querying MongoDB DocumentsMongoDB provides an efficient environment for storing document data at scale. However, most of your interactions with […] 22 janvier 2024 dans Sites anglophones étiqueté Homepage / NoSQL par simple-talk.com
The Importance of RetentionIt is always an afterthought. New objects are created that start off small and current. New feature […] 19 janvier 2024 dans Sites anglophones étiqueté Database Administration / Homepage / T-SQL Programming par simple-talk.com
Optimized locking in Azure SQL DatabaseI don’t think I’ve ever had a great impression of Azure SQL Database as a place for […] 8 janvier 2024 dans Sites anglophones étiqueté Azure SQL Database / Database Administration / Homepage / Locking par simple-talk.com
PowerShell Dynamic Parameters and SQL ServerHave you ever been in a situation that you want to call a cmdlet or a function […] 5 janvier 2024 dans Sites anglophones étiqueté Homepage / PowerShell par simple-talk.com
Two-Dimensional Interval Packing ChallengePacking intervals is a classic SQL task that involves packing groups of intersecting intervals to their respective […] 2 janvier 2024 dans Sites anglophones étiqueté Homepage / T-SQL Programming / Theory and design par simple-talk.com
Eager Aggregation in SQL queriesAggregation is a widely used way to summarize the content of a database. It is usually expressed […] 27 décembre 2023 dans Sites anglophones étiqueté Homepage / PostGreSQL / Theory and design par simple-talk.com
Introducing the MongoDB DocumentMongoDB is a document database. As such, the data is stored as individual documents. A document is […] 26 décembre 2023 dans Sites anglophones étiqueté Homepage / NoSQL par simple-talk.com
Counting more efficientlyNearly a decade ago, I wrote a post called “Bad habits : Counting rows the hard way.” […] 20 décembre 2023 dans Sites anglophones étiqueté Homepage / metadata / T-SQL Coding / T-SQL Programming par simple-talk.com
Using a SQL TokenizerImagine this: you have several directories full of SQL script files, and you need to know where […] 18 décembre 2023 dans Sites anglophones étiqueté Homepage / Theory and design par simple-talk.com
Using Spark Jobs for Multiple Lakehouse Maintenance in Microsoft FabricI have published videos and articles before about Lakehouse maintenance. In this article I want to address […] 17 décembre 2023 dans Sites anglophones étiqueté BI / Homepage par simple-talk.com
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
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
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
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
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
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
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
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
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
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
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