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

Ok, for SQL server 2000, I need to change the account it runs under. <BR><BR>I know you need to go to the Enterprise Manager, find the database, right click, properties, choose security tab, and at ...

Microsoft continues to make positive strides in the world of open source. The company once considered open source software to be an anathema, but now it’s common for Microsoft to pull software ...

The first installment of this TechRepublic series focused on C# developer interview questions. It generated a lively discussion on the merits of such questions and the different approaches to ...

When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...

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

Today, at its Ignite conference in Orlando, Microsoft is announcing the general availability of a new version of its flagship operational database, SQL Server 2017. SQL Server is a product I have ...

Join our daily and weekly newsletters for the latest updates and exclusive content on industry-leading AI coverage. Learn More At the PASS Data Community Summit in Seattle today, Microsoft announced ...

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database. In part one of this article, I described a ...