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 ...

Development hiring managers and potential interviewees may find these open-ended SQL Server proficiency interview Q&As useful. The first installment of this TechRepublic series focused on C# developer ...

For developers working with SQL Server, few performance tuning techniques are as essential--or as frequently misunderstood--as indexing. Done right, indexing can drastically improve application ...

As a heavy user of other RDBMS data platforms, I have long appreciated the extra effort that Microsoft put into their data management and administration tool, the SQL Server Management Studio (SSMS).

An application that is based on Visual Studio for developing solutions for SSIS, SSAS, or SSRS is called Business Intelligence Development Studio, or BIDS. With SQL Server 2005, it was introduced. It ...