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.
Part 3 of Steve Jones' series on version control. This article examines how migrate your changes to your live systems.
Part 4 of Steve Jones' series on version control. This article examines how back out your changes from your live systems.
Part 1 of Steve Jones series on version control and SQL Server. This article examines how you can work with version control and SQL objects.
In this follow-up to a previous article, Aaron Bertrand reiterates that – while you should never just accept the defaults – you really should think about which options are most applicable to your scenario.
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...
hi , a new user wants to be able to add sql agent jobs...
Comments posted to this topic are about the item SQL Server Enum Implementation: A...
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers