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
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
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
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
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
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