In this first level of the SSAS Tabular stairway, learn how to implement and format a date dimension.

Data Control Language (aka Security)

by Additional Articles

SimpleTalk

Security

Like ancient Gaul, SQL is divided into three sub- languages. The DDL (Data Declaration Language) declares the data. This is where we find the data types, constraints, references and other structures that have to do with how the data stored . The DML (Data Manipulation Language) uses those declarations to change their contents or to invoke them. It does not change structures and schema objects.

An introduction to Terraform

by David Poole

SQLServerCentral

Cloud Computing

As a Data Engineer I found myself having to learn rather more about cloud infrastructure than I had expected.

Doing a Little Research

by Steve Jones

SQLServerCentral

Career Growth

I've been very pleased with the direction of SSMS the last few years. As it's been separated from SQL Server releases and gets updated more often, I think the changes from v17 though v20 have been improvements. There are still issues, but it's been better. Now we finally have SSMS moving to a modern shell […]

SQL IS NULL and SQL IS NOT NULL Examples

by Additional Articles

MSSQLTips.com

T-SQL

This article looks at how to use SQL IS NULL and SQL IS NOT NULL operations in SQL Server along with use cases and working with NULL values.

Lies You Should Believe - Anything is possible

by drsql@hotmail.com

SQLServerCentral

Database Weekly

We have all heard the saying I based this week's editorial on. It has been credited to Benjamin Franklin and goes like this, “You can do anything you set your mind to”. This is such a powerful way of thinking when you are starting a task. “I can do it, no matter what anyone says.” […]