Tag: query

Feed: Alation. Author: Nolan Necoechea. Nolan Necoechea Alation, data catalog, data collaboration, data culture September 22, 2020— In case you somehow missed it, last week Alation’s partner Snowflake, leading provider of cloud-based data warehousing solutions, had the biggest tech IPO of 2020. While everyone has Snowflake on the brain, we figured it might be a good time to remind you that Alation and Snowflake go together like hot cocoa and a snowy day. Enterprises investing in Snowflake for the flexibility and cost savings of a modern cloud data warehouse see a huge boost in analyst productivity and data culture with ... Read More

Feed: Planet PostgreSQL. I have no idea how I missed that, but: if it wasn't for Alvaro's blog post I wouldn't know that: on 7th of April 2020, Alvaro Herrera committed patch: Support FETCH FIRST WITH TIES   WITH TIES is an option to the FETCH FIRST N ROWS clause (the SQL standard's spelling of LIMIT), where you additionally get rows that compare equal to the last of those N rows by the columns in the mandatory ORDER BY clause.   There was a proposal by Andrew Gierth to implement this functionality in a more powerful way that would yield ... Read More

Feed: AWS Partner Network (APN) Blog. Author: Edwin Galang. By Edwin Galang, Cloud Solutions Architect at CohesityBy Girish Chanchlani, Partner Solutions Architect at AWSIt’s no secret that data is growing at a staggering rate, and the challenge for enterprises is how to manage this growth in a cost-effective manner. According to IDC’s Data Age 2025 whitepaper, published in late 2018, data will grow to 175 ZB by the year 2025, with an annual growth of over 60 percent per year. In addition to managing the data, CIOs are looking for ways to get insights out of the data so their ... Read More

Feed: Planet PostgreSQL. I've been digging a little bit into PL/Python recently-inspired by our recent launch of Crunchy Bridge: a multi-cloud Postgres service with PL/Python and PL/R built right in. One thing that has tripped me up a few times is how PostgreSQL data types work with Python - especially when using external packages like NumPy or SciPy. Data type mapping is something you'll deal with when working with different languages or trying to get separate systems to talk to one another. Mapping types isn't just related to PL/Python, in fact one colleague once wrote a program to interoperate from Ruby ... Read More

Feed: Planet MySQL; Author: Kristian Köhntopp; A question to the internal #DBA channel at work: »Is it possible to change a column type from BIGINT to VARCHAR ? Will the numbers be converted into a string version of the number or will be it a byte-wise transition that will screw the values?«Further asking yielded more information: »The use-case is to have strings, to have UUIDs.« So we have two questions to answer: Is ALTER TABLE t CHANGE COLUMN c lossy? INTEGER AUTO_INCREMENT vs. UUID Is ALTER TABLE t CHANGE COLUMN c lossy? ALTER TABLE is not lossy. We can test ... Read More

Feed: Neo4j Graph Database Platform. Author: Jocelyn Hoppa. The FinCEN Files InvestigationThe International Consortium of Investigative Journalists (ICIJ) has recently exposed a vast network of industrial-scale money laundering running through Western banks and generally ignored by U.S. regulators – and they used Neo4j to help crack the case wide open.The global investigation, dubbed the FinCEN Files, reveals how money launderers move their dirty money. From drug cartels and corrupt regimes to arms trafficking and other international crimes, these global banks have turned a blind eye – or even straight up refused to stop – as they earn huge profits from ... Read More

Feed: Planet PostgreSQL. I have previously written a blog post on the detailed steps involved in enabling PostgreSQL monitoring using PMM. In that post, you could see me talking about the role: pg_monitor that can be granted to monitoring users. The pg_monitor role restricts a monitoring user from accessing user data but only grants access to statistic views needed for monitoring. The following are the simple steps to create a monitoring user for using Percona Monitoring and Management (PMM). CREATE USER pmm_user WITH ENCRYPTED PASSWORD 'secret'; GRANT pg_monitor to pmm_user;CREATE USER pmm_user WITH ENCRYPTED PASSWORD 'secret'; GRANT pg_monitor to pmm_user;However, ... Read More

Feed: Microsoft Power BI Blog | Microsoft Power BI. Author: . Welcome to Microsoft Ignite! The world has fundamentally changed in 2020. Individuals have had to adapt to working digitally and independently. Teamwork and collaboration are done entirely through screens and entire organizations have become remote work forces. “We’ve seen two years’ worth of digital transformation in two months. From remote teamwork and learning, to sales and customer service, to critical cloud infrastructure and security—we are working alongside customers every day to help them adapt and stay open for business in a world of remote everything.” Satya Nadella, Apr 29th, ... Read More

Feed: Microsoft Power BI Blog | Microsoft Power BI. Author: . Starting this month, we have merged the Power BI Desktop, Service and Mobile blogs, so there is one overview of everything that is new in this month. Many thanks to Sujata and Nikhil for owning the Desktop and Service/Mobile blogs! We are planning several other changes to the blog, so stay tuned. After 10 years, support for Windows 7 ended on January 14, 2020. In line with this, we will be stopping support for Power BI Desktop on Windows 7 on Jan 31st 2021. After that, Power BI Desktop ... Read More

Feed: AWS Partner Network (APN) Blog. Author: Bill Tarr. By Bill Tarr, Sr. Partner Solutions Architect, AWS SaaS FactoryMany software-as-a-service (SaaS) organizations leverage AWS Identity and Access Management (IAM) as the backbone of their tenant isolation strategy. IAM enables organizations to define a series of policies and roles that can be used to ensure tenants are not allowed to cross tenant boundaries when accessing resources. The challenge here is that, to make this work, many organizations have to create separate policies for each tenant. This often creates an explosion of tenant policies which, in turn, can push the account limits ... Read More