Sites anglophones


9 Signs Your T-SQL Might Fail a Code Review

Publié le 19 mai 2021 sur brentozar.com
 

It’s hard to set absolute rules about, “Feature X should absolutely never be used.” However, there are some features that set off alarm bells when I see them. Usually, when I start asking more questions about when we’re using th …

Hidden Pitfalls with INNER JOIN and NOT IN Operators

Publié le 19 mai 2021 sur sqlservercentral.com
 

I want to show you how two common operators can deceive you into believing you have constructed a proper SQL statement for your solution. We may want to filter results in a table by using using a IN/NOT IN or a INNER JOIN/LEFT JOIN to another table. Th …

Measuring Team Performance: Calculate LeadTime metric using JIRA and GitHub data

Publié le 19 mai 2021 sur sqlservercentral.com
 

The post Measuring Team Performance: Calculate LeadTime metric using JIRA and GitHub data appeared first on SQLServerCentral.

Contest: My Favorite Caption Wins a Live Class Season Pass

Publié le 17 mai 2021 sur brentozar.com
 

Let’s have a few laughs this week. In the comments, write a caption for this: Prizes: My favorite caption overall wins a Live Class Season Pass Runners-up get both a Recorded Class Season Pass: Mastering Classes and Recorded Class Season Pass: Fu …

PostgreSQL HAVING,LIMIT and FETCH Clauses

Publié le 17 mai 2021 sur sqlservercentral.com
 

Overview In this article, we will cover these PostgreSQL clauses with examples: HAVING, LIMIT and FETCH. In a previous article we discussed the WHERE, ORDER BY and GROUP BY  clauses. Click the link if you wish to learn about those clauses. HAVING …

Step by Step Guide to Install Jupyter Notebook

Publié le 17 mai 2021 sur sqlservercentral.com
 

Whether you work as a Data Engineer or a Data Scientist, a Jupyter Notebook is a helpful tool. One of the projects I was working required a comparison of two parquet files. This is mainly a schema comparison, not a data comparison. Though the two .parq …

How to Manage Date Formats in the Power BI Service

Publié le 17 mai 2021 sur sqlservercentral.com
 

The post How to Manage Date Formats in the Power BI Service appeared first on SQLServerCentral.

Win DevOps books with Redgate’s competition

Publié le 17 mai 2021 sur sqlservercentral.com
 

The post Win DevOps books with Redgate’s competition appeared first on SQLServerCentral.

SQL Server T-SQL CASE Statement Examples

Publié le 14 mai 2021 sur sqlservercentral.com
 

The post SQL Server T-SQL CASE Statement Examples appeared first on SQLServerCentral.

Data Saturday #8 – SouthWest US

Publié le 14 mai 2021 sur sqlservercentral.com
 

The post Data Saturday #8 – SouthWest US appeared first on SQLServerCentral.

I’m on the KasperOnBI Podcast Talking About Careers and the Future of SQL Server

Publié le 13 mai 2021 sur brentozar.com
 

I sat down with Microsoft’s Kasper de Jonge this month for an hour-long conversation about how I got started speaking, careers, and the future of SQL Server: You can also listen on Spotify and Apple Podcasts. In the podcast, we talk about my Epic …

Conditional DELETE and INSERT in PostgreSQL

Publié le 12 mai 2021 sur sqlservercentral.com
 

Introduction We are comfortable with inserting/deleting record(s) into/from a table. But we sometimes get confused when we need to insert or delete records conditionally from a table. Let us look at an example. Example scenario Suppose we have a table, …

Automating Azure DevOps with Logic Apps

Publié le 12 mai 2021 sur sqlservercentral.com
 

The post Automating Azure DevOps with Logic Apps appeared first on SQLServerCentral.

Take our survey to win a $500 Amazon gift card

Publié le 12 mai 2021 sur sqlservercentral.com
 

The post Take our survey to win a $500 Amazon gift card appeared first on SQLServerCentral.

Oracle Sequences: RAC

Publié le 11 mai 2021 sur simple-talk.com
 

The series so far: Oracle sequences: The basics Oracle sequences: RAC In my first article on Sequences, I reviewed the fundamental reason why Oracle Corp. introduced the mechanism (i.e. synthetic/surrogate keys) and the mechanical threats (cache size a …


Pages :