In this article, Phil Factor explains how to apply SQL formatting styles as part of an automated process, using the SQL Prompt command line formatter, with examples of bulk applying styles from the command prompt, PowerShell or a DOS batch.
IN and NOT IN subqueries are frequently used in Oracle. Jonathan Lewis explains how the optimizer handles NULL with IN and NOT IN.
Learn how to protect production resources from accidental changes in Azure Data Factory.
The idea of a Chief Data Officer is growing in many companies. Steve thinks this is a good thing.
Share your knowledge and insights at the world's largest gathering of data platform professionals! The PASS Data Community Summit conference is going hybrid this year, and whether you're planning to attend in-person in Seattle or online, this is your chance to reach a global audience and advance your career as a speaker. If you're an expert in a data-related topic, we want to hear from you. Speakers of all experience levels are welcome to submit a proposal and the Call for Speakers is open until March 31. Registration also opens on March 24, so don't miss your chance to register for Summit's homecoming in Seattle at early bird pricing.
The SQL language is used across many relational database platforms. Greg Larsen explains the basics of the SELECT statement for SQL Server.
Introduction to Query history and server reports i...
The way different generations use computers could affect how we built software tools.
DevOps is a buzzword thrown around a lot. But what does it mean for you as a DBA? And how can the whole team work together to achieve peak performance across multiple projects? Join Kathi for the discussion.
We've released a minor version of SQL Monitor, v12.1, that includes two exciting new features: ‘Tagging’ and a ‘Current Activity’ page. In a nutshell: tags allow you to record aspects of a server so that you have information at your fingertips, and the Current Activity page directly queries the monitored server when you open it to get the most up-to-date information possible. It’s all part of our commitment to making SQL Monitor the best monitoring tool out there!
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...
WhatsApp: 0817839777 Jl. Jend. Ahmad Yani No.91, Magersari, Panjunan, Kec. Kota Kudus, Kabupaten Kudus,...
WhatsApp: 0817839777 Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50133
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