Tag Archives: SQL Server Tutorials

Standard

Posted by

Posted on

August 22, 2024

Posted under

SQL Server 2022

Comments

Leave a comment

SQL Server 2022: A Deep Dive into the APPROX_PERCENTILE_CONT Function with JBDB Database

SQL Server 2022 introduces several new features, one of the most exciting being the APPROX_PERCENTILE_CONT function. This function allows for efficient and approximate calculation of percentiles in large datasets, which can be particularly useful for analytics and data-driven decision-making. In this blog, we will explore the APPROX_PERCENTILE_CONT function in detail, using the JBDB database for practical demonstrations. We’ll start with a business use case, dive into the function’s capabilities, and provide a range of T-SQL queries for you to try. Let’s get started! 🚀

Business Use Case: Customer Transaction Analysis 💼

Consider a retail company that wants to analyze customer spending behavior. The company has a vast amount of transaction data stored in the JBDB database. To optimize marketing strategies and tailor promotions, they want to identify spending patterns across different customer segments.

For example, the company might want to know the 90th percentile of spending amounts to target high-value customers with exclusive offers. Calculating this percentile accurately in a large dataset can be resource-intensive. The APPROX_PERCENTILE_CONT function offers a solution by providing an approximate, yet efficient, calculation of percentiles.

Understanding the APPROX_PERCENTILE_CONT Function 📊

The APPROX_PERCENTILE_CONT function is designed to compute approximate percentile values for a set of data. This function is particularly useful when dealing with large datasets, as it offers a performance advantage by using approximate algorithms.

Syntax:

APPROX_PERCENTILE_CONT ( percentile ) WITHIN GROUP ( ORDER BY numeric_expression )
  • percentile: A value between 0 and 1 that specifies the desired percentile.
  • numeric_expression: The column or expression to calculate the percentile on.

Example 1: Basic Usage 🌟

Let’s calculate the 90th percentile of customer transaction amounts.

Setup:

USE JBDB;
GO

CREATE TABLE CustomerTransactions (
    TransactionID INT PRIMARY KEY,
    CustomerID INT,
    TransactionAmount DECIMAL(18, 2),
    TransactionDate DATE
);

INSERT INTO CustomerTransactions (TransactionID, CustomerID, TransactionAmount, TransactionDate)
VALUES
(1, 101, 50.00, '2023-01-15'),
(2, 102, 150.00, '2023-01-16'),
(3, 103, 300.00, '2023-01-17'),
(4, 101, 75.00, '2023-01-18'),
(5, 104, 200.00, '2023-01-19'),
(6, 105, 125.00, '2023-01-20'),
(7, 106, 400.00, '2023-01-21'),
(8, 102, 175.00, '2023-01-22');
GO

Query to Calculate 90th Percentile:

SELECT APPROX_PERCENTILE_CONT(0.90) WITHIN GROUP (ORDER BY TransactionAmount) AS Approx90thPercentile
FROM CustomerTransactions;

This result indicates that 90% of transactions are below $375. This insight can help the company focus on high-value customers who spend above this threshold.

Example 2: Analyzing Different Percentiles 🔍

Let’s calculate different percentiles to understand the distribution of transaction amounts.

Query to Calculate Multiple Percentiles:

SELECT 
    APPROX_PERCENTILE_CONT(0.25) WITHIN GROUP (ORDER BY TransactionAmount) AS Approx25thPercentile,
    APPROX_PERCENTILE_CONT(0.50) WITHIN GROUP (ORDER BY TransactionAmount) AS Approx50thPercentile,
    APPROX_PERCENTILE_CONT(0.75) WITHIN GROUP (ORDER BY TransactionAmount) AS Approx75thPercentile,
    APPROX_PERCENTILE_CONT(0.90) WITHIN GROUP (ORDER BY TransactionAmount) AS Approx90thPercentile
FROM CustomerTransactions;

These results provide a clear view of the transaction distribution, helping the company to tailor marketing strategies for different customer segments.

Comparing Percentile Results:

  • Compare approximate and exact percentile calculations for the 90th percentile:
SELECT 
    APPROX_PERCENTILE_CONT(0.90) WITHIN GROUP (ORDER BY TransactionAmount) AS Approx90thPercentile,
    PERCENTILE_CONT(0.90) WITHIN GROUP (ORDER BY TransactionAmount) OVER () AS Exact90thPercentile
FROM CustomerTransactions
group by TransactionAmount;

Segmenting Customers by Spending:

  • Identify customers whose spending is in the top 10%:
SELECT CustomerID, TransactionAmount
FROM CustomerTransactions
WHERE TransactionAmount >= (SELECT APPROX_PERCENTILE_CONT(0.90) WITHIN GROUP (ORDER BY TransactionAmount)
                             FROM CustomerTransactions);

Analyzing Spending Patterns Over Time:

  • Calculate monthly spending percentiles to identify trends:
SELECT 
    DATEPART(MONTH, TransactionDate) AS Month,
    APPROX_PERCENTILE_CONT(0.50) WITHIN GROUP (ORDER BY TransactionAmount) AS MedianTransaction
FROM CustomerTransactions
GROUP BY DATEPART(MONTH, TransactionDate)
ORDER BY Month;

Combining Percentiles with Other Aggregations:

  • Find the average transaction amount for each percentile group:
SELECT 
    PercentileGroup,
    AVG(TransactionAmount) AS AvgTransactionAmount
FROM (
    SELECT 
        TransactionAmount,
        NTILE(4) OVER (ORDER BY TransactionAmount) AS PercentileGroup
    FROM CustomerTransactions
) AS SubQuery
GROUP BY PercentileGroup;

Conclusion 🏁

The APPROX_PERCENTILE_CONT function in SQL Server 2022 is a powerful tool for efficiently computing approximate percentiles in large datasets. By using this function, businesses can gain valuable insights into data distributions and make informed decisions based on these insights. Whether you’re analyzing customer spending, sales trends, or any other data, the APPROX_PERCENTILE_CONT function offers a quick and efficient way to understand your data.

Happy querying! 😄

For more tutorials and tips on SQL Server, including performance tuning and database management, be sure to check out our JBSWiki YouTube channel.

Thank You,
Vivek Janakiraman

Disclaimer:
The views expressed on this blog are mine alone and do not reflect the views of my company or anyone else. All postings on this blog are provided “AS IS” with no warranties, and confers no rights.

Standard

Posted by

Posted on

August 21, 2024

Posted under

SQL Server 2022

Comments

Leave a comment

SQL Server 2022: Unleashing the Power of the GENERATE_SERIES Function

In SQL Server 2022, the introduction of the GENERATE_SERIES function marks a significant enhancement, empowering developers and analysts with a flexible and efficient way to generate sequences of numbers. This feature, akin to similar functions in other database systems, simplifies tasks involving sequence generation, such as creating time series data, generating test data, and more.

In this blog, we’ll explore the GENERATE_SERIES function in detail, using the JBDB database to demonstrate its capabilities. We’ll start with a practical business use case, followed by a comprehensive guide on how to use the function. Let’s dive in! 🌟

Business Use Case: Sales Forecasting 📈

Imagine you are working for a retail company, and your task is to generate a sales forecast for the next year. You have historical sales data and need to project future sales based on trends. A crucial step in this process is to create a series of dates representing each day of the next year, which will serve as the basis for the forecast.

The GENERATE_SERIES function can be a game-changer here, allowing you to quickly generate a range of dates without resorting to complex loops or recursive queries.

Introducing the GENERATE_SERIES Function 🛠️

The GENERATE_SERIES function generates a series of numbers or dates. Its syntax is straightforward:

GENERATE_SERIES(start, stop, step)
  • start: The starting value of the sequence.
  • stop: The ending value of the sequence.
  • step: The increment value between each number in the series.

Let’s see this in action with some practical examples!

Example 1: Basic Numeric Series 🔢

To generate a series of numbers from 1 to 10:

SELECT value
FROM GENERATE_SERIES(1, 10, 1);

Example 2: Date Series for Forecasting 📅

To generate a series of dates for each day of the next year, starting from January 1, 2023:

SELECT CAST(value AS DATE) AS ForecastDate
FROM GENERATE_SERIES('2023-01-01', '2023-12-31', 1);

Generating a Series of Dates Using a CTE 📅

Since GENERATE_SERIES supports numeric sequences only, we use a recursive CTE to generate a series of dates. Here’s how to create a series of dates for the year 2023:

-- Create a recursive CTE to generate a series of dates
WITH DateSeries AS (
    -- Anchor member: start date
    SELECT CAST('2023-01-01' AS DATE) AS ForecastDate
    UNION ALL
    -- Recursive member: add one day to the previous date
    SELECT DATEADD(DAY, 1, ForecastDate)
    FROM DateSeries
    WHERE ForecastDate < '2023-12-31'
)
-- Query to select the generated dates
SELECT ForecastDate
FROM DateSeries
OPTION (MAXRECURSION 0); -- Remove recursion limit

Implementing the Use Case: Sales Forecasting 📊

Let’s apply the GENERATE_SERIES function to our sales forecasting scenario. Suppose we have a table Sales in the JBDB database with historical sales data. Our goal is to project future sales for each day of the next year.

Step 1: Creating the JBDB and Sales Table 🏗️

First, we create the JBDB database and the Sales table:

CREATE DATABASE JBDB;
GO

USE JBDB;
GO

CREATE TABLE Sales (
    SaleDate DATE,
    Amount DECIMAL(10, 2)
);

Step 2: Inserting Historical Data 📥

Next, let’s insert some historical data into the Sales table:

INSERT INTO Sales (SaleDate, Amount)
VALUES
('2022-01-01', 100.00),
('2022-01-02', 150.00),
('2022-01-03', 200.00),
-- Additional data...
('2022-12-31', 250.00);

Step 3: Generating Future Dates and Forecasting 📅🔮

Now, we use GENERATE_SERIES to generate future dates and join it with our historical data to create a sales forecast:

-- Generate a series of future dates
WITH DateSeries AS (
    SELECT CAST('2023-01-01' AS DATE) AS ForecastDate
    UNION ALL
    SELECT DATEADD(DAY, 1, ForecastDate)
    FROM DateSeries
    WHERE ForecastDate < '2023-12-31'
),
-- Combine with historical sales data
SalesForecast AS (
    SELECT
        f.ForecastDate,
        ISNULL(s.Amount, 0) AS HistoricalAmount
    FROM
        DateSeries f
        LEFT JOIN Sales s ON f.ForecastDate = s.SaleDate
)
-- Project future sales
SELECT
    ForecastDate,
    HistoricalAmount,
    -- Simple projection logic (for demonstration)
    HistoricalAmount * 1.05 AS ProjectedAmount
FROM SalesForecast
OPTION (MAXRECURSION 0); -- Remove recursion limit

In this query:

  • We generate a series of dates for the year 2023 using GENERATE_SERIES.
  • We join these dates with the historical sales data to create a comprehensive sales forecast.
  • A simple projection logic is applied, assuming a 5% increase in sales.

Generate a Series of Numbers with Custom Step Size

Generate a sequence of numbers from 1 to 50 with a step size of 5:

-- Generate a sequence of numbers with a custom step size
SELECT value
FROM GENERATE_SERIES(1, 50, 5);

Generate a Series of Dates with Custom Step Size

Generate a series of dates from today to 30 days into the future with a step size of 5 days:

-- Generate a series of dates with a custom step size (5 days)
WITH DateSeries AS (
    SELECT DATEADD(DAY, value * 5, CAST(GETDATE() AS DATE)) AS ForecastDate
    FROM GENERATE_SERIES(0, 6, 1) -- 0 to 6 will generate 7 dates
)
SELECT ForecastDate
FROM DateSeries;

Generate a Series of Random Numbers

Generate a series of random numbers between 1 and 100:

-- Generate a series of random numbers between 1 and 100
SELECT ABS(CHECKSUM(NEWID())) % 100 + 1 AS RandomNumber
FROM GENERATE_SERIES(1, 10, 1); -- Generate 10 random numbers

Generate a Series of Time Intervals

Generate a series of time intervals (every 15 minutes) for one hour:

-- Generate a series of time intervals (15 minutes) for one hour
WITH TimeSeries AS (
    SELECT DATEADD(MINUTE, value * 15, CAST('2024-01-01 00:00:00' AS DATETIME)) AS TimeStamp
    FROM GENERATE_SERIES(0, 3, 1) -- 0 to 3 will generate 4 intervals
)
SELECT TimeStamp
FROM TimeSeries;

Generate a Series of Sequential IDs

Generate a series of sequential IDs from 1001 to 1010:

-- Generate a sequence of sequential IDs
SELECT value + 1000 AS SequentialID
FROM GENERATE_SERIES(1, 10, 1);

Generate a Series of Numeric Values with Non-Uniform Steps

Generate a series of numbers with varying steps (e.g., 1, 2, 4, 8, …):

-- Generate a series of numbers with varying steps (powers of 2)
WITH NumberSeries AS (
    SELECT 1 AS value
    UNION ALL
    SELECT value * 2
    FROM NumberSeries
    WHERE value < 64
)
SELECT value
FROM NumberSeries
OPTION (MAXRECURSION 0);

Generate a Series of Dates with Monthly Intervals

Generate a series of dates with a monthly interval for one year:

-- Generate a series of dates with monthly intervals for one year
WITH MonthSeries AS (
    SELECT DATEADD(MONTH, value, CAST('2024-01-01' AS DATE)) AS MonthStart
    FROM GENERATE_SERIES(0, 11, 1) -- 0 to 11 will generate 12 months
)
SELECT MonthStart
FROM MonthSeries;

Generate a Series of Numbers and Calculate Cumulative Sum

Generate a series of numbers and calculate their cumulative sum:

-- Generate a series of numbers and calculate the cumulative sum
WITH NumberSeries AS (
    SELECT value
    FROM GENERATE_SERIES(1, 10, 1)
),
CumulativeSum AS (
    SELECT
        value,
        SUM(value) OVER (ORDER BY value) AS CumulativeSum
    FROM NumberSeries
)
SELECT value, CumulativeSum
FROM CumulativeSum;

Generate a Series of Custom Random Dates

Generate a series of random dates within a specific range:

— Generate a series of random dates within a specific range
WITH RandomDates AS (
SELECT DATEADD(DAY, ABS(CHECKSUM(NEWID())) % 365, CAST(‘2024-01-01’ AS DATE)) AS RandomDate
FROM GENERATE_SERIES(1, 10, 1) — Generate 10 random dates
)
SELECT RandomDate
FROM RandomDates;

Generate a Series of Numbers and Create Custom Labels

Generate a series of numbers and create custom labels:

— Generate a series of numbers and create custom labels
SELECT value AS Number, ‘Label_’ + CAST(value AS VARCHAR(10)) AS CustomLabel
FROM GENERATE_SERIES(1, 10, 1);

Conclusion 🌟

The GENERATE_SERIES function in SQL Server 2022 is a versatile tool that can significantly simplify the generation of sequences, whether for numeric ranges or date series. Its applications range from creating time series data for analytics to generating test data for development and testing purposes.

By leveraging GENERATE_SERIES, businesses can streamline their data workflows, enhance forecasting accuracy, and improve decision-making processes. Whether you’re a database administrator, developer, or data analyst, this function is a valuable addition to your SQL toolkit.

Feel free to experiment with GENERATE_SERIES and explore its potential in your projects! 🎉

For more tutorials and tips on SQL Server, including performance tuning and database management, be sure to check out our JBSWiki YouTube channel.

Thank You,
Vivek Janakiraman

Disclaimer:
The views expressed on this blog are mine alone and do not reflect the views of my company or anyone else. All postings on this blog are provided “AS IS” with no warranties, and confers no rights.

Standard

Posted by

Posted on

August 12, 2024

Posted under

SQL Server 2022

Comments

Leave a comment

SQL Server 2022 and Machine Learning Integration: A Comprehensive Guide

🤖 In an increasingly data-driven world, the ability to seamlessly integrate machine learning capabilities into database systems is invaluable. SQL Server 2022 enhances this capability by providing advanced integration with R and Python, two of the most widely used languages in data science and machine learning. This blog delves into these enhancements, offering a comprehensive guide on leveraging SQL Server 2022 for advanced analytics. We’ll explore the technical aspects, practical implementations, and a detailed business use case to illustrate the transformative potential of this integration. Emojis are included throughout to add a touch of visual engagement! 🤖

🤖 Enhancements in SQL Server 2022 for Machine Learning🤖

SQL Server 2022 continues to build on its robust data platform by integrating more deeply with data science and machine learning ecosystems. The latest enhancements facilitate seamless in-database analytics, reducing latency and improving security. Let’s explore these enhancements in detail.

1. Enhanced In-Database Machine Learning

SQL Server 2022 allows for the native execution of R and Python scripts within the database environment. This capability is a significant advancement, as it eliminates the need for data movement between different systems, thereby reducing latency and potential security risks.

Key Benefits:

  • Data Integrity and Security: Data remains within the secure boundaries of the SQL Server environment, minimizing exposure and potential breaches.
  • Performance Optimization: Running analytics close to the data source reduces the overhead associated with data transfer, resulting in faster processing times.
  • Streamlined Workflow: Data scientists and analysts can develop, test, and deploy machine learning models within the SQL Server ecosystem, streamlining the workflow and reducing the complexity of managing separate systems.

2. Improved Integration with R and Python

The integration of R and Python in SQL Server 2022 is more robust than ever, featuring updated support for the latest libraries and packages. This enhancement ensures that data scientists have access to cutting-edge tools for statistical analysis, machine learning, and data visualization.

Key Features:

  • Comprehensive Library Support: SQL Server 2022 supports a wide range of R and Python packages, including popular libraries like tidyverse, caret, and ggplot2 for R, and pandas, scikit-learn, and matplotlib for Python.
  • Enhanced Security: The execution environment for R and Python scripts within SQL Server is fortified with enhanced security features, including secure sandboxing and controlled resource allocation.
  • Resource Management: SQL Server 2022 provides improved resource management tools, allowing administrators to monitor and control the computational resources allocated to R and Python scripts. This ensures optimal performance and prevents resource contention.

3. Support for ONNX Models

The Open Neural Network Exchange (ONNX) format is a standardized format for representing machine learning models. SQL Server 2022’s support for ONNX models is a significant enhancement, enabling the deployment of machine learning models trained in various frameworks such as TensorFlow, PyTorch, and Scikit-Learn.

Advantages:

  • Interoperability: ONNX support ensures that models can be easily transferred between different machine learning frameworks, enhancing flexibility and reducing vendor lock-in.
  • Optimized Inference: SQL Server 2022 is optimized for the inference of ONNX models, ensuring that predictions are delivered quickly and efficiently, which is critical for real-time applications.
  • Model Management: By supporting ONNX, SQL Server 2022 simplifies the management of machine learning models, providing a unified platform for training, deploying, and managing models.

💼 Business Use Case: Enhancing Customer Experience in Retail

Company Profile

A leading global retail chain, with both physical stores and a robust online presence, seeks to leverage advanced data analytics and machine learning to enhance customer experience. The company aims to utilize data to improve product recommendations, optimize pricing strategies, and streamline inventory management.

Challenges

  1. Data Silos: Customer data is scattered across various systems, including in-store POS systems, online transaction databases, and customer loyalty programs, making it challenging to derive comprehensive insights.
  2. Real-Time Analytics Needs: The company needs real-time analytics to offer personalized recommendations and dynamic pricing to customers based on their browsing and purchase behavior.
  3. Scalability Concerns: The company must handle large volumes of data, generated from millions of transactions across global operations, without compromising on performance.

Solution: SQL Server 2022 and Machine Learning Integration

The retail chain implemented SQL Server 2022, capitalizing on its advanced machine learning capabilities. By integrating R and Python, the company was able to develop sophisticated models that run directly within the SQL Server environment, facilitating real-time analytics and reducing the need for data movement.

Key Implementations:

  1. Product Recommendation Engine: Using collaborative filtering techniques implemented in Python, the company developed a recommendation engine. This engine analyzes historical purchase data to generate personalized product recommendations in real-time, enhancing the shopping experience for both in-store and online customers.
  2. Dynamic Pricing Model: An R-based dynamic pricing model adjusts prices in real-time based on factors such as demand elasticity, competitor pricing, and inventory levels. This ensures competitive pricing strategies while maximizing profit margins.
  3. Inventory Optimization: The company deployed machine learning algorithms to forecast demand accurately, optimizing inventory levels. This reduces stockouts and overstock situations, enhancing supply chain efficiency.

Detailed Implementation Steps

Step 1: Setting Up SQL Server Machine Learning Services

To enable machine learning capabilities in SQL Server 2022, the company installed and configured SQL Server Machine Learning Services with R and Python. This setup included:

  • Installing necessary packages and libraries.
  • Configuring resource governance to manage the execution of external scripts.

Step 2: Developing Machine Learning Models

Data scientists developed machine learning models using familiar tools:

  • Python: Used for developing the recommendation engine, leveraging libraries like pandas, scikit-learn, and scipy.
  • R: Utilized for dynamic pricing and inventory optimization, using packages such as forecast, randomForest, and caret.

Step 3: Deploying Models Within SQL Server

The developed models were then deployed within SQL Server, utilizing the following stored procedures:

