4 Things I Love About Integers #TSQL2sday
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
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
The post SQL Server DBA Utility Dashboard appeared first on SQLServerCentral.
Creating a Simple DynamoDB NoSQL Table in AWS
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?
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)
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
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
The post Power BI Small Multiples Visual Example appeared first on SQLServerCentral.
Catch-up on Redgate Summit
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.
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
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
The post SQL Server 101 Tutorial appeared first on SQLServerCentral.
PowerShell editors and environments: Part 1
The post PowerShell editors and environments: Part 1 appeared first on SQLServerCentral.
Create Calendar Table Using Power Query M Language
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)
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 …