A Self-Serve System that Allows Developers to Refresh Databases (Part 2)
Dive deep into the details of part 2 in this series of creating a solution so Developers can start a restore of Production to test.
2019-05-09
4,298 reads
Articles
Power BI and The Matrix: A Challenge
The Matrix is one of the many built-in visualizations found in Power BI. While the Matrix is easy to populate, filtering it is not so straightforward. In this article, Dennes Torres explains how to add a slicer that does the job.
2019-05-09
How to Build an Efficient Request Process for SQL Server DBAs
Take a look at some of these DBA request examples and things you could do to improve your request process.
2019-05-08
A tour of the Execute Package Task
Introduces modular programming with the Execute Package task, and shows bi-directional parameter passing.
2019-05-07 (first published: 2014-07-24)
1,933 reads
MDX (MultiDimensional Expressions) in 148 minutes
If you want to understand the fundamentals of MDX in less than 3 hours - this article can be helpful.
2019-05-07
10,291 reads
Using Azure Data Studio with TFVC
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I've written a few articles on how ADS works, shown here: Getting Started with Azure Data Studio Getting Comfortable Writing Code in Azure Data Studio Using Notebooks in Azure Data Studio Using Azure Data Studio with TFVC Using Azure Data Studio with […]
2019-05-07
5,456 reads
Microsoft SQL Server: Current Identify Column Value in a Table
Learn how to find the current identify column value in your Microsoft SQL Server tables.
2019-05-07
Enable SQL Server Agent Mail Profile
Learn how to configure SQL Server Agent to allow emails to be sent for job notifications and alerts.
2019-05-06
The BI Journey: The Expert’s Advice – Part 2
A BI project should return value to the company quickly, not only after months or even years of work. In this article by Gogula Aryalingam, Ruthie, the intern, determines which items from her manager's requirements she can complete before the big meeting. She continues working on her semantic model by including a Date table, the star schema, measures, formatting, and more.
2019-05-06
The Difference Between Rollup and Cube
Learn about the fundamental differences between the ROLLUP and CUBE operators.
2019-05-03 (first published: 2017-11-30)
86,896 reads
Blogs
In Memory of Andrew Clarke, AKA Phil Factor
By Steve Jones
One of the parts of getting older that really sucks is I seem to...
Leading Through the Noise: Harnessing Data in the Age of Digital Overload
By Chris Yates
The New Leadership Frontier In today’s digital landscape, leaders are no longer just visionaries....
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Forums
taking the rcsi dive
Hi, we put together an extract that runs every 15 minutes against what i...
Parameter Sensitive Plan Optimization in SQL Server 2022
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...
Minimum Change Tracking Retention
Comments posted to this topic are about the item Minimum Change Tracking Retention
Question of the Day
Minimum Change Tracking Retention
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=xxx);What is the minimum amount of time I can set? See possible answers