SQL Server Linked Server to Snowflake
In this tip we review how to configure a SQL Server linked server into Snowflake and a few use cases of how this solution would be beneficial in a production environment.
Ian Fogelman is a MCSE in Data Management and Analytics and Amazon Web Services Certified Solutions Architect. Ian currently works as a Senior ETL Developer with American Family Life Assurance Company. Ian has over 7 years of experience in database technologies primarily in SQL Server, reporting and data integrations. Other technologies that Ian enjoys are Docker, data science and predictive analytics, AWS – Deep racer and Linux. Ian is also the founder and primary contributor to SuperFunSql.com where he covers many topics such as AWS services, Machine Learning, Python, SQL Server, Power BI and various programming language topics.
- MSSQLTips Awards: Rookie of the Year Contender - 2020
Getting Started with Snowflake Tasks
Learn how to create and edit scheduled tasks when using Snowflake in this article.
Introduction to Snow Pipe
In this article we look at using Snow Pipe Snow to help keep data in a Snow Flake data warehouse in sync with object storage such as S3, Azure Blob or GCP.
Flask Python Reporting for SQL Server
In this article we look at creating an alternative reporting environment using Python Flask and SQL Server instead of using SQL Server Reporting Services.
SQL Server Management Studio Time Saving Tips
This tip covers SSMS features like filter objects, debug, drag and drop object names, custom reports and use of operators for emails.
Posting SQL Server Notifications to Slack
In this article we look at how to send Slack notifications when certain events occur in a SQL Server database.
SQL Server Regex CLR Function
In this article we look at how to build a SQL Server CLR function to use regex capabilities in SQL Server.
SQL Server RegEx Capabilities Using Python
In this article we look at how to get regex features in SQL Server by using Python and T-SQL.
SQL Server Bulk Insert for Multiple CSV Files from a Single Folder
Check out this article to see how to quickly import into SQL Server many files with the same structure using T-SQL.
SQL Server CDC Stored Procedure Alternative
In this article we look at a T-SQL script that can be used to identify and move data that has changed from one table to another table.