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

More sectors of business utilize data for business intelligence than ever before, from report writing to application development. Microsoft SQL Server can handle big data needs for a wide set of ...

SQL Compliance Manager is a database auditing solution that monitors and tracks changes to SQL Server objects and data, and sends alerts on suspicious activity. The product also generates audit ...

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

When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...

Microsoft Corp. is making progress on its JDBC driver for SQL Server 2000, the piece of code that gives Microsoft's flagship database a sanctioned connection to competing platforms. Gordon Mangione, ...

When in March this year Microsoft announced that it was bringing SQL Server to Linux the reaction was one of surprise, with the announcement prompting two big questions: why and how? SQL Server is one ...