SQL Shack - articles about database auditing, server performance, data recovery, and more » Steve Simon

Introduction Late in October, I received an unusual request from the head of sales within one of my client sites. Sales sells three articles: bread, perfume, and Jaguar motor cars. Now the reader...

https://www.sqlshack.com/reporting-sql-server-using-calculated-expressions-within-reports/

Introduction As many of you by now know, I am a fan of utilizing expressions within Reporting Services reports to add additional flexibility. Recently I received a client request to create a stac...

https://www.sqlshack.com/use-expressions-within-sql-server-reporting-services-create-efficient-reports/

Introduction An interesting opportunity arose at a client site during early October which provided a phenomenal opportunity to do a Data Quality Services implementation. My client (a grocer) had ...

https://www.sqlshack.com/use-sql-server-data-quality-services-ensure-correct-aggregation-of-data/

Introduction With Christmas just around the corner, in today’s “get together” I thought that we would have some fun by cataloging a collection of ‘your favorite items’. Whether it be a ...

https://www.sqlshack.com/create-image-cataloging-system-using-sql-server-repoting-services/

Introduction Last month I ran two Business Intelligence pre-conferences in South Africa. A interesting request arose during the course of the preconference in Cape Town. The individual wanted an ...

https://www.sqlshack.com/effectively-extract-data-from-olap-cube-by-relying-upon-tsql/

Introduction In many of our past “get togethers” we have discussed pivoting raw data in order to best represent corporate data within our business reporting. As we may remember, in many insta...

https://www.sqlshack.com/reporting-sql-server-manipualting-data-via-grouping-functions-provided-by-tablix-control/

Introduction As we are nearing the end of the North American summer, I thought that we would take a lighter look at nifty ways of reporting information. In today’s “fireside chat” we have a...

https://www.sqlshack.com/reporting-sql-server-customize-visual-appearance-of-your-reports/

Introduction A few weeks back, I was approached by a client who lives in Cape Town, South Africa. The data that he wanted to insert into Master data services was far from clean and he was wonderi...

https://www.sqlshack.com/clean-master-data-services-data-using-data-quality-services-in-sql-server/

Introduction In our last “fireside chat” we discussed a few of the challenges that the HR Manager of a major hardware chain was experiencing. Mary Smith, the HR manager has since approached u...

https://www.sqlshack.com/repoting-sql-server-combine-three-reports-into-one-using-sql-server-data-tools/

Introduction With today’s challenging economic times it has become more and more important to manage and rectify changing sales patterns and trends. In today’s “get together” we shall be ...

https://www.sqlshack.com/reporting-sql-server-combine-t-sql-and-dax-queries-to-produce-effective-reports/