Data Analysis Without a Server
The ability to analyze lots of data on a workstation can be a way to test things without overloading server systems until you are sure your code works.
Redgate Streamed Returns
Our virtual community event is back with a global feel. Featuring speakers including Donovan Brown, Abel Wang, Kendra Little & Damian Brady, we have a full day of live content & networking opportunities, spanning world-wide time zones. So, wherever you are in the world, join us live on Wednesday August 26.
Subset in R including List, Data Frame, Matrix and Vector
In this article we will examine the R Language subsetting operators, types of subsetting and differences in behavior for different R objects like vectors, lists, and data frames.
An Introduction to Azure Synapse Analytics Workspace
Introduction The Azure Synapse workspace is in preview mode as of July 2020. The workspace brings together enterprise data warehousing and big data analytics. This workspace has the best of the SQL technologies used in enterprise data warehousing, Spark technologies used in big data analytics, and pipelines to orchestrate activities and data movement. Here, I […]
Looking Back at Software Development Trends
Steve looks at some of the software development trends from last year, and if they apply today.
Clarifying Data Warehouse Design with Historical Dimensions
The standard data warehouse design from Kimball with facts and dimensions has been around for almost 25 years. In this article, Vince Iacoboni describes another way to design slowly changing dimensions.
Deployment Suite for Oracle: What’s New? Git Integration in Redgate Change Control v3.0
In Redgate Change Control v3.0, you can now commit your database changes to your local Git repository and collaborate with your team by pushing and pulling changes from the remote Git repository. If you’re using branches, you can also create and switch Git branches from within Redgate Change Control.
Of Hedgehogs and Database Design
One of the finest songs of the sixties had the following lines … "Sitting one day by myself, And I'm thinking, "What could be wrong?" When this funny little Hedgehog comes running up to me, And it starts up to sing me this song. Oh, you know all the words, and you sung all the […]
Native SQL Backups for Amazon RDS Databases
Use native SQL Server backups with Amazon RDS databases to easily import and export data between local server and the AWS cloud.
What's the Bus Factor?
Today Steve asks about the people that might be critical in your organization.
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat Kantor BCA KCU KUDUS Telp:0817839777
WhatsApp: 0817839777 Jl. Jend. Ahmad Yani No.91, Magersari, Panjunan, Kec. Kota Kudus, Kabupaten Kudus,...
Alamat Kantor BCA KCU SEMARANG Telp:0817839777
WhatsApp: 0817839777 Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50133
Question of the Day
BIT_COUNT I
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