We want to hear from you! Tell us what's important to you by sharing your insights and preferences for PASS Data Community Summit 2022. Community feedback is at the heart of everything we do for Summit and your insights will help guide our planning for this year's conference, taking place online and in-person in Seattle, November 15 - 18, 2022.
To troubleshoot poorly performing SQL in Oracle, you must understand which transformations the optimizer has made. Jonathan Lewis demonstrates several possible optimizations for one query.
Learn how to create a PostgreSQL database and work with it from Azure Data Studio.
Is DevOps and Agile better than waterfall? Steve has a few thoughts after a recent experience.
We need to transition our team from single instance management and monitoring to managing the overall environment and addressing our most pressing needs to support the organization. How can we move from managing the trees to managing the forest in an efficient and automated manner with a small team?
We’ve got some big plans for this year, and are looking to talk to people who use Flyway in a professional capacity. If you are willing to talk to us about how you first started using Flyway, then get in touch. Of course we’ll also look to say thank you for your time in our usual fashion.
I haven’t done it much the past few years, but I would answer some programming questions posted in forums back in the day. In the late 90s, I answered Visual Basic questions and eventually switched to SQL Server questions here on SQL Server Central as my career progressed. Answering questions not only assisted someone else, […]
In 2021, many companies had employees leave positions. The number of people resigning from their jobs was so high that the term "The Great Resignation" began appearing in many publications. A number of industries were affected, and there are no shortage of pundits and experts analyzing why. This happened primarily in the US, but the […]
This short piece shows how to add logging for the Delete activity and track which files or folders are deleted.
A data lake is a scalable data storage repository that can ingest large amounts of raw data and make it available on-demand. Robert Sheldon explains the benefits and challenges of data lakes.
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Many years ago, before I joined Oracle, I was working on a major modernisation...
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item SQL Server Still Wins
Comments posted to this topic are about the item DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers