Extended Properties on Stereoids: Document multiple properties easily with Data Dictionary Creator

Extended Properties on Stereoids: Document multiple properties easily with Data Dictionary Creator

Comments 0 Comment

Meet Extended Properties Microsoft introduced Extended Properties in order to document SQL Server Objects. Take a close look…there’s a plural “s” at the end. This allows great flexibility for you to come up with your own extended properties. But there’s a downside to documenting your custom properties: It is time consuming. You would either have to script them all…which is a bit clumsy with all this levelxtype and levelxname. Alternatively set out on a journey with clicking through a lot…

Read More Read More

Document a database with SchemaSpy using integrated

Document a database with SchemaSpy using integrated

Comments 2 comments

SchemaSpy is a great free open source software for database documentation. You can get a first glimpse of this awesome tool by viewing the sample output. This blog post shows how to configure SchemaSpy to connect to a database using integrated authentication with MS AD  (your windows login) in a Windows environment. Please follow the steps outlined in my previous blog post to setup SchemaSpy. I would also recommend testing to connect with a SQL username and password first in…

Read More Read More

Install SchemaSpy to document a SQL Server Database

Install SchemaSpy to document a SQL Server Database

Comments 0 Comment

SchemaSpy is a great free open source software for database documentation. You can get a first glimpse of this awesome tool by viewing the sample output. This blog post shows how to get SchemaSpy up and running in a new Windows environment and how to document your SQL Server databases.       (to execute a class) … If “command not found” is returned or similar error messages adding java to the path didn’t work Here’s an example…you will have to change…

Read More Read More

Better leave pies for dessert

Better leave pies for dessert

Comments 0 Comment

Example of an odd data viz I recently received mail with the following dataviz that made me chuckle and think: You might think, what the heck is that all about? In my home town an election for a new mayor will happen soon. One of the candidates asked all voters what they consider to be important from predefined categories. One important detail is, that you naturally could pick multiple answers. Just have a look at the percentages and ask yourself…

Read More Read More

Reflections on my session at PASS Data Community Summit 2022

Reflections on my session at PASS Data Community Summit 2022

Comments 0 Comment

It has been just on week since PASS Data Community Summit took place in Seattle and online. I attended from home but more importantly delivered my own brand-new session there (wooohooo!). Here I would like to quickly share some reflections on it. Summit It was an awesome experience being able to present at Summit. I visited the event in Seattle in 2019 in person. To be honest with you dear reader….being the first time in the US didn’t blow my…

Read More Read More

Beware of floats

Beware of floats

Comments 0 Comment

I am currently volunteering as an instructor to teach young women about Data & SQL. Right in the first module we covered core data types as shown here: For this blog post I’d like to write about FLOAT and DECIMAL and why in most cases I think that DECIMAL is a much better choice. Approximate values According to the MySQL documentation float (and double) represent approximate numeric data values This is the reason where the general problem comes from. But…

Read More Read More

Continue your learning journey in SQL

Continue your learning journey in SQL

Comments 0 Comment

It has already been three weeks since the end of the Code First Girls course on Data & SQL. We have celebrated the achievements on LinkedIn. I am greatly impressed by the final projects of my students. This article is for them to show possibilities how to continue learning SQL and excel as well as for others who have just begun their journey with SQL. It is well-known that practice is essential for mastering any new subject learnt. One way…

Read More Read More

Attending SQLBits as a virtual participant

Attending SQLBits as a virtual participant

Comments 0 Comment

This week has been great for me as a learning opportunity by going to SQLBits for the first time ever. Well…actually not going but logging in from home watching online. So as SQLBits as all good things is petering out/comes to an end time to do a personal summary. Blogging I aimed to to a summary blog post for each day. However eagle eyed readers will notice that I stopped on Thursday which was the first conference day. Reason for…

Read More Read More

Notes from SQLBits Conference Day 1

Notes from SQLBits Conference Day 1

Comments 0 Comment

I’ll try to highlight the top takeaways per session from my side. Keynote – Level Up with Azure Data This was an entertaining show by Microsoft’s Bob Ward and Buck Woody . They pretended that Bob has a dream about presenting and could do everything. Great consequence was that they had a lot of great people from the Microsoft Team invited presented including Pedro Lopes, Anna Hoffmann, Patrick Leblanc (Guy in a cube) and much more. Demos were given with…

Read More Read More

SQLBits: Notes from Adam Jorgensen’s PreCon “Thriving as a technical leader”

SQLBits: Notes from Adam Jorgensen’s PreCon “Thriving as a technical leader”

Comments 0 Comment

This is part 2 of my series on learning at SQLBits. Today I had the pleasure to learn from Adam Jorgensen what it’s like to be a leader and how you can thrive being one. My personal motivation for this ist that I have been doing work as a BI engineer for over a decade now and am currently evaluating how to move on.# The session was truly worthwile…Adam kept it very interactive and Victoria Holt made sure that the…

Read More Read More