Sites anglophones


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.

Download the Current Stack Overflow Database for Free (2021-02)

Publié le 5 mars 2021 sur brentozar.com
 

Stack Overflow, the place where most of your production code comes from, publicly exports their data every couple/few months. @TarynPivots (their DBA) tweets about it, and then I pull some levers and import the XML data dump into SQL Server format …

How SQL Server synonyms help database DevOps

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

Synonyms inside SQL Server are one of those useful but forgotten features. A synonym is a database level object that allows you to provide an alternative name for another database object such as a view, user defined table, scalar function, stored proce …

Power BI Small Multiples Visual Example

Publié le 5 mars 2021 sur sqlservercentral.com
 

The post Power BI Small Multiples Visual Example appeared first on SQLServerCentral.

Catch-up on Redgate Summit

Publié le 5 mars 2021 sur sqlservercentral.com
 

The post Catch-up on Redgate Summit appeared first on SQLServerCentral.

It’s March. We’re still quarantined. Let’s do some free classes for Europeans.

Publié le 4 mars 2021 sur brentozar.com
 

Last year, during the first few months of quarantines, I ran free training classes to help y’all pass the time and raise your skills. Thankfully, I don’t need to wear this during the online classes. It’s March 2021, and so many of us …

Using ADF to Upload Disparate CSV Files into Azure MySQL

Publié le 4 mars 2021 sur sqlservercentral.com
 

In this article our objective is to showcase how to leverage Azure Data Factory (ADF) and a custom script to upload data in Azure MySQL database when we have CSV files with different schemas. As there is no straightforward way to upload data directly u …

SQL Server 101 Tutorial

Publié le 4 mars 2021 sur sqlservercentral.com
 

The post SQL Server 101 Tutorial appeared first on SQLServerCentral.

PowerShell editors and environments: Part 1

Publié le 3 mars 2021 sur sqlservercentral.com
 

The post PowerShell editors and environments: Part 1 appeared first on SQLServerCentral.

Create Calendar Table Using Power Query M Language

Publié le 3 mars 2021 sur sqlservercentral.com
 

The post Create Calendar Table Using Power Query M Language appeared first on SQLServerCentral.

#TSQL2sday 136 Invitation: Blog About Your Favorite Data Type (Or Least Favorite)

Publié le 2 mars 2021 sur brentozar.com
 

T-SQL Tuesday is a monthly blogothon where we get together and write about a different topic. I’m hosting this month’s episode. Your mission: write a blog post about your favorite data type, and schedule it for next Tuesday, March 9. Mad ab …


Pages :