In this page dedicated to articles, you will find written articles on topics related to SQL, T-SQL, SQL Server database, and tools used to connect to several databases.
SQL articles typically cover topics such as how to create, update, and query databases using SQL. They may also cover advanced topics such as database normalization and data modeling.
T-SQL articles may focus on how to create and manage SQL Server databases, as well as specific features unique to T-SQL, such as stored procedures and user-defined functions. T-SQL articles may also cover topics such as query optimization and database security.
SQL Server database articles focus specifically on the Microsoft SQL Server database management system. These articles may cover topics such as how to install and configure SQL Server, how to manage SQL Server instances, and how to troubleshoot common issues with SQL Server databases.
- Types of User-Defined Functions in SQL - show you how to create new functions in SQL.
- Everything You Need To Master in SQL For Data Science - describe the Fundamentals of SQL and important SQL topics for Data Science.
- SQL Server arhitecture - is designed to store, manage and retrieve data using SQL.
- SQL Server Agent - define and schedule jobs that can run at specific times.
- SQL Server Profiler - is used to monitor and trace events that occur on a SQL Server database.
- SQL Server Management Studio (SSMS) - allows users to interact with SQL Server databases.
- SQL Server Database Engine Tuning Advisor (DTA) - is a tool that helps optimize the performance of your SQL Server databases. It provides recommendations on how to improve the performance of your queries, indexes, and database schema based on the workload analysis.
- SQL Server Automatic Tuning - use advanced algorithms and machine learning techniques to optimize the performance of databases without human intervention.
- Azure SQL - cloud-based relational database.
- Azure SQL Database - introduction to Azure SQL Database.
- Azure SQL Managed Instance - provides a fully managed SQL Server instance in the cloud.
- Azure Data Studio - is a cross-platform database management tool.
- SQL Business day calculator - calculate the number of working days between two dates.
- Regular expressions - provide a way to define complex search patterns that can be used to extract specific information from a string.
- Triggers vs Constraints in SQL Server - describe the key differences between triggers and constraints.
- Relationships in database SQL Server using T-SQL - relationships are fundamental for organizing and maintaining data integrity within a relational database. Relationships define how tables are connected and how data in one table is related to data in another.
- Optimize a SQL query in SQL Server - key steps and techniques to help you optimize SQL queries.
- Parameters in SQL query - using parameters in SQL queries helps prevent SQL injection attacks and improves query performance by allowing SQL Server to reuse query execution plans.
- Converting Datetime to Date in SQL Server - convert a DATETIME data type to a DATE data type using various functions and methods.
- Connection string SQL Server - is a string of parameters that specifies information about a data source and the means of connecting to it.
- Table variable vs Temp table - both table variables and temporary tables are used to store data temporarily for further processing within a script or a batch of queries.
- Get length of string - the length of a string represents the number of characters in the string.
- SQL Server login failed for user - error message occurs when a user attempts to connect to the SQL Server instance but fails to provide valid credentials or encounters issues during the authentication process.
- SQL Server NOT Query - the NOT operator is used in conjunction with other operators to negate a condition in a query. It is primarily employed in the WHERE clause to filter rows based on the opposite of a specified condition. This allows you to retrieve data that does not meet certain criteria.
- Transaction Logging in SQL Server - is a critical aspect of database management that ensures data integrity, durability, and recoverability. It plays a pivotal role in maintaining the consistency of a database in the event of system failures, crashes, or other unforeseen circumstances.
