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

Windows 7 includes an ODBC manager that lets you connect from your desktop to a SQL server. You create a data source name (DSN) to save database setup information, so you can open a connection to the ...

SQL Server 2008 has a ton of new DBA features, but if you really want to make this thing go, just crank out a little code. SQL Server 2008 is mostly in the domain of system and database administrators ...

One way that organizations are storing data in the cloud is by moving their databases to the cloud. What once meant building an entire physical server, patching it, installing software like Microsoft ...

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

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

With demand for Microsoft SQL Server connectivity for Java applications growing steadily, and with many companies migrating their production platform from the 32-bit SQL Server 200 Enterprise Edition ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

Digital warfare and worldwide cyberattack rates are on the rise, and protection on corporate networks is even more crucial. Databases are a key target for cybercriminals due to the often valuable ...