On the Road Again, Next Up ColumbusJanuary 18, 2020, was the last time I stood in front of a live group of people […] 27 juin 2023 dans Sites anglophones étiqueté Blogs / Speaking par simple-talk.com
Unmasking SQL Server Dynamic Data Masking, Part 3, Security ConcernsThis is the third part of a series on SQL Server Dynamic Data Masking. The first part […] 14 juin 2023 dans Sites anglophones étiqueté Blogs par simple-talk.com
Unmasking SQL Server Dynamic Data Masking – Part 2 – ...This is the second part of a series on SQL Server Dynamic Data masking. The first part […] 7 juin 2023 dans Sites anglophones étiqueté Blogs par simple-talk.com
Power BI Connections ManagementSome time between January and now, a new preview feature was included in Power BI Portal. It’s […] 6 juin 2023 dans Sites anglophones étiqueté Blogs / Power BI par simple-talk.com
Unmasking SQL Server Dynamic Data Masking, Part 1, IntroThis is the beginning of a series on SQL Server Dynamic Data Masking. Dynamic Data Masking is […] 26 mai 2023 dans Sites anglophones étiqueté Blogs par simple-talk.com
Microsoft Fabric: Data Warehouse Ingestion using T-SQL and more.In this blog I will illustrate how we can ingest data from a blog storage to a […] 24 mai 2023 dans Sites anglophones étiqueté Blogs / Data Warehouse / Microsoft Fabric / Power BI / Synapse par simple-talk.com
Self Review: Practical Graph Structures in SQL Server and Azure ...I just finished writing this book a few weeks ago, and as I read it, I thought […] 23 mai 2023 dans Sites anglophones étiqueté Blogs par simple-talk.com
One use case for NOT using schema prefixesI’ve long been a huge advocate for always referencing objects with a schema prefix in SQL Server. […] 20 avril 2023 dans Sites anglophones étiqueté Blogs / Transact SQL par simple-talk.com
A Beginners Guide To MySQL Replication Part 2: Configuring Source ...A Beginners Guide To MySQL Replication Part 2: Configuring Source and Replica Servers In the first part […] 10 avril 2023 dans Sites anglophones étiqueté Blogs / MySQL par simple-talk.com
A Beginners Guide to MySQL Replication Part 1MySQL Replication is a process where data from one MySQL database known as the source (formerly called […] 30 mars 2023 dans Sites anglophones étiqueté Blogs / MySQL par simple-talk.com
The role of forethought for a computer engineerIf you have ever played a game of chess against someone good, or perhaps against a computer, […] 28 mars 2023 dans Sites anglophones étiqueté Blogs par simple-talk.com
Build a Better WordPress Archives Page Using MySQLI recently wrote about a way to generate visual, interactive calendars in HTML by combining a calendar […] 10 mars 2023 dans Sites anglophones étiqueté Blogs / MySQL par simple-talk.com
Synapse Serverless and Dedicated Pool: The differences no one told ...The basic differences between Synapse Serverless and the Dedicated pool are obvious: While the serverless doesn’t store […] 6 mars 2023 dans Sites anglophones étiqueté Azure BLOB Storage / azure synapse / Blogs / Serverless par simple-talk.com
Optional Code in T-SQL Scripts using SQLCMDWhen you are writing T-SQL scripts to save away, for example one to create a new database, […] 6 mars 2023 dans Sites anglophones étiqueté Blogs / T-SQL Programming par simple-talk.com
How to ask for programming helpOver the past 25 years, I have answered a lot of programming questions in online forums, from […] 9 février 2023 dans Sites anglophones étiqueté Blogs par simple-talk.com
Azure Functions and Managed Identity: More SecretsI wrote about Managed Identity Secrets a few weeks ago, but since that article was published I […] 23 janvier 2023 dans Sites anglophones étiqueté Azure Functions / Azure SQL / Azure Storage / Blogs / Managed Identity par simple-talk.com
Synapse Serverless: CETAS requires DFS to workCETAS is the acronym for Create External Table As Select. This allow us to export the result […] 16 janvier 2023 dans Sites anglophones étiqueté Azure BLOB Storage / azure synapse / Blogs / CETAS / Serverless par simple-talk.com
What’s new on Power BI DataMarts UII wrote an article about Power BI Datamarts which was released together the feature, on the exact […] 12 décembre 2022 dans Sites anglophones étiqueté Blogs / data platform / Datamarts / Power BI / Power BI datamarts par simple-talk.com
Backing up MySQL Part 8: Zmanda Backups for MySQL & ...“A Backup as Revolutionary as You Are.” Ever heard that phrase before? If you did, you’re no […] 9 décembre 2022 dans Sites anglophones étiqueté Blogs par simple-talk.com
Dealing with the Bits of a Binary Value in SQL ...How you used to do it For example, say you want to find all the read-write database […] 4 décembre 2022 dans Sites anglophones étiqueté Blogs / T-SQL Programming par simple-talk.com
Backing Up MySQL Part 7: MySQL Enterprise BackupMySQL Enterprise Backup is a known tool for everyone inside of the world of MySQL, no matter […] 3 décembre 2022 dans Sites anglophones étiqueté backups / Blogs / Database / MySQL par simple-talk.com
Backing Up MySQL Part 6: Physical vs. Logical Backups 1 décembre 2022 dans Sites anglophones étiqueté backups / Blogs / Database / MySQL par simple-talk.com
Backing Up MySQL Part 5: Backing Up Big DataAccording to research made by Statista in 2022, the amount of data that is being worked with […] 26 novembre 2022 dans Sites anglophones étiqueté backups / Blogs / Database / MySQL par simple-talk.com
Backing up MySQL Part 4: mydumperThere are many tools we can use to back up our MySQL databases. Some are well-known and […] 22 novembre 2022 dans Sites anglophones étiqueté backups / Blogs / Database / MySQL / Software Tools par simple-talk.com
SQL Server 2022: Azure AD AuthenticationSQL Server 2022 is finally GA and one of the features I was most expecting is finally […] 21 novembre 2022 dans Sites anglophones étiqueté Azure / Azure Active Directory / Blogs / SQL Server 2022 par simple-talk.com
Backing up MySQL Part 3: mysqlpumpIn the MySQL world, there are a couple of ways to take backups of your data. Backups […] 19 novembre 2022 dans Sites anglophones étiqueté backups / Blogs / Database / MySQL / Software Tools par simple-talk.com
Backing Up MySQL Part 2: Percona XtraBackupThere’s no doubt about it – if you’ve ever heard of Percona, you’ve heard of XtraBackup as […] 16 novembre 2022 dans Sites anglophones étiqueté backups / Blogs / Database / MySQL / Percona / XtraBackup par simple-talk.com
Optimizing MySQL: The Basics of Query OptimizationMySQL is a very interesting beast to deal with – both junior developers and expert database administrators […] 10 novembre 2022 dans Sites anglophones étiqueté Blogs / Database / MySQL / optimization / query optimization par simple-talk.com
The PASS Data Community Sessions I Am Most Excited ForNote: Edited to add more sessions… So many The PASS Data Community Summit is coming up in […] 29 octobre 2022 dans Sites anglophones étiqueté Blogs par simple-talk.com
Going to the PASS Data Community Summit this year?We are just one month away from the PASS Data Community Summit. One month. If you haven’t […] 15 octobre 2022 dans Sites anglophones étiqueté Blogs / Editorials / Homepage par simple-talk.com
Generating Repeatable Sets Of Test RowsIn order to test graph structures, I needed a large set of random data. In some ways, […] 30 septembre 2022 dans Sites anglophones étiqueté Blogs / Generating Data / Randomness / SQL Server / t-sql / Transact SQL par simple-talk.com
T-SQL Tuesday #154 – SQL Server 2022, IS DISTINCT FROMSELECT CASE WHEN 1 = NULL THEN ‘True’ Else ‘False’ end, CASE WHEN NOT(1 = NULL) THEN […] 13 septembre 2022 dans Sites anglophones étiqueté Blogs par simple-talk.com
Starting my dream job…“ A new adventure, there in your eyes. It’s just beginning, Feel your heart beat faster. Reach […] 1 septembre 2022 dans Sites anglophones étiqueté Blogs / Uncategorized par simple-talk.com
Into the unknown, sort ofOver half of my life ago, I was looking for a job. I had written a bunch […] 31 août 2022 dans Sites anglophones étiqueté Blogs par simple-talk.com
Creating Azure Policy to setup Virtual Machine Auto-ShutdownThe Auto-Shutdown policy is another important policy to ensure our virtual machines don’t expend more than what […] 25 juillet 2022 dans Sites anglophones étiqueté Azure / Azure Policy / Blogs / Virtual Machines par simple-talk.com
What’s new in T-SQL in SQL Server 2022There are many new features in SQL Server 2022. In relation to T-SQL querying, there are a […] 4 juillet 2022 dans Sites anglophones étiqueté Blogs / SQL / SQL Server 2022 / TSQL par simple-talk.com
Boost productivity with ‘Solution Summary’ cardsSolution Summary cards are the name I have given to simple 1-page documents we provide to developers […] 2 juillet 2022 dans Sites anglophones étiqueté Blogs / Uncategorized par simple-talk.com
Searching through a database via SQLImagine that while developing or testing a SQL Server database, you get an error message mentioning a […] 29 juin 2022 dans Sites anglophones étiqueté Blogs par simple-talk.com
Parameterizing Azure Policy and Ensuring Azure SQL AD AuthenticationI wrote before about enforcing Azure SQL AD Authentication using Azure Policies in two different ways. First, […] 27 juin 2022 dans Sites anglophones étiqueté Azure AD / Azure Policies / Azure SQL / Blogs par simple-talk.com
The Job of a Technical Editor (as Louis sees it)One of the most essential parts of producing a great technical article, blog, or even a book, […] 30 mai 2022 dans Sites anglophones étiqueté Blogs / Publishing / Tech Editing / Uncategorized / Writing par simple-talk.com
Power BI: When a Power Query Native Query is not ...In Power BI, when importing data with Power Query, one basic performance concept is the use of […] 23 mai 2022 dans Sites anglophones étiqueté Blogs / Power BI / Power Query / Query plans par simple-talk.com