Uncovering how the data 'works' in a business is harder than you might think. You can't get this knowledge second-hand from the IT department. You have to speak to the business at large. However, many people are fearful of the 'bod from IT' and the change that their IT initiatives will bring.
I have heard the new Power BI Desktop can screen scrape data off websites; how does that process work?
Today we have a guest editorial from Andy Warren that looks at the way some companies look to hire new workers.
Observing an index seek utilizing a composite index within SQL execution plan might be more than meets the eye – you should look again.
Measures such as using special characters and numbers within a password are of little use to security if passwords are then stored in an insecure way. Sergey Gigoyan explains how to encrypt and store passwords in a SQL Server database.
Today Steve Jones asks about your job and if you get to pick the things you work on or is most of your time assigned to tasks by someone else?
In this chapter, we will talk about the competition of Data Mining
In this chapter, we will talk about the competition of Data Mining
There is plenty that is novel and perhaps foreign to a new R user, but it's no reason to abandon your hard-earned SQL skills! In this article, Casimir Saternos explains that not only can you easily retrieve data from SQL Sources for analysis and visualisation in R, but you can also use SQL to create, clean, filter, query and otherwise manipulate datasets within R, using a wide choice of relational databases.
Part 2 of Steve Jones' series on version control. This article examines how you can track the changes you have made in a development cycle.
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