Today, Grant talks about how he built his online brand.

Month-over-Month calculation using DAX in Power BI

by aveek22

SQLServerCentral

DAX
Power BI

Introduction Period-over-period is an analysis technique in business that measures some value in the present and compares it to the same measurement in a comparable period of time in the past. The goal is to adjust the slice of the past you are viewing, so the same amount of time has passed in the two […]

Basic Concepts of Probability Explained with Examples in SQL Server and R

by Additional Articles

MSSQLTips.com

Many organizations have known the fact that data have been evolved from the by-product of corporate applications into a strategic asset [1]. Like other corporate assets, the asset requires specialized skills to maintain and analyze. With modern data analytic tools, for example Python, R, SAS and SPSS, IT professionals can build models and uncover previous unknown knowledge from the ocean of data.

But the Database Worked in Development! Preventing Broken Constraints

by Additional Articles

SimpleTalk

DevOps and Continuous Delivery (CI/CD)

Database table constraints such as foreign keys and default values ensure reliability of the data. In this article, Phil Factor demonstrates a way to find any data that breaks the build so it can be corrected before deployment.

Towards an efficient interface between application and database

by Phil Factor

SQLServerCentral

As JSON documents becomes increasingly widely used, as the interface between application and database, Phil Factor reckons it's about time JSON Schema was built-in to SQL Server, alongside XML Schema.

Benefits

by Kathi Kellenberger

SQLServerCentral

Career Growth

Today, Kathi Kellenberger talks about the benefits that make working better.

Should I Type * or 1 With the EXISTS Logical Operator

by Viacheslav Maliutin

SQLServerCentral.com

T-SQL

In my project I see that people writes different things with EXISTS logical operator (EXISTS (SELECT StarOrOne FROM...)). They are "*", "1" and even "TOP 1 1" or "TOP 1 *". The aim of this article to give a good explanation which option is the best.

Monitoring SQL Server with Splunk and SQL Monitor

by Additional Articles

Redgate

SQL Monitoring

Splunk is a search engine for collecting and analyzing all sorts of "machine data", including log data and metrics for SQL Server. SQL Monitor gives you the detailed diagnostic view of all your SQL Server instances, and databases. If you have Splunk to monitor your applications and server infrastructure, and SQL Monitor to help you understand the behavior of a complex database system such as SQL Server, then you have a powerful and capable monitoring tool set.