Estimating the storage savings by removing columns with NULL value across the table or...
In the previous article Find columns with NULL values across the table we discussed that storage space can be saved by removing columns with...
Azure SQL Database Connectivity from Blog Posts – SQLServerCentral
Have you ever wondered how your connection from outside of Azure to your database is handled? It is important to understand that there is...
How do I tell what compression level my tables/indexes are? from Blog Posts –...
It’s been a while since I worked with compression and the other day I needed to check which of my indexes were compressed and...
Workout Wednesdays for Power BI in 2021 from Blog Posts – SQLServerCentral
I’m excited to announce that something new is coming to the Power BI community in 2021: Workout Wednesday!
Workout Wednesday started in the Tableau...
Reporting with Microsoft SQL
(For more resources related to this topic, see here.)
Server 2012 Power View – Self-service Reporting
Self-service reporting is when business users have the ability to...
Introduction to SQL Server Query Store from Blog Posts – SQLServerCentral
A quick exploration of Query Store, the most anticipated feature of SQL 2016.
The post Introduction to SQL Server Query Store appeared first on SQLServerCentral.
Why you should NEVER run a Logistic Regression (unless you have to) from Featured...
Hello fellow Data Science-Centralists!
I wrote a post on my LinkedIn about why you should NEVER run a Logistic Regression. (Unless you really have to).
The...
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...
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...
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...
