Database Management Systems
Learn about database management systems such as Relational, NoSQL, Key-Value Store, Document, Graph, Wide-Column Stores, In-Memory and more,
Other Database Platforms
Check out these valuable tips, tutorials, how-to’s, scripts, and more on SQL Server Other Database Platforms perfect for SQL Server DBAs.
How To Transfer Data from MySQL to SQL Server
In this article, we look at how to migrate data from MySQL to SQL Server and how to keep the data between the two databases synchronized.
Pandas Dataframes Memory Error – MemoryError: unable to allocate
Learn how to reduce your memory needs when working with Pandas Dataframes and avoid the error MemoryError unable to allocate memory.
Create, Populate, and Subset a Pandas Dataframe from a CSV File
Learn how to transfer data via a CSV file from a SQL Server database to a Pandas dataframe and then subset the dataframe in Python.
Snowflake Tutorial Overview
In this Snowflake tutorial, we go over the basics of the product and features which make it stand out against its competitors.
Setting up a Snowflake Account
Learn how to setup a Snowflake account and activate your account in this step by step outline to get started with Snowflake.
Snowflake Architecture and Pricing Example
Snowflake architecture is built for the cloud with true separation of storage and compute. Learn about Snowflake Architecture and pricing.
Creating a Snowflake Database Schema and Tables
In this part of the tutorial we will see different methods for creating database objects.
Loading Data Into Snowflake
In this part of the tutorial we look at the COPY INTO statement which is able to load data quickly and efficiently into a table.
Querying Data in Snowflake
In this section we look at how to query Snowflake data and how to get better performance for queries.
Snowflake Query History
In this section of the Snowflake tutorial we look at how to get Snowflake query history for queries that have been executed.
Snowflake Time Travel
Learn to query data from different points in time to move forward and backwards with how the data has changed with Snowflake time travel.
Snowflake Regular Expression, Alias and ILIKE
Learn about features in Snowflake such as a Snowflake regular expression, Snowflake alias and Snowflake ILIKE.
Power BI and Snowflake
In this part of the Snowflake tutorial we take a high level view of how to query Snowflake with Power BI to build reports.
Snowflake Tutorial Next Steps
This article has several additional things you can do to continue your Snowflake learning with these Snowflake next steps.
Import and Export Data between SQL Server and Cognos TM1 Cube
Learn how to import and export data between SQL Server and a Cognos TM1 data cube.
Generating SQL Server Create Table Scripts from DB2 Create Table Scripts
In this tip we look at using SSIS to read through DB2 create table scripts and converting them to be valid create table scripts for SQL Server.
Comparing some differences of SQL Server to SQLite
What are some of the differences in the way that Microsoft SQL Server and SQLite implement the SQL Language? Read this tip to learn about some of the differences.
Export Data from IBM DB2 iSeries to SQL Server
Learn how to connect to an IBM DB2 for iSeries database from SSIS to move data to SQL Server.
Compare SQL Server and MariaDB Operational Technology
In part 1, part 2 and part 3 of this series, I compared SQL commands for MariaDB and SQL Server. In this tip, we will review some of the operational items related to the database platforms.
More SQL command comparisons between SQL Server and MariaDB
In this tip we will compare how to do things in SQL Server versus MariaDB such as concatenation, cursors, how to split comma separated values, how to import xml data and more.
Code Comparison for SQL Server vs. MariaDB
I have a need to work with both SQL Server and MariaDB. I need to know how to complete some common coding best practices. Can you provide a code comparison for MariaDB vs. SQL Server as it pertains to how to comment, how to create functions and procedur
Compare MariaDB vs SQL Server SQL Commands
If you are making the transition from MariaDB to SQL Server or vice versa it is helpful to have a crosswalk of similar commands between the two platforms. Sure you can do some searches to find the answer, but it would be helpful to have a list of common t
Using SAS ACCESS and PROC SQL to Save SAS Data in SQL Server
Have you been tasked with transferring data from a SAS dataset supplied by an outside organization to a SQL Server table? Do you have internal SAS developers creating results in SAS datasets that need to be stored in SQL Server? Are you or others in your