Understanding Outer Joins in SQL

• by jonfrisbee

• SQLServerCentral

• Outer Joins

The basics of outer joins are shown in this short piece that explains how they work.

Associating Data Directly with SQL Server Database Objects.

• by Additional Articles

• SimpleTalk

• 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?

• by Additional Articles

• Redgate

• SQL PROMPT

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.

Collections

• by Bogdan SAHLEAN

• SQLServerCentral

• Spatial

Problem The usage of a collection of integers in some scenarios is considered to be optimal because of the overhead involved by the creation of another user table used just to store numbers, which is the most common solution. What are collections of integers? They are lists or arrays consisting of integers. The number of […]

Learn from the Troubles of Others

• by Steve Jones

• SQLServerCentral

• Administration
• Career

Learning from the pain of others can be valuable in your career.

How to make your 2020 monitoring strategy a success

• by Press Release

• Redgate

• Conferences, Classes, Events, and Webinars

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

• by Additional Articles

• SimpleTalk

• Power BI

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

• by Additional Articles

• Redgate

• SQL Compare

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

• by Phil Factor

• SQLServerCentral

Until you open the box your data is, like Schrödinger's cat, both safe and breached.

Agile Job Descriptions

• by Steve Jones

• SQLServerCentral

• Career

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.