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
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
A Beginners Guide to MySQL Replication Part 5: Group ReplicationThis article is part of Aisha Bukar’s 6 part series on MySQL Replication. The entries include: Part […] 28 août 2023 dans Sites anglophones étiqueté Homepage / MySQL / stateofdatabaselandscapesurvey par simple-talk.com
Learning PostgreSQL With Grant: Introducing VACUUMWhile there are many features within PostgreSQL that are really similar to those within SQL Server, there […] 21 août 2023 dans Sites anglophones étiqueté Homepage / LearningPostgreSQLWithGrant / PlanetPostgreSQLGrantFritchey / PostGreSQL par simple-talk.com
How much has data technology changed over the years?The simple answer to this question is “a lot.” The funny part, however, is that everyone who […] 16 août 2023 dans Sites anglophones étiqueté Editorials / Homepage par simple-talk.com
Working around schema drift in SQL ServerAt Stack Overflow, our environment has multiple implementations of a largely – but not 100% – identical […] 14 août 2023 dans Sites anglophones étiqueté Homepage / stateofdatabaselandscapesurvey / t-sql / T-SQL Programming par simple-talk.com
Database Concurrency in PostgreSQLConcurrency control is an essential aspect of database systems that deals with multiple concurrent transactions. PostgreSQL employs […] 11 août 2023 dans Sites anglophones étiqueté Homepage / PostGreSQL / stateofdatabaselandscapesurvey par simple-talk.com
What Is an Execution Plan and How to Find It ...In the last blog (When PostgreSQL Parameter Tuning is not the Answer), we compared several execution plans […] 7 août 2023 dans Sites anglophones étiqueté Homepage / PostGreSQL par simple-talk.com
Building REST APIs in Go with Mux and GORMIn modern software development, Application Programming Interfaces (APIs) are essential for building scalable and flexible systems. APIs […] 4 août 2023 dans Sites anglophones étiqueté Homepage / Other Development par simple-talk.com
Running Queries Across Many SQL Server DatabasesA challenge that reappears periodically in the world of databases (especially database management) is the need to […] 31 juillet 2023 dans Sites anglophones étiqueté Database Administration / Homepage par simple-talk.com
Exporting data from a MySQL database using SELECT…INTO OUTFILEThis article is part of Robert Sheldon’s continuing series on Learning MySQL. To see all of the […] 27 juillet 2023 dans Sites anglophones étiqueté Homepage / MySQL par simple-talk.com
Querying PostgreSQL: Learning PostgreSQL with GrantWriting queries to retrieve the data from a database is probably the single most common task when […] 24 juillet 2023 dans Sites anglophones étiqueté Homepage / LearningPostgreSQLWithGrant / PostGreSQL par simple-talk.com
Optimizing Queries in MySQL: Optimizing UpdatesIn the previous parts of these MySQL optimization series, we’ve told you how queries work on a […] 20 juillet 2023 dans Sites anglophones étiqueté Homepage / MySQL par simple-talk.com
Managing Test Data for Database DevelopmentIn coming up with a strategy for managing test data, first you need to understand what the […] 17 juillet 2023 dans Sites anglophones étiqueté Homepage / Testing par simple-talk.com
The GROUP BY ClauseWhen you’re learning SQL DML, the most complicated clause is typically the GROUP BY. It’s a fairly […] 10 juillet 2023 dans Sites anglophones étiqueté Homepage / Theory and design par simple-talk.com
When Parameter Tuning is not the AnswerSo much about parameters tuning, but does it always help? Welcome to the third and final blog […] 6 juillet 2023 dans Sites anglophones étiqueté Homepage / PostGreSQL par simple-talk.com
Using a Subquery in a SELECT statementThis article is part of Greg Larsen’s continuing series on Learning T-SQL. To see all 10 items […] 26 juin 2023 dans Sites anglophones étiqueté Homepage / Learn SQL Server / T-SQL Programming par simple-talk.com
Snowflake: A Cloud Warehouse Solution for AnalyticsThis article explains what Snowflake data warehouse is and how it is different from other traditional data […] 19 juin 2023 dans Sites anglophones étiqueté Homepage / snowflake par simple-talk.com
Working with MySQL transactionsMySQL transactions provide an effective method for executing multiple statements as a single unit, making it possible […] 15 juin 2023 dans Sites anglophones étiqueté Homepage / MySQL par simple-talk.com
Manipulating Data In PostgreSQL: Learning PostgreSQL with GrantSo far in the series I’ve shown how to create databases, tables, constraints, indexes and schema. Now, […] 12 juin 2023 dans Sites anglophones étiqueté Homepage / LearningPostgreSQLWithGrant / PlanetPostgreSQLGrantFritchey / PostGreSQL par simple-talk.com
A Guide to INSERT, UPDATE, and DELETE Statements in OracleIn this article, we’ll be focusing on three of the most used SQL commands in Oracle: INSERT, […] 9 juin 2023 dans Sites anglophones étiqueté Homepage / Oracle par simple-talk.com
SQL Server 2022: Capture SQL Anti-PatternsOne of the new Extended Event available in SQL Server 2022 is the query_antipattern. This extended […] 1 juin 2023 dans Sites anglophones étiqueté Homepage / Performance par simple-talk.com
T-SQL Gap-Filling ChallengeA student of mine sent me a T-SQL challenge involving gap-filling of missing dates and balances. I […] 29 mai 2023 dans Sites anglophones étiqueté Homepage / T-SQL Programming par simple-talk.com
Data Intelligence on light speed: Microsoft FabricThis article is based on exciting information just released at Microsoft’s Build conference on May 23, 2023. […] 24 mai 2023 dans Sites anglophones étiqueté Azure / Homepage par simple-talk.com
Optimizing MySQL: Adding Data to TablesWelcome back to the MySQL optimization series! In case you haven’t been following this series, in the […] 22 mai 2023 dans Sites anglophones étiqueté Homepage / MySQL par simple-talk.com
PostgreSQL Basics: A Template for Managing Database PrivilegesIn the first two articles of this series about PostgreSQL privileges, we reviewed how to create roles, […] 18 mai 2023 dans Sites anglophones étiqueté Homepage / PlanetPostgresqlRyanBooz / PostGreSQL par simple-talk.com
Changing log growth strategy in SQL Server 2022When I first saw a bullet item stating SQL Server 2022 would support instant file initialization for […] 15 mai 2023 dans Sites anglophones étiqueté Database Administration / Homepage / T-SQL Programming par simple-talk.com
Uncovering the mysteries of PostgreSQL (auto) vacuumWelcome to the second blog of the “magic of parameters” series. In the first entry, I covered […] 12 mai 2023 dans Sites anglophones étiqueté Homepage / PostGreSQL par simple-talk.com
Importing data into a MySQL database using LOAD DATADatabase and development teams often load data from plain text files into their MySQL databases. The files […] 4 mai 2023 dans Sites anglophones étiqueté Homepage / MySQL par simple-talk.com
PostgreSQL Basics: Essential psql Tips and TricksHaving access to the psql command-line tool is essential for any developers or DBAs that are actively […] 1 mai 2023 dans Sites anglophones étiqueté Homepage / PlanetPostgresqlRyanBooz / PostGreSQL par simple-talk.com
How to secure legacy ASP.NET MVC against Cross-Site(CSRF) AttacksCross-Site Request Forgery (CSRF) attacks are widespread, and even some BigTech companies suffer from them. Netflix suffered […] 12 avril 2023 dans Sites anglophones étiqueté .NET / Homepage / Web par simple-talk.com
PostgreSQL Schema: Learning PostgreSQL with GrantAn important aspect of building and managing a database is organizing the objects within your database. You […] 10 avril 2023 dans Sites anglophones étiqueté Homepage / LearningPostgreSQLWithGrant / PlanetPostgreSQLGrantFritchey / PostGreSQL par simple-talk.com
Ordered Columnstore Indexes in SQL Server 2022 7 avril 2023 dans Sites anglophones étiqueté Homepage / T-SQL Programming par simple-talk.com
Modifying MySQL data from within PythonIn the previous article in this series, I introduced you to how to access MySQL data from […] 4 avril 2023 dans Sites anglophones étiqueté Homepage / MySQL / Python par simple-talk.com
GENERATE_SERIES: My new go-to to build setsI have come across a lot of use cases for manufacturing rows on the fly, aside from […] 31 mars 2023 dans Sites anglophones étiqueté Homepage / SQL Server 2022 / T-SQL Programming / Transact SQL par simple-talk.com
Using Virtual Network Data Gateways to Secure Access to Azure ...Power BI and Azure are two related services, but with a considerable independence between them. Power BI […] 27 mars 2023 dans Sites anglophones étiqueté BI / Homepage par simple-talk.com
Paging Data in T-SQLSometimes when working with very large sets of data, you may not want to return all of […] 20 mars 2023 dans Sites anglophones étiqueté Homepage / Learn SQL Server / T-SQL Programming par simple-talk.com
The SELECT Statement in OracleThe SELECT statement is used to retrieve information from a database. Following the execution of a SELECT […] 16 mars 2023 dans Sites anglophones étiqueté Homepage / Oracle par simple-talk.com
Are PostgreSQL memory parameters magic?Configuration parameters are the most mythical creatures in the world of PostgreSQL. Ordinary PostgreSQL users often do […] 13 mars 2023 dans Sites anglophones étiqueté Homepage / PostGreSQL par simple-talk.com