Source Control using Azure Data Studio and GitHub
You can maintain and deploy code easilySource control is a vital part of IT work, since it is used to...
2019-01-09
3,494 reads
Eduardo Pivaral
- Website: http://www.sqlguatemala.com
Source Control using Azure Data Studio and GitHub
You can maintain and deploy code easily
Source control is a vital part of IT work, since it is used to track changes over software and documents, with two main...
2019-01-09
15 reads
Load and run custom T-SQL scripts in SSMS via Snippets
If you work with SQL Server on a daily basis, it is very likely you have a lot of custom...
2018-11-12
348 reads
Load and run custom T-SQL scripts in SSMS via Snippets
If you work with SQL Server on a daily basis, it is very likely you have a lot of custom scripts you have to execute frequently, maybe you have...
2018-11-12
11 reads
Enable Machine Learning Services on SQL Server
R Services (SQL Server 2016) or Machine Learning Services (2017 and 2019 CTP) provide you with the ability to perform...
2018-11-08
2,749 reads
Enable Machine Learning Services on SQL Server
R Services (SQL Server 2016) or Machine Learning Services (2017 and 2019 CTP) provide you with the ability to perform data analysis from the database itself using T-SQL.You can...
2018-11-08
8 reads
SSIS Basics: Data cleansing using derived columns
On this article I will show you how to perform a basic data cleansing using the derived column data transformation
2018-10-30
5,231 reads
how to embed a PowerBI report into HTML code
PowerBI is a powerful reporting solution for Business Intelligence for analytical reports, it is not meant to replace SSRS, the...
2018-10-16 (first published: 2018-10-03)
3,007 reads
How much affects encryption to your database performance?
Transparent data encryption (TDE) helps you to secure your data at rest, this means the data files and related backups...
2018-10-15
251 reads
How much affects encryption to your database performance?
Transparent data encryption (TDE) helps you to secure your data at rest, this means the data files and related backups are encrypted, securing your data in case your media...
2018-10-15
7 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