sql query

Sort By Search Results

Mastering SQL Query Generation with Azure OpenAIOct 09, 2024. Leverage Azure OpenAI to transform natural language into SQL queries seamlessly. By integrating Azure OpenAI and Azure SQL Database, you can simplify data querying and enhance accessibility. Learn how to set up the environment, construct prompts, and generate SQL queries using powerful AI models.
Understanding the SQL Query Execution OrderJul 22, 2024. SQL (Structured Query Language) is essential for interacting with relational databases, and mastering its intricacies can significantly enhance your data querying skills. One of the fundamental aspects to understand is the order of execution of SQL query clauses.
SQL Indexing: Boosting SQL Query PerformanceMay 06, 2024. Unlock the power of SQL indexing to supercharge your database queries with our comprehensive guide. Learn how indexing works, explore real-world examples, and discover essential tips for optimizing query performance. Dive into the world of database optimization and take your SQL skills to the next level.
Analyzing Sales Data with a Comprehensive SQL Query in Microsoft Fabric Data WarehouseNov 18, 2023. This SQL query is a powerful tool for in-depth sales analysis, utilizing joins and aggregations to break down sales data by account manager, payment type, and region in Microsoft Fabric Data Warehouse.
Query CSV File Saved In ADLS Through SQL Query - Azure Synapse AnalyticsNov 22, 2021. In this article, you will learn how to query CSV File saved in ADLS through SQL Query - Azure Synapse Analytics.
How To Import Data Directly From The SQL Query In Power BIJan 06, 2021. In this article, you will learn how to Import Data Directly from the SQL Query in Power BI
Comparison Of Different SQL Query Responses Of SQL Server On Windows And Ubuntu LinuxJul 26, 2019. The article consists of some benchmark tests of SQL Server on different Operating Systems, the parameters considered are CPU Time, Elapsed Time and Total Execution Time.
Azure Cosmos DB With SQL Query Cheat Sheet PDFSep 08, 2017. Microsoft Azure Cosmos DB supports querying documents using SQL (Structured Query Language) as a JSON query language. Cosmos DB is truly schema-free. By its commitment to the JSON data model directly within the database engine, it provides automatic indexing of JSON documents without requiring explicit schema or creation of secondary indexes.
Construct Readable XML Output From SQL Query From Two Or More Tables Using “For XML PATH” StatementSep 04, 2017. In my previous article I discussed about how to get a XML format output from query and process that by using XML AUTO statement, and I give different types of “for XML”.
Transform XML Output Of SQL Query To HTML Using "For XML" AUTO Statement With XSLT In C#Aug 21, 2017. Normally, we execute the query using ExecuteNonQuery statement and fill the output into data table. This article describes how to transform the XML output of SQL query statements using FOR XML AUTO to HTML using XSLT.
Dynamic SQL Query Injection And Its Prevention MechanismJun 20, 2016. In this article, you will learn about dynamic SQL query injection and its prevention mechanism.
Execute Long Running SQL Query Or Stored Procedure From .NETOct 21, 2015. This article describes the asynchronous call to MS SQL statements from .NET environment using C# to avoid UI or main thread freezing.
Import Data From Database Using Native SQL Query in Microsoft Excel 2013Mar 15, 2014. This article shows the powerful features of Excel 2013 to import data from a database.
Using The StoredProcedure With Select SQL Query in Web APISep 11, 2013. This article shows how to use a Stored Procedure in the Web API.
SharePoint SQL Query to Get Details on Disk Utilization and IOJul 24, 2013. In this article I will demonstrate SharePoint SQL Query to get details of Disk Utilization and IO.
Some Important Tips For SQL Query PerformanceJul 01, 2013. This article provides some important tips for SQL Query Performance.
Delete and Update Data With Raw SQL Query Via EDF FrameworkDec 31, 2012. Today, in this article let's play around with one of the interesting and most useful concepts in EDM Framework.
Insert and Update Stored Proc With Raw SQL Query Via EDF FrameworkDec 31, 2012. Today, in this article let's play around with one of the interesting and most useful concepts in EDM Framework.
Select Stored Proc With Raw SQL Query Via EDF FrameworkDec 28, 2012. Utilize Entity Data Framework (EDF) for selecting stored procedures with raw SQL queries. Enhance data access in your application by leveraging the power of SQL alongside EDF's object-relational mapping capabilities. Ensure efficient data retrieval and manipulation for improved performance.
Insert Data With Raw SQL Query Via EDF FrameworkDec 28, 2012. Today, in this article let’s play around with one of the interesting and most useful concepts in EDM Framework.
Delete Stored Proc With Raw SQL Query Via EDF FrameworkDec 28, 2012. Today, in this article let’s play around with one of the interesting and most useful concepts in EDM Framework.
Conversion Functions Using SQL Query in SQL ServerJul 01, 2012. In this article you will see how to use conversion functions using SQL Query in SQL Server.
Database Objects Information Using SQL Query in SQL ServerApr 22, 2012. In this article we will see how to get the Database objects Information using a query.
How to pass SQL Query Parameters to Crystal Reports using OracleAug 06, 2008. This article shows how to pass SQL query parameters to Crystal Reports using Oracle.
Write data to an access database using SQL Query and ADO.NETDec 06, 2000. See how to use SQL Statements to write data to an access database.
Database Objects Related to Table in Database - Transact SQL QueryJun 29, 2024. The SQL query retrieves distinct object names and their types from SYSCOMMENTS and SYSOBJECTS system tables, categorizing objects by their XTYPE values ('P' for procedure, 'V' for view, 'TR' for trigger). It filters results containing 'table_name' in their definitions, providing insights into database object metadata.
SQL Query Execution Understanding Process and PerformanceJun 11, 2024. Understanding the SQL query execution order—from FROM and JOIN to WHERE, GROUP BY, HAVING, SELECT, ORDER BY, and LIMIT/OFFSET—is crucial for optimizing queries. Key techniques include indexing, optimizing joins, early filtering, avoiding SELECT *, and using subqueries, CTEs, caching, and materialized views to enhance performance.
SQL Query Optimization Tools And TechniquesMay 07, 2020. In this article, you will learn about SQL Query optimization tools and techniques.
SQL Query Execution Plan OperationsApr 29, 2020. In this article you will learn about SQL query execution plan operations.
SQL Query Execution PlanApr 27, 2020. In this article, you will learn about SQL query execution plan.
Iterate Through Array Of Data In SQL QueryJan 21, 2020. In this article we will see how to create a Array variable in SQL and how to iterate through it to process records in database.
SQL Query Plans Each Developer Should KnowMay 26, 2016. In this article you will learn about SQL Query Plans for each Developer.
SQL Query Optimization TechniqueApr 19, 2015. This article provides some SQL Query Optimization Techniques.
SQL Query Performance - Functions and IndexesApr 02, 2015. In this article we will learn why functions should be avoided on indexed columns in where clauses of select statements.
Get Months Within a Date Range With SQL QueryFeb 11, 2015. This article shows how to get the months within a date range with SQL Query.
Show SQL Server Data Table in a XML Using SQL QueryDec 09, 2014. In this article I explain how to show our SQL Server data table in a XML format using SQL Query.
Generate Dynamic Pivot SQL QueryDec 06, 2013. Developers often need to transform table data, convering rows to column or column to rows. We can do that using the SQL Pivoting feature.
T-SQL Query Performance Tuning TipsAug 09, 2013. In this article, I will discuss some useful T-SQL query performance tips and tricks for SQL server developers.
SQL Query to Get Details of Index Fragmentation in SharePointJul 25, 2013. This article explains how to get the details of index fragmentation in SharePoint and provides a script that can be used to rebuild and reorganize indexes.
Searching, Sorting and Paging Using SQL QueryJun 25, 2013. This article shows how to use a SQL query to perform searching, sorting and paging by one query.
Comma Separated Value in SQL QueryApr 08, 2013. I have reviewed and answered many articles related to SQL Server. For the previous one and a half months, I found 3 to 4 articles related to finding comma separated values in SQL Server. So I decided to write an article on Comma Separated Values in SQL, it might help people who are looking for a solution of this.
Using LINQ to SQL QueryMay 04, 2010. Here in this article, you will get very basic idea of LINQ to SQL Query using code.
SQL Query Optimization FAQ Part 1 (With video explanation)Feb 02, 2010. In this article we will first try to understand what is a SQL plan, how is it created and then we will move towards understanding how to read the SQL plan. As we read the SQL plan we will try to understand different operators like table scan, index seek scan, clustered scan, RID lookup etc. We will also look in to the best practices associated with clustered and non-clustered indexes and how they function internally. We will practically see how indexed views increase performance and in what scenarios we should use the same.

OUR TRAINING