I've been playing around with the new SQL Server Data Tools, and although many have complained about missing features compared to the "Data Dude" Visual Studio projects and other tools that SSDT ...

Microsoft's SQL Server toolbox is a morass of acronyms, from SMO to SSMS to SOS, and differentiating one from the other can be a challenge. I recently caught up with Vicky Harp, lead program manager ...

Fresh on the heels of SQL Server 2014 being released to manufacturing, the SQL Server Data Tools (SSDT) team yesterday announced support for the new version, along with numerous other enhancements.

I've been working with SQL Server for over 20 years now, Generally, I limit my tools to the things I might expect to find in a given client environment. My toolbox typically includes the tools that ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

SQL Server is primarily built around a row-based table structure that connects related data elements in different tables to one another, avoiding the need to redundantly store data in multiple places ...

Every business needs a well-designed database management tool. Finding a well-organized, functional system that allows your team to perform data-related tasks with ease is crucial to the success of ...

SQL Server Drill Down explores all aspects of Microsoft SQL Server and related applications, with a particular emphasis on issues of interest to SQL Server data professionals. Key areas of focus ...

Integration of Python for data science, graph processing for NoSQL-like functionality, and it runs on Linux as well as Windows. At almost 30 years of age, Microsoft's flagship database has learned ...

Microsoft’s SQL Server Migration Assistant lets you move your data and schema to different SQL Servers. Here’s what you need to know about the tool. The Microsoft SQL Server Migration Assistant is a ...