I'm using SQL Server's built-in encryption to hide data in one of my SQL Server databases, but this is a reporting system and my end users need to be able to query the data without having to remember the specialized decryption functions. Is there a way to do this? Yes, there is, via the use of views.
2013-10-29
4,794 reads
2013-08-01
2,386 reads
2012-12-24
2,347 reads
2012-10-15
2,306 reads
2012-10-08
2,479 reads
I need to create views? How many? Today? This article talks about a few issues with using views too extensively in your design.
2012-10-02
7,751 reads
Be sure to understand the consequences of modifying underlying tables and the affects they can have on Views
2012-07-10
5,350 reads
Joe Celko delves into the main uses of views, explains how the WITH CHECK OPTION works, and demonstrates how the INSTEAD OF trigger can be used in those cases where views cannot be updatable.
2012-06-21
4,945 reads
SQL Views are essential for the database developer. However, it is common to see them misued, or neglected. Joe Celko tackles an introduction to the subject, but there is something about the topic that makes it likely that even the experienced developer will find out something new from reading it.
2012-06-01
5,760 reads
2012-05-08
2,533 reads
By Chris Yates
I get asked a lot about why or how I began working with databases...
By Steve Jones
Earlier this year I visited a customer that was using the Redgate Monitor webhook...
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Choosing the right Ophthalmologist in Dubai starts with checking credentials, experience with children, and...
Comments posted to this topic are about the item SQL Server 2025 Unveiled: The...
Hi, we lost our sever sql2000 To restore database to a new one we...
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers