MCPmag

Introduction to SQL Server Management Objects with PowerShell

Sometimes you become the accidental DBA, or you are the DBA by choice. Either way, you can choose to spend time working in SQL Server Management Studio (SSMS) to look at things such as backups or the ...
ZDNet

Using SQL*Loader to load objects

SQL*Loader is a fast and easy way to get data into a database without writing long, complicated scripts. However, when it comes to Oracle objects that are related to each other, things can get ...
Entrepreneur

What Is SQL and How Does It Work?

Out of all the programming languages you need to learn in the IT industry, SQL is one of the most important. SQL is so integral to modern big data access and organization processes that it’s never a ...
MCPmag

Working with Database Users and Roles Using PowerShell

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