There are two types of roles, one for the server and one for the database. Server roles are groups that allow you to control the management of SQL Server. They allow you to grant others the rights to ...

SQL Server expert Kevin Kline has kicked off a multi-continent roadshow, sharing his deep SQL knowledge and best practices at a series at a series of SQL Saturdays and SQL Server User Group meetings. ...

Microsoft SQL Server installation is simple when system requirements and edition choices are planned.Choosing the right authentication mode, such as ...

Dr. Chris Hillman, Global AI Lead at Teradata, joins eSpeaks to explore why open data ecosystems are becoming essential for enterprise AI success. In this episode, he breaks down how openness — in ...

Because SQL Server manages security identifiers (SIDs) for any user logging into SQL Server, you risk "orphaning" users when you do a restore. It's a common problem, and here's why. Typically, ...

Kevin Kline, director of engineering services at SQL Sentry, Microsoft SQL Server MVP since 2004, founding board member of PASS, and DBTA columnist, is hitting the road this summer to reach cities ...

Microsoft's latest relational database management system contains a host of new features, but are they enough to make you migrate? The wait is over. Microsoft has finally released SQL Server 2008, the ...