SQL Update Statement with Join in SQL Server vs Oracle vs PostgreSQL
In this article we look at the different SQL syntax you need to use when updating data when joining tables for SQL Server, Oracle and PostgreSQL.
Building SQL Memorial - Automating Updates
In my last article, I wrote about the SQL Memorial structure for publishing information on the Internet for others to view. I had chosen Jekyll as a way of taking information in files and publishing it as a good looking website. However, I don't want to manually run Jekyll and copy the results to a […]
Impact Minutes
When downtime strikes, we may have to make decisions about which systems to focus our efforts upon. Steve talks about the impact of a disaster on your choices.
Finding Inactive SQL Server Databases
Phil Factor demonstrates how to use Extended Events to detect acquisition of Intent locks, and so determine which databases are active or apparently 'dormant', and then on which tables data has been modified recently, or which views and stored procedures have been run.
Power BI Theme Generator New Methods and Customizations
New methods and usage for themes were recently introduced for Power BI and in this article we cover how you can use these and customize them for Power BI.
Building SQL Memorial - Getting Started
Introduction One of the projects I've been wanting to tackle for some time is putting up a memorial for those people that our community has lost. I talked about it when Dwain Camps passed, and I kicked myself for not having something available when Tom Roush passed. Recently Gareth Swanepoel suddenly left us after COVID-19 […]
Remembering the Past
We had unfortunately lost quite a few members of our SQL Family. We have a new way to remember them.
SQL Server interview questions for experienced developers
SQL Server tech interview questions must be well crafted to make sure the candidate actually knows the topic. In this article, Sergey Gigoyan provides his favorite questions for interviewing SQL Server developers.
Getting started with the SQL MERGE statement
This article is focused on beginners who have already started writing SQL queries and are now diving deep towards more data processing and complex queries in SQL. When we talk about data processing, an important concept that comes to our mind is performing ETL workloads to a data warehouse. ETL is a very complex topic […]
Live versus Stored Data
Is it always important to have the most current data? Steve notes that you might need to make a decision here.
Blogs
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Forums
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Going Native with Fabric Spark Pools: The Fabric Modern Data Platform
Comments posted to this topic are about the item Going Native with Fabric Spark...
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers