In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...
Among many new features, Microsoft's new database management system is well-suited for applications that require uptime and portability. With the recent release of SQL Server 2012, Microsoft is ...
Full disclosure: I am a co-author of an upcoming book on SQL Server 2012, and I do a lot of work with Microsoft. Why would a new version of SQL Server be a big deal for this blog? As a mainstream ...
Microsoft recently updated SQL Server Data Tools (SSDT) with support for Visual Studio 2012, improved LocalDB functionality and new SSDT Power Tools. SSDT, if you're unfamiliar with it, is a ...