Understanding Outer Joins in SQL
The basics of outer joins are shown in this short piece that explains how they work.
Associating Data Directly with SQL Server Database Objects.
It is easy to attach details and documentation to a SQL Server database using extended properties. In fact, you can add a number of items of information to any database objects such as tables, views, procedures or users.
SQL Prompt 10: What’s New?
Tony Davis reviews the major new features of SQL Prompt 10, included improved 'ranking' of its code auto-completion suggestions, tab history improvements to make it easier to find 'lost' code, and auto-fixing of code that breaks code analysis rules.
How to make your 2020 monitoring strategy a success
Join Redgate’s Arneh Eskandari and BMW’s Tony Maddonna for a free webinar on Nov 20: How to make your 2020 monitoring strategy a success. Learn how to prepare for successful estate growth, expected trends for the year, and the role monitoring plays in engabling growth and stability in your organization.
Merging tables in Power BI dataflows with PRO subscription
Power BI dataflows is a powerful self-service ETL tool. However, some features demand the use of Power BI Premium, way more expensive than the PRO version and sometimes inaccessible. In this latest blog post Dennes Torres explores the subject.
Using Custom Deployment Scripts with SQL Compare or SQL Change Automation
Phil Factor describes how custom pre- and post-deployment scripts work, when doing state-based database deployments with SQL Compare or SQL Change Automation, and how you might use them to, for example, add a version number to the target database, specify its database settings, or stuff data into some tables.
Human frailty and the custodianship of data
Until you open the box your data is, like Schrödinger's cat, both safe and breached.
Agile Job Descriptions
Steve ends his week of career thoughts with a look at the job descriptions that we often use to decide if we want to apply for a job.
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCP Gading Square Tlpn/Wa 0853.7373.7551
Blk. B, Komplek Rukan Kelapa Gading Square, Jl. Boulevard Bar. Raya No. 21 &...
BCA KCP Gudang Peluru Telpon/WA:08137887595
BCA KCP Gudang Peluru Telpon/WA:08137887595.Komp, Jl. Gudang Peluru Raya Jl. Kp. Melayu Besar No.23...
BCA KCP Graha Inti Fauzi Telpon/WA:08137887595
BCA KCP Graha Inti Fauzi Telpon/WA:08137887595.Gd. Graha Inti Fauzi, Jl. Buncit Raya No.22 Lt....
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers