You can grant read access to a view while revoking access to the base table. Updatable views however, require update access to the base tables.
Are You a SQL Server Master?Commented on: 6 years ago
(July 17, 2008)
Interesting article...but when it comes to certifications I don't value them too highly.
Sadly, I have worked with people who have have studied and studied to pass their Microsoft SQL Server...
How Sun's Acquisition of MySQL Will Affect SQL ServerCommented on: 6 years ago
(April 24, 2008)
I have been using MySQL for a year now as a database back end for various websites I operate. Although I am much more familiar with SQL Server (13 years!) I really do appreciate what you can do with...
Stored Procedure Documents Scheduled Jobs in SQL ServerCommented on: 6 years ago
(March 4, 2008)
This stored procedure has been tested on a variety of SQL Server installations and has been running without error for years (the original code was developed in 2002 for SQL 2000).
Despite similar intentions and high-level goals, the ways in which AlwaysOn Failover Cluster Instances and AlwaysOn Availability Groups tackle high availability and disaster recovery are quite different....More
While AlwaysOn Availability Groups are a powerful solution that let DBAs tackle both high availability and some disaster recovery concerns from within a single, unified, set of technologies and tooling, AlwaysOn Availability Groups also come with a number of challenges....More
For some businesses, conducting a health check can be cumbersome, time-consuming, and the results, well, frustrating. However, a health check can be easy and rewarding for any business that wants to improve server performance, especially if you take the time to find the right solution provider....More