Justify the Remote access requirement for Biztalk Log Shipping
This article will show why there is a need for remote access with a Biztalk server that uses log shipping.
2017-03-29
735 reads
Articles
Handling Graphs in SQL
Many practical database problems can be tackled more simply and intuitively by graphs or networks, which in this sense are graphs in which attributes can be associated with the nodes and edges. It is a natural way to study relationships within the data. SQL databases aren't the easiest way of doing it, but it makes sense where the scale permits it. Because of the range of graphs and techniques, some Graph theory is unavoidable before you get stuck into the code, and who better to introduce graph databases than Joe Celko?
2017-03-29
5,270 reads
Performing a Right and Comprehensive Age Calculation
Age calculation based on the right method used in real life.
2017-03-28
4,324 reads
Who Changed My Database Schema?
Have you ever wanted to know who made a schema change to your database? If so, that information is tracked in the default trace - Greg Larsen shows how to view it.
2017-03-28
6,381 reads
Azure Data Warehouse 7: Create reports in Azure SQL DWH using SSRSS
In this article, we will show how to create reports in ASDW using SSRS
2017-03-27
1,557 reads
Using AT TIME ZONE to fix an old report
Rob Farley contributes to T-SQL Tuesday #87, showing how he would use AT TIME ZONE to simplify reports based on an end user's time zone.
2017-03-27
4,087 reads
The Mysterious Case of the Missing Default Value
Sometimes things are not exactly how we think they are. Read the story of the missing default value and learn why.
2017-03-24 (first published: 2015-12-01)
6,994 reads
Encrypting SQL Server: Transparent Data Encryption (TDE)
Transparent Data Encryption (TDE) encrypts the data within the physical files of the database, the 'data at rest'. Without the original encryption certificate and master key, the data cannot be read when the drive is accessed or the physical media is stolen. The data in unencrypted data files can be read by restoring the files to another server. TDE requires planning but can be implemented without changing the database. Robert Sheldon explains how to implement TDE.
2017-03-24
5,410 reads
Comparing Space Usage for Different Compression Types
This is an investigation, to get an impression on the impact of the used disk space before and after compression considering different index types.
2017-03-23
2,361 reads
Getting Started with Azure SQL Data Warehouse - Part 2
Arshad Ali discusses the architecture of Azure SQL Data Warehouse and how you can scale up or down, based on your need.
2017-03-23
4,160 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