Delete SQL Statement in SQL Server, Oracle and PostgreSQL
Learn about the differences and similarities when deleting data from SQL Server, Oracle and PostgreSQL with the several examples in this article.
Reusing Query Results in SSMS
Every time you need to reuse the query results from SSMS, for example to populate another table, or to search for matching rows in another table, it will inevitably mean a lot of manual tweaking to the get the results into the right format. Louis Davidson uncovers three SQL Prompt gems that can remove all this pain.
Google Cloud Certification for Microsoft Database Engineer
Introduction I recently passed the Google Cloud Professional Data Engineer certification exam, Professional Data Engineer Certification. It took me about five month to prepare for this, and I would like to share my thoughts of why I decided to take it on and how I prepared for it. At the moment, Google cloud (GCP) is […]
SQL Server authentication methods, logins, and database users
Understanding SQL Server security is a critical skill. Greg Larsen explains SQL Server authentication methods, logins, and database users in this article.
What is Azure Databricks?
The goal of this article is to illuminate exactly what Azure Databricks is so that you can determine what parts of the platform might make sense to add to your organization's data stack.
New Options for Training and Learning
In 2008, I managed to achieve the goal of becoming a Microsoft Certified Trainer. Once I achieved the status, Microsoft shipped me a binder with dozens of DVDs containing lab VMs and class materials for all the current classes. At some point, instead of receiving DVDs, you were expected to download images which was quite […]
Imposter or Student
We all need to learn and tackle new technology in our career. When we do so, are we impostors or students?
Keep Column Headers Visible in SSRS
Keep column headers visible while scrolling down the page of SSRS reports.
Recruiting DBAs for DevOps
DBAs are in great demand, but what if you are recruiting a DBA for DevOps? Mike Cuppett explains how to hire and train the right DBA for the job.
Blogs
Spark Connect Dotnet November 2024 Where are we?
By Ed Elliott
All Spark Connect Posts Introduction There have been quite a few changes in the last...
A New Word: Ochisia
By Steve Jones
ochisia – n. the fear that the role you once occupied in someone’s life...
Create a Numbers Table in Power Query
This is a quick blog post, mainly so I have the code available if...
Forums
Need help with GROUP BY...
Here's my data... I am trying to return total days in status for each...
Need help with GROUP BY...
Here's my data... I am trying to return total days in status for each...
Question of the Day
The Density Vector
When building statistics, there is the concept of density that refers to the duplicates in a table. How is this calculated?
See possible answers