SQL Server Machine Learning Services – Part 6: Merging Data Frames in Python
In the final article in this series, Robert Sheldon demonstrates combining data sources with multiple formats into one Python data frame.
2018-03-15
3,337 reads
Additional Articles
SET IMPLICIT_TRANSACTIONS ON Is One Hell of a Bad Idea
By default, when you run a query in SQL Server, your delete/update/insert (DUI) is finished as soon as your query finishes. That’s because the default behavior of SQL Server is IMPLICIT_TRANSACTIONS OFF – meaning, SQL Server doesn’t hold your queries open waiting for a COMMIT or ROLLBACK.
2018-03-14
3,761 reads
Changing Data Types on Large Tables: The INT to BIGINT Conundrum
Changing a data type seems like a simple task unless the table is quite large and downtime must be kept to a minimum. Danny Kruge walks you through the process he created to change an INT to a BIGINT in a large table.
2018-03-13
10,620 reads
Non-Standard Delimiters for Columns and Rows Using SQL Server Bulk Insert
In this tip, Tim Smith looks at how to use bulk insert to load data into SQL Server when the column and row terminators are not what you typically see.
2018-03-12
3,402 reads
Introduction to the Biml Language
Biml or Business Intelligence Markup Language is an open-source XML dialect to generate Integration Services (SSIS) packages. Take a look at this Biml tutorial to learn how you can use Biml to generate SSIS packages.
2018-03-09
3,767 reads
Azure Cosmos DB Partitioning
One of the most important design decisions that must be made when planning deployment of Azure Cosmos DB involves logical partitioning of data that will populate target collections, graphs, or tables. Selecting the optimal partitioning model has both performance and pricing implications. In this article, we will explore the rationale behind these implications and review the partitioning options.
2018-03-08
2,357 reads
Questions About Data Breaches that You Were Too Shy to Ask
News reports about data breaches are common occurrences. Even the companies that exist to keep our data safe are not immune. William Brewer answers the question about data breaches that you may be too shy to ask.
2018-03-07
3,539 reads
The Many Levels Of Concurrency
When designing for high concurrency, most people look to the hardware for answers. And while it’s true that it plays an important role, there’s a heck of a lot more to it.
2018-03-06
3,361 reads
Quality-Driven Software Development
While software is among the most widely used products in human history, it also has one of the highest failure rates due to poor quality. In this article, Cynthia Dzikiti explains how quality should be part of all aspects of the software lifecycle.
2018-03-05
2,482 reads
SQL Server Machine Learning Services – Part 5: Generating multiple plots in Python
Visualization is often the first step in analyzing data. Python makes visualization easy. In this article, Robert Sheldon demonstrates how to generate multiple charts from one dataset using Python with SQL Server Machine Learning Services.
2018-03-02
3,557 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Forums
Missing the Jaro Winkler Distance
Comments posted to this topic are about the item Missing the Jaro Winkler Distance
25 Years Later: What SQLServerCentral Meant to Me
Comments posted to this topic are about the item 25 Years Later: What SQLServerCentral...
Doing Good at SQL Server Central
Comments posted to this topic are about the item Doing Good at SQL Server...
Question of the Day
Missing the Jaro Winkler Distance
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers