During the last few articles, we have covered the basics of working with SQL server using the Server Management Objects (SMO) and PowerShell. We have covered things such as viewing the state of ...

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

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

SQL Server on Azure Local is generally available. Review disconnected deployment requirements, separate licensing, and ...

It used to be that finding and using a sample SQL database was quite simple. In fact, the venerable Pubs database used to be installed as part of the SQL Server installation process. Fast forward to ...

Like every version before it, Microsoft SQL Server 2019 is jam-packed with features and capabilities -- and not just the support for big data clusters that the company highlighted when it released the ...

If your business uses Microsoft SQL Server, you may want to have multiple instances of servers on multiple computers for synchronization or backup purposes. Microsoft SQL Manager lets you accomplish ...