Using SSDT means we don't just shout orders at the database; instead, we plan what we're going to say. For almost 13 years, Microsoft has tried to make Visual Studio a place where developers can do ...

My colleague, senior editor, Kathleen Richards was at MIX08 in Las Vegas two weeks ago. Suffice to say she received a brain dump on Silverlight and a number of other big announcements there. When she ...

SQL Servers allow the import or export of database diagrams to another database. All the information related to a database is stored in the dtproperties table. Therefore, to import or export a ...

As you will see in this chapter, companies use SQL Server for many types of applications and on most tiers now. Gone are the days when you would second guess yourself choosing to use SQL Server over a ...

One of the seven editions of SQL Server 2008 is aimed at Web hosting firms as Microsoft responds to growing interest in cloud computing Microsoft Corp. began making SQL Server 2008 available to users ...

StreamSets, provider of a DataOps platform, is supporting and integrating its platform for Microsoft’s recently announced SQL Server 2019 Big Data Clusters. With this integration, SQL users are ...

Microsoft is responding to the “Big Data” movement by adding support for the open source Hadoop framework for large-scale data processing to its SQL Server database and Parallel Data Warehouse ...

When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...