Poor Work Management
The future of work is uncertain, but not everyone is ready for remote work to continue.
The Azure SQL portfolio
Microsoft provides many ways to run SQL Server in Azure, but which do you choose? In this article, Robert Sheldon explains the Azure SQL options.
All the Tools in Your Toolbox
I recently began writing an article to compare the performance of several window functions to traditional query methods. I began with my favorite function, LAG, but soon found that there were so many other ways to write the query that the article never covered the additional window functions. The article was quite fun to write, […]
How to Flatten JSON in Azure Data Factory?
When you work with ETL and the source file is JSON, many documents may get nested attributes in the JSON file. Your requirements will often dictate that you flatten those nested attributes. There are many ways you can flatten the JSON hierarchy, however; I am going to share my experiences with Azure Data Factory (ADF) […]
Flyway Without the Typing
How to use Flyway configuration files to minimize typing during ad-hoc development from PowerShell or DOS; you just type in the Flyway commands you need and hit "go" and the config files take care of all the tiresome connection, authentication and project details.
Mount an Azure Data Lake Storage Gen2 Account in Databricks
In this article we will walk through a clear end-to-end process of securely mounting an ADLS gen2 account in Databricks.
Help Your Manager
Your manager doesn't always know what you're doing, and rarely knows what you've done. That's your job.
Prepare, Blend, and Analyze Salesforce Data in Alteryx Designer
The ODBC Driver for Salesforce from CData provides ODBC-based access to live Salesforce data, allowing you to interact with Salesforce data in a range of BI, reporting, and ETL tools — as well as directly using SQL queries. In this article, we demonstrate how to connect to Salesforce data using an ODBC connection in Alteryx Designer to conduct self-service BI, data preparation, data blending, and advanced […]
Text Mining and Sentiment Analysis: Oracle Text
Oracle has built-in functionality to analyze text. Sanil Mhatre demonstrates how to perform a sentiment analysis on data stored in a table using Oracle Text.
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Want to look at cloud reporting but not sure what the costs will be?
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
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 BCA KCP Saharjo Tlp,Cs:0821-8154-393
WA:08218154393 Jl. Dr. Saharjo No.149 G-H, RT.5/RW.4, Manggarai Sel., Kec. Tebet, Kota Jakarta Selatan,...
BCA KCU BLOK A CIPETE Tlp,Cs:0821-8154-393
WA:08218154393 Jl. RS. Fatmawati Raya No.6 A, RT.1/RW.5, Cipete Sel., Kec. Cilandak, Kota Jakarta...
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