TDS Remoting: A Better Way to Create Linked Servers for ODBC Sources
TDS remoting services provide a native SQL experience with local and remote ODBC data sources (contrast with limitations of using OLE DB).
2017-08-28
3,620 reads
Articles
Implementing Azure SQL Data Sync in the Azure Portal
Azure SQL Data Sync, which has been lingering in the Preview mode since its introduction seven years ago, no longer requires the use of the Azure classic portal; you can finally access it by using the current Azure portal. Marcin Policht steps you through the process of implementing Azure SQL Data Sync using this interface.
2017-08-28
2,868 reads
SQLCMD Mode; Run all SQL files in a directory
SQLCMD Mode gives you the ability to access command line executables via SSMS. Using creative approach, you can automate the execution of all files within a specified directory.
2017-08-25 (first published: 2015-09-14)
25,383 reads
Why PolyBase Matters
An alternative approach to disaster recovery and backup strategies using PolyBase.
2017-08-25 (first published: 2015-08-10)
7,245 reads
The Basics of Good T-SQL Coding Style – Part 3: Querying and Manipulating Data
SQL was designed to be a third-generation language, expressed in syntax close to real language, because it was designed to be easy for untrained people to use. Even so, there are ways of expressing SQL Queries and data manipulation in ways that make it easier for the database engine to turn into efficient action. and easier for your colleagues to understand. Robert Sheldon homes in on data querying and manipulation and makes suggestions for team standards in SQL Coding.
2017-08-25
5,735 reads
Data Migration : Step by Step
This article by Chris Kempster covers a wide variety of areas concerned with data migration. Primarily, it focuses on process, standards and some of the many issues to consider when undertaking this role.
2017-08-23 (first published: 2004-03-24)
56,838 reads
Portable DTS Packages
Have you ever faced the situation where you have needed to move a DTS package you needed to move a DTS package from one server to another, say from development to production? In this article by Kevin Feit, he shows you how to make a DTS package portable and save time.
2017-08-23 (first published: 2003-05-09)
34,016 reads
Using Exotic Joins in SQL Part 1
When most developers think of joins, they think of a.SomethingID = b.SomethingID. This type of join, the equijoin, is vitally important to SQL programming; however, it only scratches the surface of the power of the SQL join. This is the first in a series of articles that will look at several different types of exotic joins in SQL. This article will focus on using the BETWEEN operator in joins when dealing with range-based data.
2017-08-23 (first published: 2003-01-22)
37,994 reads
Installing SQL Server Agent on SUSE Linux
Manvendra Singh explains how to install SQL Server Agent on SUSE Linux server, so that you can create SQL Server Jobs to schedule repetitive work.
2017-08-23
3,181 reads
How to Find Out Which Database Object Got Deleted
Greg Larsen shows you how to use the Transaction ID value to identify the object_id for a deleted table.
2017-08-22
4,419 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
SQL Server 2019 - Agent job PowerShell step issue
I have a couple of SQL Agent job steps which run PowerShell commands of...
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers