19 February 2020
19 February 2020

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

2
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.

4
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
16 June 2019
16 June 2019

A Father’s Influence

0
My dad and I had a very interesting and complex relationship. Some of this was due to his complex upbringing. His father was an alcoholic who died fairly early in his life, and his mom, well, his mom liked me a lot, but she was a messed up woman in many ways. After his father … Read more