AWS EC2 Linux AMI with pyodbc
AWS EC2 Linux AMI with pyodbc, psqlODBC, Microsoft ODBC Drivers Context: Using pyodbc within a small python application to pull tracking data from an Azure SQL Server DB, do...
2018-01-23
73 reads
Marc Beacom
2017-12-01
141 reads
Networking, and other things to do while at PASS Summit
If you are headed to Seattle for the PASS Summit, not only are you in for a week of intense...
2017-10-30
333 reads
Datalere Presents Data Science, Cloud, Business Intelligence and Data Warehousing at PASS Summit
Pacific North West, 4000 attendees, training, trends and worldwide industry experts. In a nut shell, the world’s largest conference for...
2017-10-18
159 reads
I’m Speaking at SQL Saturday Denver 673
I’m incredibly excited to be a part of SQL Saturday Denver 673 both as a speaker and co-organizer. I will...
2017-09-11
291 reads
Countdown to Denver SQL Saturday: Register and Attend
My First Presentation was on Database Security. Those slides are still available for nostalgia sake 66 to 673 in N...
2017-08-17
160 reads
Data Science Comes to DTC
Data Science in DTC Tomorrow - Tuesday June 13, 2017 to be precise – is the initial meeting of a new meetup...
2017-06-12
160 reads
Getting Started with PowerBI: Building Graphs (Part 3)
This is part 3 of the Getting Started with Power BI series. Power BI is a powerful reporting and dashboarding...
2017-02-16
174 reads
Getting Started with Power BI: Getting Data (Part 2 of 3)
This is part 2 of the Getting Started with Power BI series. Power BI is a powerful reporting and dashboarding...
2017-02-09
172 reads
Team Productivity Practices – #TAPtips
Ensuring and maintaining team productivity practices is important for any organization, especially a small and growing team. The biggest part...
2017-02-07
437 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