Install and Configure SQL Server 2017 Availability Groups on Linux - Part 3
In this tip, Edwin Sarmiento looks at how to create the Always On Availability Group with a listener name when using SQL Server on Linux.
2018-02-02
3,045 reads
Articles
Historical Stock Prices and Volumes from Python to a CSV File
Python is a versatile language that is gaining more popularity as it is used for data analysis and data science. In this article, Rick Dobson demonstrates how to download stock market data and store it into CSV files for later import into a database system.
2018-01-31
2,873 reads
Azure DWH part 25: Auditing and threat detection
In this new article, we will show how to audit the Data Warehouse Activities.
2018-01-30
549 reads
Network Issue or THREADPOOL waits?
Tara Kizer talks identifying THREADPOOL waits and what you can do about them.
2018-01-30
3,043 reads
Critical SQL Server Patches for Meltdown and Spectre
Everyone needs to learn about these hardware bugs and apply patches as soon as possible.
2018-01-29 (first published: 2018-01-05)
8,591 reads
Sending table form HTML emails from a SQL Server database engine
The solution which helps to smiplify delivery of a table content in the HTML form using Database mail
2018-01-29
6,996 reads
SQL Server Machine Learning Services – Part 3: Plotting Data with Python
One of the advantages of running Python from SQL Server is the ability to create graphics to assist in analysis of data. Robert Sheldon demonstrates matplotlib, a 2D plotting library, widely used with Python to create quality charts.
2018-01-29
3,463 reads
2018-01-26 (first published: 2015-10-15)
7,176 reads
Azure DWH part 24: Elastic queries
This article will explain what is an elastic query and show an example.
2018-01-23
3,348 reads
Automatic Database Seeding
Set up and use the automatic databases seeding feature for Availability Groups.
2018-01-22
8,553 reads
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
AllocationType as ROW_OVERFLOW_DATA
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
is it true we cant debug c# scripts in ssis anymore under vs
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
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