My Time is Valuable
Spending time on low value tasks isn't often worth the cost for highly paid employees.
A data transformation problem in SQL and Scala: Dovetailing declarative solutions
This article is an interesting approach to solving a data transformation problem in SQL and Scala. Shel Burkow uses a SQL execution plan for software design.
Every IT Organization is a Snowflake
Some people think every IT department is unique. While that might be literally true, Steve doesn't think that is actually the case.
Stairway to SQL Server Security Level 2: Authentication
Authentication is the first step in letting a principal get access to an instance of SQL Server, essentially resolving the question, Who are you? In this stairway level you’ll learn about the basics of authentication and the authentication options available. This level covers logins and users and you’ll learn about the password policies that can help strengthen SQL Server authentication.
Encrypt and Decrypt Passwords in SQL Server with PowerShell
In this article we look at how to securely store data in text files that could be used for SQL Server authentication or wherever you need to keep data secure.
Unlocking the “PASS Pro” Educational series
Thanks to the consent of the speakers, the expert-led educational training courses covering the following four topics: Data Modernization, Azure Migration, Azure Synapse, Azure SQL, are now available to all. You can watch the sessions and learn from a range of experts online, for free.
Take Care of People
The transformation of a way of working is hard, but it's important to realize this is more than just technology. This also includes people.
Using Non-SQL Languages in Azure Data Studio
In this article, we examine the support for non-SQL languages in Azure Data Studio, primarily PoSh and Python.
Delete SQL Statement in SQL Server, Oracle and PostgreSQL
Learn about the differences and similarities when deleting data from SQL Server, Oracle and PostgreSQL with the several examples in this article.
Reusing Query Results in SSMS
Every time you need to reuse the query results from SSMS, for example to populate another table, or to search for matching rows in another table, it will inevitably mean a lot of manual tweaking to the get the results into the right format. Louis Davidson uncovers three SQL Prompt gems that can remove all this pain.
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 Resmi BCA KCP Gorontalo Tlp:08218154393
WA:08218154393 Jl. Nani Wartabone No.293, Limba U I, Kota Sel., Kota Gorontalo, Gorontalo 96111
Alamat Kantor Resmi BCA KCP Ratulangi Tlp:08218154393
WA:08218154393 Jl. Dr. Sam Ratulangi No. 7, Kompleks Ratulangi Office Park Blok A3-A4, Kota...
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers