Countless scenarios involve data migration and integration. One of the most common tasks, yet often fraught with pitfalls, is importing data from one database into another SQL Server instance. This ...

This article describes how to set or change the database collation by using SQL Server Management Studio (SSMS) or [!INCLUDE tsql]. If no database collation is specified, the server collation is used.

Microsoft announced the general availability of Visual Studio 2022 v17.6, bringing a host of new features, improvements and bug fixes to the flagship IDE. Released shortly before the company's big ...

Identify which data modeling tools are right for your business. Discover the top tools of 2022 now. Data modeling tools play an important role in business, representing how data flows through an ...

Data modeling best practices help define a formal process that gives structure and direction to an organization’s data. Read more about data modeling now. Data modeling, at its core, is the process of ...

When I joined the SQL Tools team as a PM back in October 2018, my top priority was to release SQL Server Management Studio (SSMS) 18. I expected a fair amount of work but didn’t realize how ...

We are excited to announce the release of SQL Server Management Studio (SSMS) 17.3! Download SSMS 17.3 and review the Release Notes to get started. SSMS 17.3 provides support for almost all feature ...

This topic provides an overview for using the bcp utility to export data from anywhere in a [!INCLUDEssNoVersion] database where a SELECT statement works, including partitioned views. The bcp utility ...

I wanted to write this blog post after a couple of Dynamics AX Performance Review where the Targeted scenario was execution of the MRP Batch. Every situation is different but there are similarities as ...

The importance of automating processes can’t be overestimated. Most things start out as a manual procedure until you work out exactly how things should happen, but many times they stay that way ...