As business rules shift and data structures change, organizations need to be able to maintain and update their data catalog. Discover how you can implement an automated solution using PowerShell and Redgate’s SQL Change Automation.
Learn how to orchestrate your Databricks notebooks through Azure Data Factory in this article with a step by step walkthrough.
Phil Factor's manual for taming machines, applications, and other wild beasts.
Steve asks what you might want to achieve or accomplish in your career.
Handling weekends can be tricky in SQL. This article shows you how to Count the Number of Weekend Days between Two Dates
The SQL Server 2016 dynamic data masking feature may seem like a great way to obfuscate data for downstream systems like dev and QA. Joe Obbish shows us that the data can be “unmasked” with T-SQL statements, so it’s not secure against anyone who can write their own queries.
Apache TinkerPop is an open source graph computing framework. A graph computing network is a set of vertices and edges in the network. If we compare a graph database to traditional relational databases, we can assume that every row in a table of a relational database is equivalent to a vertex in graph network. Similarly, […]
Are computers getting smart enough to pass the Turing test or are humans getting worse at representing themselves as intelligent?
As business rules shift and data structures change, organizations need to be able to maintain and update their data catalog. Discover how you can implement an automated solution using PowerShell and Redgate’s SQL Change Automation.
In this article we look at how you can use SSMS to filter objects, debug, drag and drop object names, add custom reports and use of operators for emails.
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Jl. Daan Mogot No.KM. 11, Wisma SSK, Kecamatan Cengkareng, Kota Jakarta Barat, Daerah Khusus...
Jl. Pesanggrahan Jl. Puri Kencana No.28 29, Kembangan Sel., Kec. Kembangan, Kota Jakarta Barat,...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers