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

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

Built on the .Net platform, xSQL Object 1.5 supports SQL Server 2000 and requires .Net Framework 1.1 or later. Pricing starts at $199 for a single-user license; $499 for a 5-user license; and $999 ...

Introduction to SQL Server Management Objects with PowerShell. Open up new reporting options for your SQL Server with these PowerShell tips. ... We can event look at and see all of the database users ...

SQL Server Management Objects: Finally ready for prime time. analysis. Mar 10, 2010 3 mins. Databases SQL. PowerShell gives DBAs a reason to begin using SMO for real, so now we'll find out about ...

With SQL Server 2016, you can store JSON objects in your rows. Here’s how to work with JSON objects, including how to update them once you’ve found them. In a previous Practical .NET column I showed ...