Check out these valuable tips, tutorials, how-to’s, scripts, and more on SQL Server Other Database Platforms perfect for SQL Server DBAs.
Have you been tasked with transferring SQL Server data for several different SAS analysis packages or even for a single package on a recurring basis? Are the precise inputs for the SAS pack(s) subject to change? Do you have to enable SAS developers to cre
Have you ever needed to store and use results computed by a SAS Analytics package in a SQL Server database? This kind of requirement comes along very infrequently, but it is imperative to understand the different outputs and columns for matching results b
Do you need to make SQL Server data available for a SAS Analytics package? Do you also need to accept some data back from a SAS package and also process the returned values? In this tip we cover how a SQL Server professional with limited or no SAS experie
Learn about the different types of maintenace tasks you should perform on SQL Server databases.
The SQL Server databases require fine tuning of queries from time to time to optimize performance.
This part describes different ways to schedule and automate tasks for MySQL and SQL Server.
This section covers what is different in backing up databases for MySQL and SQL Server.
Understanding how locks are handled is very important and this covers the basics of the locking MySQL and SQL Server.
The code snippets show examples of the transaction management functions that are different in MySQL and SQL Server.
In this chapter we will discuss how to migrate your data from MySQL to SQL Server.
The code snippets show examples of commons functions which are different in MySQL and SQL Server.
This chapter describes the most important data types in MySQL and their equivalents or recommended migration targets in SQL Server.
There are several different editions of Microsoft SQL Server and this may be a bit confusing for MySQL users. This page describes the differences.
Learn about the steps to take to migrate from MySQL to SQL Server.
In this tutorial we will explore the differences between MySQL and Microsoft SQL Server and the key components that you should be aware of when making that move.
Is Microsoft SQL Server superior to MySQL or not? What are the pros and cons of using SQL Server over MySQL? Is MySQL mature enough to compete with a big player like Microsoft and Oracle? Can we fairly compare both products?