by Ember Crooks | Sep 26, 2023 | DB2, mysql, snowflake, sql, SQL Language
Every database platform has a way to select from nothing. Sometimes we use it to generate data manually, sometimes we use it to get values of various system functions, but it is important to be able to do. Dummy Table Generally a dummy table is a dummy table that has...
by Ember Crooks | Aug 31, 2023 | DB2, snowflake, sql
As I’ve been learning about Snowflake, at least once a week, I find small things in the SQL or feature set that just make me happy. I really feel like Snowflake is meant for someone who loves SQL, but also someone who does other programming.… Read the...
by Henrik Loeser (data_henrik) | Aug 30, 2023 | conference, DB2, IBM, idug, IT
Well, check out the IDUG 2023 EMEA Db2 Tech Conference website. If you want to use the early bird rate to register with a heavy discount, you have to hurry up. It is only available until September 1st. There is another rebate available, but it only works once:...
by Henrik Loeser (data_henrik) | Aug 25, 2023 | administration, applications, DB2, Docker, IBM, Python
A quick post about a feature I have been asking for for several years: The Db2 driver for Python, ibm_db, has wheel support now. It means that the Python package distributes a pre-built binary with the Db2 driver (for many Python versions and most users). So far, in...
by Ember Crooks | Aug 17, 2023 | DB2, Featured, mysql
There are many ways to scale databases. One I was less familiar with before my last job is application-level sharding. While there are tools that work on some platforms to help you achieve application-level sharding (like Vitess with MySQL), the core work of this...
by Henrik Loeser (data_henrik) | Jul 5, 2023 | administration, DB2, ibmcloud, IT, security
Security feature in action: Trusted ProfileI trust you to know my old blog post about trusted contexts. Some years ago, I explained how to secure your Db2 database using trusted contexts. By establishing a trusted relationship based on specified attributes, the Db2...
Recent Comments