31 March 2020
31 March 2020

Using PowerShell to Control Visio

0
Note: Please be kind on my PowerShell programming techniques. If I am doing something really horrible, let me know. I will change my code. As our team struggles to get to a place where we can do continuous integration, some of the biggest issues we have needed to work on is figuring out how to … Read more
29 March 2020
29 March 2020

Microsoft Data Platform 2020

1
From last November 4 to 8 I have been at PASS Summit in Seattle, attending excellent technical sessions and having the honour to deliver a  lightning session, which is a small 10 minutes presentation. Why should you read this? Being one of the biggest data events in the world, PASS Summit usually exposes the present and … Read more
01 March 2020
01 March 2020

Identity column vs ETL Process

Creating ETL process can pose so many challenges we will only fully discover them when really building the ETL. Before you complain about modelling, the example here has no relation to data warehouse modelling. The ETL in question was a migration from a data source to another. The need for executing multiple times was mainly … Read more
19 February 2020
19 February 2020

Grappling with sp_describe_undeclared_parameters(). The Hows, Whys and Wherefores.

3
sp_describe_undeclared_parameters() promises a great deal, but delivers less. It was added mostly for executing application queries via sp_prepare using a TDS link, but has several quirks and restrictions that rather spoils its more general use. It is designed to provide you with all the parameters of a batch. You might use it when a SQL … Read more
18 February 2020
18 February 2020

Women in Tech – where are you?

0
That’s a strange title I hear you say but it’s an honest question.  I’ve worked in IT now for over 20 years and have got used to working in an office full of men.  In my current role out of about 10 members of the technical team there are 2 of us which, makes it … Read more
17 February 2020
17 February 2020

Using sys.dm_exec_describe_first_result_set_for_object. The Hows, Whys and Wherefores.

5
I’ve been working on a project unkindly nicknamed ‘The Gloop’ because the code is a bit amorphous. Basically, it is an approach to documenting SQL Server databases, using the facilities provided such as the metadata views and DMFs. Although it is relatively simple to record the result returned by a table-valued function I’d rather neglected … Read more
02 January 2020
02 January 2020

Power BI and Excel

4
Power BI and Excel are tools so close to each other that Power BI was born inside Excel. Power Query, Power Pivot, Power View, they were all Excel plugins before being united and become Power BI. The ability to build an ETL, design a model and generate reports and dashboards with great storytelling make Power … Read more
10 October 2019
10 October 2019

Programmer Gear: Thin Apple Watch Band

0
This blog is different than my normal T-SQL blogs I almost always do. But I know that I cannot be the only computer programmer who wants to wear a smart watch when working to get some of the health and alert benefits that they can provide. The band though, has always been a blocker to … Read more
30 September 2019
30 September 2019

The Case of the Vanishing Index Compression

0
Recently, we started adding compression to some of our larger tables in our data warehouse where columnstore indexes didn’t make sense. (For example, some very large dimension tables, and a few facts where they are not used for large aggregates in the common manner). The changes were checked into source control, we monitored performance, all … Read more