Ok, I'm at a client site where they want to make a program database independent. This is a rewrite of an existing program that used an Access database only. I asked the person in charge how they were ...

Examine the similarities and differences between Windows security and SQL Server security and you'll find that most of the concepts you already know from managing a network will map quite nicely into ...

SQL Server has a long list of roles for server, database, and applications that outline things like permissions, data selection and modification, and disk management. Examine how roles play a part in ...

Note – This book abbreviates SQL Server 2008 Reporting Services as SSRS and SQL Server 2005 Reporting Services as SSRS2K5. New features available in SSRS and not in SSRS2K5 are labeled with “New in ...

There's an article on the MSDN website with tips that developers can use to improve the scalability of Compact Framework-based applications accessing SQL Server CE. "As mobility goes more mainstream, ...

Microsoft announced a new data access driver for SQL Server that should be the path forward for data developers in the era of .NET Core. As the traditional, Windows-only .NET Framework is basically ...

This article explains how to repair the MDF file using the native repair methods and how to use a Reliable MDF file Repair ...