I have worked with SQL Server for many years now, back to Sybase SQL Server days and there has always been confusion over Logins and Users. Even though they typically use the same name they are ...

We have a SQL Server database setup here that users access as part of a class. The professor is requesting that the users be able to create and drop tables in their own "workspace" while they're in ...

How do I assign permissions to users to see SQL Agent Jobs? Your email has been sent You can give your users rights to check if reports have run or jobs are complete without granting full admin rights ...

SQL Server 2008 R2, which ships this month, allows end users to tap into the powerful business intelligence features of SQL Server via tight integration with popular Microsoft applications like Excel.

Early discussions on SQL Server 2008 seemed to suggest that it would really only be a point release, quite unlike what occurred with SQL Server 2005. Anyone looking at the new and upgraded features in ...

Organizations can use SQL Server to reduce downtime, manage and secure databases, and discover patterns in mission-critical information to improve business intelligence. To rebuild a corrupted master ...

Have you implemented SQL Server 2000 Reporting Services since it became available earlier this year? If so, we’d love to hear about your experiences, both good and bad. Have you implemented SQL Server ...

Kevin Kline is president of the Professional Association for SQL Server (PASS), an independent group for users of Microsoft Corp.'s SQL Server database. PASS is holding its annual conference in ...

Microsoft is offering users on Windows Server 2008 and 2008 R2 and SQL Server 2008 and 2008 R2 a way to keep getting security updates for free after the official support period ends. Read also: Here's ...

Microsoft laid out the case for enterprises to ditch Oracle's database system for its own at this week's Data Driven conference in New York City. Exec Judson Althoff detailed a SQL Server 2016/Oracle ...