Time Intelligence is a common methodology in Dimensional Modeling that allows for calculations of measures based on relative dates. These include “To-Date” measures like Year to Date or Quarter to Date as well as Previous Period comparisons. Once these are created within a model, other DAX functions can be used for metrics like Year over […]
2019-07-10
4,132 reads
Introduction Instead of going straight into the topic of the Query Store, I would like to start this Stairway Series by mentioning a few performance tuning scenarios that are very common to production DBAs. I think most of us have been in one of these situations at some time: An application experiencing slowness after a […]
2020-10-07 (first published: 2019-05-13)
5,726 reads
In this level, learn about how to get the tools needing for coding in R and how to execute some code that connects to SQL Server.
2019-05-06
5,238 reads
The second level of the Stairway to Database Containers looks at the basics of persisting storage in your containers.
2019-02-25
1,264 reads
In the first level of the Stairway to Database Containers, we learn how to get started with Docker for Windows, downloading an image, and starting a container.
2019-02-04
3,331 reads
SSAS (SQL Server Analysis Services) is available in two modes, tabular and multidimensional. The new tabular model is easier for those companies who are not already invested in the traditional, multidimensional model. In this stairway, Thomas LeBlanc will teach you how to create tabular models used for reports and dashboards.
2018-06-13
9,401 reads
This level of the Stairway to Exploring Database Metadata focuses on indexes and all the information you can gather about them.
2020-08-05 (first published: 2016-09-28)
4,468 reads
A guide to using Visual Studio to create U-SQL projects and scripts.
2016-07-20
2,830 reads
In addition to the data that our clients and customers store in a database, there is a tremendous amount of meta data, 'data about data', that describes how the database is set up, configured, and what the properties are for the various objects. This stairway aims to demystify and explain how you can query and use this meta data to more effectively manage your SQL Server Databases.
2016-07-15
3,345 reads
Learn about the permissions associated with Dynamic Data Masking as well as some of the security implications of using this feature.
2020-08-19 (first published: 2016-06-29)
6,163 reads
By kleegeek
This past Thursday, Edwin Sarmiento presented a session for our Microsoft Data Platform Continuity...
By Steve Jones
One of my goals this year was to build a report that I can...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
I inherited this code. Written by a 3rd party. I have 3 servers, 1...
We use a 3rd party vendor to administer our SQL Server service account PWDS....
This is a basic question which occurred to me while reading something on the...
Ask SSC