Setting Defaults for New SQL Compare Projects from Blog Posts – SQLServerCentral
Recently I wrote about ignoring comments in SQL Compare. That seems like something I want to do in all my projects, so I went...
SQL Puzzle – Eight Queens on a Chess board from Blog Posts – SQLServerCentral
Here's a SQL Puzzle for the festive period. 2020 has been a year of many things but amongst it all, it has been the...
Daily Coping 15 Dec 2020 from Blog Posts – SQLServerCentral
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the...
On table variable row estimations from Blog Posts – SQLServerCentral
At first glance, the question of how many rows are estimated from a table variable is easy.
But, is it really that simple? Well, not...
ETL Antipattern: Performing Full Loads Instead of Incremental Loads from Blog Posts – SQLServerCentral
In my last post in the ETL Antipatterns series, I wrote about the common antipattern of ingesting or loading more data than necessary. This...
T-SQL Tuesday #121: Gifts received for this year Redux 2020 from Blog Posts –...
At the end of 2019, Mala (b|t) invited us to write about the gifts we’ve gotten during the year. I’ve decided to try to make...
Announcing the Calgary Data User Group from Blog Posts – SQLServerCentral
In 2018 I started a new user group called the Calgary Data User Group, and hosted one session called “The Ethics of Machine Learning.”...
Daily Coping 16 Dec 2020 from Blog Posts – SQLServerCentral
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the...
No Scalars with JSON_QUERY–#SQLNewBlogger from Blog Posts – SQLServerCentral
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
I started to dig...
Using Aws Sdk With Go for Ec2 Ami Metrics from Blog Posts – SQLServerCentral
Source
The source code for this repo is located here:
What This Is
This is a quick overview of some AWS SDK Go work, but not a...
Must Read in Cloud & Networking
Top life hacks for prepping for your IT certification exam
I remember deciding to pursue my first IT certification, the CompTIA A+. I had signed up for a class that lasted one week, per...
Must Read in Data
Learn Transformers for Natural Language Processing with Denis Rothman
Key takeaways
The transformer architecture has proved to be revolutionary in outperforming the classical RNN and CNN models in use today.
Artificial intelligence is...
