We've been exploring the usefulness of one of the best features of the upcoming version of SQL Server 2005 codenamed 'Yukon'. We've seen how you can create UDIs (User Defined Functions), Stored ...

A relational database table is articulated on a fixed number of columns and each column has its own data type, such as strings of variable or fixed length, dates, numbers, Booleans and the like. JSON ...

Dynamic Data Masking in SQL Server 2016. Dynamic data masking ensures that non-privileged users see only the data they are permitted to see while other data is masked. The big benefit is that, once ...

Take advantage of the open source library Serilog to log your ASP.NET Core application’s data to SQL Server or another database target. Logging is an essential feature for any application, as it ...

SQL Server Backup Types. New! Welcome to this new series of columns for working with SQL Server. First, let's talk backups. By Eric Johnson; 10/08/2007; Welcome to this new series -- in this column, I ...

To learn more about SQL data types, read “SQL basics: String data types, ... (UTC), where 00:00:00 represents midnight in Greenwich, and the server’s local time zone is implied.