Anyone Can Click Through Once
Using some sort of scripting or automation is important for your career.
Gitflow Workflow Hotfix Branching for SQL Database Projects
Git is a great tool for source control and in this tip we look at how you can utilize Git source control to build and deploy database hotfixes.
Upgrade PostgreSQL 9.X to 12.X in Windows
Learn how you can upgrade a PostgreSQL server and ensure your databases follow to the new version.
Melissa Data Quality Solutions for SSIS
For organizations relying on the SQL Server, Melissa's solutions directly integrate with SSIS, so the learning curve is minimal. You can drag and drop Melissa components in SSIS to validate, cleanse, append and enhance data.
What will you learn at the Redgate Summit?
There's just 1 week left until the Redgate Summit: The Future of Database DevOps. Check out this blogpost for what's in store, spoilers from our speakers on what they're most excited to share on the day, and why you should attend.
AI Can Improve Healthcare
One area where AI has found some traction is in the healthcare industry, where is seems to be helping improve care.
SQL Server Extended Events Filtering by Database Name
In this article we look at how to properly filter out events using a database name pattern in an Extended Events Session.
What's the Quarantine state in Windows Failover Clusters
In this article we cover why Windows Failover Cluster nodes can go into a quarantined state, how to resolve this as well as how to set threshold values for this cluster node state.
Let it go
I’ve been digging through the 18 years’ worth of articles, editorials, blogs, contests, interviews, promotions, and announcements over at Simple Talk. There are over 5000 posts, and many are quite outdated, especially those announcing beta versions of software or other time-sensitive content. Some articles haven’t seen the light of day for 10 years, yet some […]
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 BCA KCP Ampera Tlp:08218154393
WA:08218154393 Gedung Aurum, Jl. Ampera Raya No.37, RT.8/RW.2, Cilandak Tim., Ps. Minggu, Kota Jakarta...
ALAMAT BCA KCP Mayestik Tlp:08218154393
WA:08218154393 Jl. Kyai Maja No.77, RT.12/RW.3, Gunung, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah...
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