Mahira Technology Private LimitedPromahiratechnology.hashnode.dev·3 hours agoUnlocking the Power of Streamlit within Snowflake: A Comprehensive Guide.Introduction to Streamlit on Snowflake :- In the fast-paced world of data science and analytics, the convergence of Streamlit and Snowflake is creating unprecedented opportunities for developers and analysts alike. Streamlit, an open-source app frame...Discusssnowflake
Shiv Iyerfor#AzureSQL #SQLServer #Azure #SQLazuresql.hashnode.dev·9 hours agoUnderstanding Internal Mechanics of Index Maintenance Operations in SQL ServerIndex maintenance in SQL Server is a crucial aspect of database management, aimed at improving query performance and ensuring data integrity. Over time, as data is inserted, updated, or deleted in the database, indexes can become fragmented. This fra...DiscussSQL
Shiv IyerProshiviyer.hashnode.dev·9 hours agoClickHouse for SQL Server DBAs - Optimizing Query Performance with Skipping Indexes in ClickHouseIn ClickHouse, narrow indexes, often referred to as "skipping indexes" or "data skipping indexes," are used to improve query performance by allowing the system to skip over blocks of data that do not match the query conditions. This is particularly e...DiscussSQL Server
sangramsstechlearn.hashnode.dev·10 hours agoCoding BasicsLearning Objective Understand fullstack web development Understand command line basics Step Frist:- ✅ Understand what full-stack web development is. You need to know a bit about how the internet actually works. check this video by VOX https://you...DiscussProgramming Blogs
Santosh Gsantoshthetechvisor.tech·11 hours agoValidating different types of data like Gmail, Outlook email addresses, phone numbers, and URLsValidating different types of data like Gmail, Outlook email addresses, phone numbers, and URLs in SQL can be a bit challenging since SQL is primarily used for data manipulation in databases and not for complex data validation. However, depending on ...DiscussT-SQL HUBData Science
Saloni Singhsalonisingh.hashnode.dev·11 hours agoLearning AWS Day by Day — Day 41 — Amazon Aurora — Part 2Exploring AWS !! Day 41: Amazon Aurora — Part 2 Aurora Replicas Autoscaling: scale the replicas based on the target value by adding or removing them. Best suitable for predictable workloads. Aurora — Custom Endpoints- Define a subset of Aurora Instan...DiscussAWS
Shiv Iyerfor#AzureSQL #SQLServer #Azure #SQLazuresql.hashnode.dev·11 hours agoMastering `sp_executesql`: Enhancing Security and Performance in SQL Serversp_executesql is a system-stored procedure in SQL Server used to execute a Transact-SQL statement or batch that can be reused multiple times, or to execute a dynamically built T-SQL statement. The primary advantage of using sp_executesql over EXECUTE...DiscussSQL
Shiv IyerProshiviyer.hashnode.dev·12 hours agoImplementing HyperLogLog for Efficient Cardinality Estimation in ClickHouseImplementing HyperLogLog in ClickHouse for approximate distinct count calculations is straightforward due to the native support for this probabilistic data structure. HyperLogLog is used to estimate the cardinality of a dataset—i.e., the number of di...DiscussClickHouse
Constantin Lungudatawise.dev·14 hours agoPay attention to cardinality & grain when UNNESTING in BigQuery!Whenever you're UNNESing an ARRAY, you're getting a Cartesian product between the row and the array contents. If you were to unnest another array, you'll get another Cartesian product between the output of the previous unnest and the elements in the ...DiscussPractical BigQuerySQL
Constantin Lungudatawise.dev·14 hours agoUnderstanding STRUCTS in BigQueryI've previously did a short intro post about ARRAYS in BigQuery, but I do see from time to time people that are just getting started become confused about how are they different from STRUCTS and when should we use them. Let's clarify this. STRUCT...Discuss·52 readsPractical BigQuerybigquery