Sites anglophones


#TSQL2sday 136 Wrap-Up: Your Favorite (and Least Favorite) Data Types

Publié le 15 mars 2021 sur brentozar.com
 

For this month’s T-SQL Tuesday, I asked you to blog about your most-loved and least-loved data types. Crazy, right? How could people possibly love or hate data types? Well, if you’ve been working with them for a while, I figured you’d …

Google Cloud Certification for Microsoft Database Engineer

Publié le 15 mars 2021 sur sqlservercentral.com
 

Introduction I recently passed the Google Cloud Professional Data Engineer certification exam, Professional Data Engineer Certification. It took me about five month to prepare for this, and I would like to share my thoughts of why I decided to take it …

What is Azure Databricks?

Publié le 15 mars 2021 sur sqlservercentral.com
 

The post What is Azure Databricks? appeared first on SQLServerCentral.

How I Worked Toward GDPR Compliance: The Really Long Story

Publié le 12 mars 2021 sur brentozar.com
 

BrentOzar.com is 20 years old, so I’m spending 20 days reflecting. Yesterday, I wrote about how my online classes are available to Europeans now, and today I’m going to talk about why that was a problem for a while, and how I solved it. The …

What is interpolation?

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

Interpolation is a mathematical technique which was popular before we had a lot of cheap computing power. The basic idea is that if you’re given a set of data and looking for a value in the same range, you can interpolate it to get a reasonable e …

Wow: BrentOzar.com is 20 Years Old.

Publié le 11 mars 2021 sur brentozar.com
 

My first avatar, by Jin Wicked In 2001, I was a developer, and I liked to write. I’d had web sites for a number of years, but in 2001, I decided to switch from wickedlife.com (archive) over to BrentOzar.com. I wanted a domain name that would more …

PostgreSQL WHERE, ORDER BY, and GROUP BY Clauses

Publié le 11 mars 2021 sur sqlservercentral.com
 

Overview A database clause is a conditional statement used to filter data from the database. There are various database clauses available in PostgreSQL, like Where, Order By, Group By, Having, Distinct, Limit, Fetch. In this first chapter of the tutori …

Save 75% on My Training Classes – Europeans Too!

Publié le 10 mars 2021 sur brentozar.com
 

Good news, party people: we’re finally selling to the European Union, European Economic Area, and the United Kingdom again! To celebrate, during March you can use coupon code Happy20th to save 75% off my Live Class Season Pass, Recorded Class Sea …

T-SQL Tips and Tricks

Publié le 10 mars 2021 sur sqlservercentral.com
 

The post T-SQL Tips and Tricks appeared first on SQLServerCentral.

Getting Data In and Out of SQL Server Flyway Builds

Publié le 10 mars 2021 sur sqlservercentral.com
 

The post Getting Data In and Out of SQL Server Flyway Builds appeared first on SQLServerCentral.

4 Things I Love About Integers #TSQL2sday

Publié le 9 mars 2021 sur brentozar.com
 

I love integers. Furthermore, I think we’ve all been taking them for granted. Integers are clean, elegant datatypes that do exactly what they’re supposed to. They’re the Golden Retrievers of the database world: they have a few shortco …

Reading a Specific File from an S3 bucket Using Python

Publié le 9 mars 2021 sur sqlservercentral.com
 

Introduction This article will show how can one connect to an AWS S3 bucket to read a specific file from a list of objects stored in S3. We will then import the data in the file and convert the raw data into a Pandas data frame using Python for more de …

SQL Server DBA Utility Dashboard

Publié le 8 mars 2021 sur sqlservercentral.com
 

The post SQL Server DBA Utility Dashboard appeared first on SQLServerCentral.

Creating a Simple DynamoDB NoSQL Table in AWS

Publié le 8 mars 2021 sur sqlservercentral.com
 

DynamoDB is Amazon’s fully managed NoSQL database. A NoSQL database is primarily a key-value store that is optimized for better write speeds. DynamoDB database is well suited for big data applications, web apis and real time applications. After g …

What is the state of Database DevOps in 2021?

Publié le 8 mars 2021 sur sqlservercentral.com
 

The post What is the state of Database DevOps in 2021? appeared first on SQLServerCentral.


Pages :