Getting Started Reading Execution Plans: Highest Cost Operator from Blog Posts – SQLServerCentral
Reading execution plans in SQL Server is just hard. There’s a lot to learn and understand. I previously outlined the basics I use to...
Daily Coping 14 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...
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...
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.
Toolbox – When Intellisense Doesn’t See Your New Object from Blog Posts – SQLServerCentral
I was just working on a new SQL job, and part of creating the job was adding a few new tables to our DBA...
Closure with the Professional Organization for SQL Server from Blog Posts – SQLServerCentral
I know that this isn’t the correct name, though the by-laws still list this as the corporation. Perhaps this is one more sign of...
Find columns with NULL values across the table from Blog Posts – SQLServerCentral
Recently, I was working on one of the performance tuning assignment with an esteemed client. The size of their databases were growing tremendously. Growth...
Is On-premises SQL Server Still Relevant? from Blog Posts – SQLServerCentral
Unequivocally, yes on-premises SQL Server Instances are still relevant.
While I’m a firm believer that the cloud is not a fad and is not going...
Daily Coping 11 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...
New Microsoft data governance product: Azure Purview from Blog Posts – SQLServerCentral
Azure Purview is at data governance solution that is the sequel to the product Azure Data Catalog, and is now available in public preview....
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...