Product Recommendation Engine:

EXEC sp_execute_external_script
  @language = N'Python',
  @script = N'
import pandas as pd
from sklearn.neighbors import NearestNeighbors

# Load data
data = pd.read_csv("customer_purchases.csv")
# Preprocess data and create a customer-product matrix
customer_product_matrix = data.pivot(index="customer_id", columns="product_id", values="purchase_count")
customer_product_matrix.fillna(0, inplace=True)

# Fit the model
model = NearestNeighbors(metric="cosine", algorithm="brute")
model.fit(customer_product_matrix)

# Get recommendations
distances, indices = model.kneighbors(customer_product_matrix, n_neighbors=5)
recommendations = [list(customer_product_matrix.index[indices[i]]) for i in range(len(indices))]

# Return the recommendations
recommendations
'
WITH RESULT SETS ((Recommendations NVARCHAR(MAX)))
  • Dynamic Pricing Model:
EXEC sp_execute_external_script
  @language = N'R',
  @script = N'
library(randomForest)

# Load and prepare data
data <- read.csv("sales_data.csv")
data$price <- as.numeric(data$price)
data$competitor_price <- as.numeric(data$competitor_price)
data$demand <- as.numeric(data$demand)

# Train a random forest model
model <- randomForest(price ~ ., data = data, ntree = 100)

# Predict optimal prices
predicted_prices <- predict(model, data)

# Return the predicted prices
predicted_prices
'
WITH RESULT SETS ((PredictedPrices FLOAT))

Benefits Realized

  • Enhanced Customer Experience: The personalized product recommendations and dynamic pricing enhanced the shopping experience, resulting in increased customer satisfaction and higher sales conversions.
  • Operational Efficiency: Real-time analytics capabilities enabled the company to respond swiftly to changing market conditions, optimize inventory, and reduce operational costs.
  • Data-Driven Decision Making: By centralizing data and analytics within SQL Server 2022, the company gained comprehensive insights into customer behavior and operational metrics, driving more informed business decisions.

📊 Practical Examples and Implementations

Example 1: Implementing a Product Recommendation Engine

The product recommendation engine uses collaborative filtering techniques to analyze customer purchase patterns and suggest products they might be interested in. This is achieved through the following steps:

  1. Data Collection: Customer purchase data is collected from various sources, including POS systems and online transactions.
  2. Data Preprocessing: The data is cleaned and transformed into a customer-product matrix, where each row represents a customer, and each column represents a product.
  3. Model Training: The Nearest Neighbors algorithm is used to find similar customers based on their purchase history.
  4. Recommendation Generation: For each customer, the model identifies other customers with similar purchase histories and recommends products that these similar customers have bought.

Example 2: Building a Dynamic Pricing Model

The dynamic pricing model adjusts prices in real-time based on several factors, including demand, competition, and inventory levels. The process involves:

  1. Data Collection: Collecting historical sales data, competitor pricing information, and current inventory levels.
  2. Feature Engineering: Creating relevant features such as time of day, seasonality, and customer demographics.
  3. Model Training: Using the random forest algorithm to predict optimal prices based on the engineered features.
  4. Price Adjustment: Implementing the predicted prices across various sales channels in real-time.

🚀 Conclusion

SQL Server 2022’s enhanced integration with R and Python for machine learning and advanced analytics opens up new possibilities for businesses. By embedding machine learning models directly within the database, companies can achieve faster insights, more efficient operations, and a seamless workflow. Whether you’re looking to enhance customer experiences, optimize pricing strategies, or improve operational efficiency, SQL Server 2022 provides a robust platform for data-driven decision-making.

For businesses like the retail chain in our use case, the ability to harness data for real-time analytics and machine learning has proven transformative, driving growth and enhancing customer satisfaction. As organizations continue to embrace digital transformation, the integration of advanced analytics and machine learning within SQL Server 2022 will play a crucial role in unlocking new opportunities and achieving competitive advantages.

Embrace the power of SQL Server 2022 and its machine learning capabilities, and elevate your data analytics to the next level! 🌟

For more tutorials and tips on SQL Server, including performance tuning and database management, be sure to check out our JBSWiki YouTube channel.

Thank You,
Vivek Janakiraman

Disclaimer:
The views expressed on this blog are mine alone and do not reflect the views of my company or anyone else. All postings on this blog are provided “AS IS” with no warranties, and confers no rights.