Οκτώβριος 2011 - Δημοσιεύσεις
In this post I would like to talk about Security in SQL Server. This is a very big topic and you should embrace yourselves for a very long post. I know there are samples of how to use secure data in BOL,MSDN and elsewhere but I thought that it would be
Διαβάστε περισσότερα
In this post I would like to look into Views in SQL Server. As always I will demonstrate all the various concepts with hands-on examples. I know that all these concepts are well documented elsewhere. I will try to look into views with step by step instructions
Διαβάστε περισσότερα
In this post I would like to show a few examples of built in T-SQL functions and global functions. I teach T-SQL to people from all walks of life and many of them have asked me to write a simple post with examples of the most commonly used T-SQL functions
Διαβάστε περισσότερα
In this post I would like to show a few examples of how to use triggers in SQL Server. I would like to talk about the uses of triggers, the type of triggers and some misconceptions about the triggers. I know there are samples of how to use triggers in
Διαβάστε περισσότερα
In this post I would like to talk about data compression/backup compression features available to us in SQL Server 2008 and R2 editions. I will talk about Data Compression and Backup Compression. Data Compression is only available in Enterprise (SQL Server
Διαβάστε περισσότερα
In this post I would like to talk about SQL Server Audit. This new way of auditing was introduced with SQL Server 2008.This feature is supported in SQL Server 2008 Enterprise edition.Auditing is simply the process of monitoring and tracking changes to
Διαβάστε περισσότερα