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

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

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

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

SQL Server 2022: Here’s what you need to know Your email has been sent Three decades on, SQL Server is still a database workhorse that powers both an internal line of business applications and ...