This book is aimed at those new to SQL Server, or those with a basic understanding wanting to learn more. How does it fare? Beginnings are important. A bad start can stop you in your tracks and divert ...

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

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

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

SQL Server maintenance plans have been around since SQL Server 2000, but they've always been met with mixed reviews. This is in part because of their reputation for taking a sledgehammer approach to ...

With the latest public preview available, it’s time to decide if you want to upgrade to Microsoft’s most cloud-connected version of SQL Server so far. Three decades on, SQL Server is still a database ...

With the official release of Microsoft's latest database offering, let's see what was improved and what still needs some work. Today, at Ignite, Microsoft announced the general availability of SQL ...

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