Breaking Down DENSE_RANK(): A Step-by-Step Guide for SQL Enthusiasts
Learn how it works and how to use the DENSE_RANK() function in your code.
2024-04-12
3,178 reads
database
Forget the Models, Your Data is the Secret Sauce for Generative AI
Generative AI holds immense potential for businesses, but its success depends on the quality of your data. High-quality, strategically managed data is essential for building trustworthy, unique, and competitive AI applications. This article explores how AI leverages your data through embeddings, outlines best practices for data management, and emphasizes the importance of responsible AI development. By prioritizing data quality and effective management, you'll position your business to reap the full benefits of Generative AI and drive innovation.
2024-02-21
2,774 reads
SQL Window Functions Series: LAG() and LEAD()
Dive deep into the powerful SQL window functions, LAG() and LEAD(). Explore their intricacies, discover real-world examples, and avoid common pitfalls.
2023-12-11
5,673 reads
Different Ways to Populate the List of Tables
This article shows how you can query different types of tables, based on certain criteria that may be important to you. A good list of basics for any database administrator that will help you find tables in your database.
2023-10-06
1,458 reads
The SELECT Statement in Oracle
The SELECT statement is used to retrieve information from a database. Following the execution of a SELECT statement, a tabular result is held in a result table (called a result set). It allows you to select the table columns depending on a set of criteria. In this article, I will introduce the basic SELECT statement fetching data from just one table.
2023-06-21
7 ways businesses can improve the quality and speed of database releases
This article explains how these ‘ephemeral databases’ can be used to improve development and testing processes in ways that reduce the number of bugs entering the deployment pipeline, drive up the quality of database releases, and so improve the reliability and speed of database deployments to production.
2023-05-15
How to Find the SQL Server Instance Startup Time
Learn a number of methods to view or programmatically get the SQL Server instance startup time.
2023-05-12
6,098 reads
How to Automate Cross-Platform Database Development
In order to focus on their primary task of developing databases, the development team need to automate as many as possible of the routine tasks that are essential for database delivery, such as testing, scripting, version control, documentation, code review, reporting and so on. This article gives some advice on how to do it, faced with the added challenge of needing to use several different relational databases.
2023-04-28
Database Monitoring: The ROI of Build vs. Buy
In this webinar, Microsoft Data Platform MVP, Grant Fritchey, is joined by our expert panel to share the pros and cons to building a monitoring system versus purchasing one.
2023-03-27
Amazon RDS - Configuring a Connection to a SQL Server Instance
In this article, you will learn how to configure an RDS database for connections from client tools.
2022-11-23 (first published: 2022-11-21)
307 reads
Blogs
Why Data Analysts Love PostgreSQL (and You Will Too!)
Data analysis is all about wrangling massive datasets. To do that efficiently, you need...
How to Connect Your WordPress Site to the Fediverse
By Rob Sewell
Make it easier for your audience to engage with you by connecting your site...
What I learned volunteering at a children's summer camp
By Rayis Imayev
"Stories are where memories go when they are forgotten" - Doctor Who.(2024-Sep-13) As September quickly...
Forums
GIT Configuration and Automated Release for Azure Data Factory
Comments posted to this topic are about the item GIT Configuration and Automated Release...
How to Add a New Shared Disk to a WSFC as a SQL Resource
Comments posted to this topic are about the item How to Add a New...
Just for fun
Did you ever think that Moses was the first person to download data to...
Question of the Day
Disabling Indexes
I want to disable an index so that it doesn't use any resources and isn't maintained. I am planning to drop this, but don't want to do it now. The index is named LoggerNCI and was created on the dbo.Logger table, on the LogID column. What code disables this?
See possible answers