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

Call it the great shift for database professionals. Many a “doomer-and-gloomer” has suggested that data professionals may be seeing their roles usurped by automation and skills appropriation to other ...

SQL is neither the fastest nor the most elegant way to talk to databases, but it is the best way we have. Here’s why Today, Structured Query Language is the standard means of manipulating and querying ...

Joel is an internationally recognized expert in the areas of security, networking and messaging. Follow him on X (formerly Twitter) @joelsnyder. Is the end of support for Microsoft SQL Server the push ...

You can give your users rights to check if reports have run or jobs are complete without granting full admin rights. Here’s how you can do so by using SQLAgentReaderRole in SQL Server. We may earn ...

As our platform evolves, we're looking for a senior Database Administrator with deep Azure SQL expertise to help us manage performance, scalability, and cost in a more structural and proactive way.