Overview of ETL Architecture In a data warehouse, one of the main parts of the entire system is the ETL process. ETL is the system that reads data from the source system, transforms the data according to the business logic, and finally loads it into the warehouse. While fetching data from the sources can seem […]
2019-10-21
3,488 reads
Most SSRS reports are organized into grouping levels where it’s possible to add totals for each group. In this article, Kathi Kellenberger continues her SSRS series by walking through how to create both a Matrix and Table report.
2019-10-21
There are various ways we can deploy MSBI project deliverable. This article will give you an idea to automate MSBI deployments using Windows PowerShell.
2019-10-18 (first published: 2017-09-14)
2,948 reads
In this tip we look at a PowerShell script you can use to gather information about the installation date for all of your SQL Servers.
2019-10-18
Learn a little basic graph theory in this article that replaces a GROUP BY clause.
2019-10-17
4,451 reads
In this tip we look at how to read an Excel file from within SQL Server using OpenRowSet and OpenDataSource along with the possible errors you may encounter and how to fix these issues.
2019-10-17
In this tip we look at different scripts you can use to find when a SQL Server stored procedure was created, modified, last executed and to also return the code for the stored procedure.
2019-10-16
This free eBook from Redgate Software will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic look at Parameterization and Hints along the way.
2019-10-16 (first published: 2012-12-11)
54,472 reads
A common debate in table architecture is whether to use a natural or surrogate key. In this article, I discuss some of the advantages to each method.
2019-10-15
6,502 reads
In this article, you will explore tools and extensions that can be used with Visual Studio 2019 to improve your database experience irrespective of what database you use.
2019-10-15
In this episode of the podcast, Adrian looks at the scripting options available in...
By HamishWatson
So I started blogging in 2016: So why blog….now? It is very interesting going...
By Kamil
Hello folks! 2 weeks passed but eventually, I have some news for you. Press...
Hi, I've setup some publications and subscriptions today and use a backup to start...
Hi, There are a couple of SSIS package (2017) version developed by another...
Greetings, In the results tab, is there a keyboard shortcut to copy a whole...
Ask SSC