Machine learning K-Means applied to SQL Server data
This article shows how to use Python to access data in SQL Server and produce a K-Means analysis with a chart.
2024-01-08
2,827 reads
This article shows how to use Python to access data in SQL Server and produce a K-Means analysis with a chart.
2024-01-08
2,827 reads
Unlock the power of SQL's NTILE function with our latest deep-dive article. Learn to segment your data effectively into quantiles for more nuanced analysis, discover common pitfalls and their solutions, and optimize your queries for peak performance.
2024-02-03 (first published: 2024-01-03)
4,526 reads
One of the most effective ways to fully utilize your data is to create an Azure Hyperscale database. The principles of Azure Hyperscale databases have been discussed in this article, including their cost-effectiveness, worldwide accessibility, automatic scaling, and reliable performance.
2023-12-22
1,322 reads
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
6,957 reads
2023-11-27
5,302 reads
Profiler is a GUI based tool that runs a SQL Server trace to capture the metrics listed above as well additional data. This data can then be used to determine where your SQL Server performance issues are related to your TSQL code. Running a trace without using Profiler is known as a Server Side Trace. You can create and start the trace using TSQL commands instead of having to use the GUI.
2023-09-29
A query is sometimes super fast and sometimes very slow. One of the main reasons for this problem is Parameter Sniffing. There are several approaches to addressing the Parameter Sniffing issue and this article discusses effective methods for handling Parameter Sniffing in SELECT statements containing a TOP clause.
2023-09-18
In this tip, we will discuss the process of generating test data to verify query logic without relying on real-life data, along with some helpful guidelines. We will also cover various scenarios and their corresponding solutions.
2023-09-15
There is more than one way to work with SQL Server stored procedures from within a .NET Application. However, when using parameters, in order to avoid exposing your code to "SQL Injection" vulnerabilities, there is a certain way based on which you should write your code.
2023-08-21
RDS Custom for SQL Server recently released exciting new features related to Bring Your Own Media (BYOM) and High Availability. By using BYOM, customers may leverage their existing SQL Server licenses with Amazon RDS Custom for SQL Server, when used in accordance to Microsoft terms. This allows customers who have already purchased SQL Server licenses to save on TCO/license costs, while offloading the undifferentiated heavy lifting of database management to Amazon RDS Custom. By using Multi-AZ deployment, customers can now set up high availability for their databases.
2023-08-14
By Steve Jones
tangency– n. a fleeting glimpse of what might have been. I tend to live...
I’m excited to be speaking at the Microsoft Fabric Community Conference this year, which...
The AI revolution isn’t coming – it’s here. Companies are racing to integrate artificial...
Skype, one of the most popular communication platforms, allows users to make voice and...
I'm struggling setting relationships among tables. I understand the one-to-many, many-to-one, many-to-many, and self-referential...
Hi All, need help with an SQL query. We have an existing table that's...
What is the output of this code in SQL Server 2022?
select bit_count(0xEF)See possible answers