Introduction In response to my approach in the popular MDX Guide for SQL Folks series, I am using SQL as a good frame of reference for starting or developing a new approach for improving your Data Analysis Expression(DAX) language learning experience. This is useful for developers starting to learn the DAX language to more advanced developers who […]
When you’re first approaching a SQL Server, start with sp_Blitz. We’ll cover my favorite parameters and what I look for in the results, and then start building our notes in Markdown for our eventual health check recommendations for the rest of our team.
Artificial Intelligence hasn't always worked well, but there is one place that is seems to have lots of potential.
SQL Server 2019 has introduced several new features that offer improved performance. The optimizer continues to evolve and get smarter.
Steve prefers having standards, and today notes that aliases should be included in your standards document.
Learn how to build your first Azure Data Factory Pipeline
Diogo Souza completes his series on CQRS. He demonstrates Event Sourcing to capture the data as it flows through the system which can then be analyzed without affecting the source.
A few years ago I had a requirement to allow both developers and customers to see rows from a table used to store error information while making sure that any PII, PCI or similar sensitive data was not displayed. The tolerance for “oops” was low! This article presents one way to solve the challenge by […]
There are contests to break encryption algorithms taking place all the time. Another one was completed recently.
Setting up SQL Monitor without a bit of preparation work is a bit like embarking on a road trip without first learning to drive. Phil Factor show the essential kit and route maps you need for the journey.
By Steve Jones
This happened to me recently after being busy with non-data modeling tasks for a...
By Arun Sirpal
Every major model out there can summarise documents, write code and answer multi step...
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Hi everyone, I’ve been looking into using AI for helping with data-related tasks (writing...
Graha Elok Mas, Jl. Panjang No.79 EF, RT.6/RW.1, Kedoya Sel., Kec. Kb. Jeruk, Kota...
Jl. Daan Mogot No.48 A, Jelambar, Kec. Grogol petamburan, Kota Jakarta Barat, Daerah Khusus...
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers