If you want to take a copy of one table and make a copy of it in another schema (under another username), you can use the SQL*Plus COPY command, or a simple <code>"create table foo as select * from ...

xSQL Software, a provider of SQL Server auxiliary tools and utilities, announced today the availability of xSQL Object 1.5, a utility for SQL Server database administrators and developers that ...

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

This is where the differences between SQL Server security and networking security begin to show up. With SQL Server, you need to grant access to three areas: SQL Server, the database, and the objects ...

PowerShell gives DBAs a reason to begin using SMO for real, so now we'll find out about all the gory details I was talking to a good friend at Microsoft last week, telling him about the problems I’ve ...

The basic distinction between these two O/RMs is that Entity Framework (EF) is targeted at enterprise scenarios, while LINQ to SQL is best suited for rapid application development (RAD) with SQL ...