(Craig S. Mullins) Row and column access control enables you to manage access to a table at the level of a row, a column, or both. It enables you to build policies for the particulars of which data can be accessed by specific users, groups, or roles.
Other News
Three Areas to Examine Before Your DB2 10 Migration
(Dave Beulke) 2012 has kicked off with a vengeance and everybody is back in the office and wants everything done right now. The crowded calendar continues and people want your DB2 migration to DB2 10 schedule as soon as possible. There is no time to get your existing applications and SQL improved be
SQL Joins with On or Using
(Lorna Jane Mitchell) I recently wrote a post about inner and outer joins, and a couple of people asked what the difference is between USING and ON.
XmlSerializer doesn’t work with Dictionaries. Oh, and it has problems with KeyValuePairs too.
(OriginalGriff) XmlSerializer complains if you try to serialize anything which implements IDictionary. This provides a way of serialising them which (if not capable of restoring the exact dictionary content) restores the actual field contents in a new dictionary.
Data normalization reconsidered, Part 2: Business records in the 21st century
(Susan Malaika and Matthias Nicola) Relational databases have been fundamental to business systems for more than 25 years. Data normalization is a methodology that minimizes data duplication to safeguard databases against logical and structural problems, such as data anomalies. Relational database n
Inside the Concurrent Collections: ConcurrentStack
(Simon Cooper) The first concurrent collection we’ll look at is ConcurrentStack. This is conceptually the same as System.Collections.Generic.Stack, but is geared towards occasional concurrent modifications.
New SQL Server 2012 DMVs to get configuration, installation and memory dump information
(Ashish Kumar Mehta) SQL Server 2012 code named Denali has a lot of new features to offer. A new set of features include new DMVs that can return SQL Server configuration, installation and memory dump related information.
ELMAH
Reporting Services Webcast Next Wednesday Data-driven Subscription using SSIS… SQL Server Reporting Services provides a powerful tool to render reports based on information in a database table. However, you are required to purchase an Enterprise license of SQL Server in order to use this feature. Next Wednesday (Feb. 1), Russel Loski, who is a Microsoft Certified Trainer and an independent […]
SQL Server Data Types Impact Performance
SolidQ Training in NYC and Las Vegas! In partnership with SolidQ, SSWUG announces two new seminars in March of this year! March 7-8, a fast-paced, in-person seminar on configuring and securing SharePoint 2010 and business intelligence services will be taught by BI expert Carl Rabeler in Las Vegas, NV. March 13-14, practical SSRS design techniques based on industry best practices […]
Inflating and Encapsulating layout xml into a View object in android
(Samir) There are two different ways that layout files in xml can be inflated into the Activity class. The most straightforward method, usually seen in introductory materials demonstrating android Activity, is to use the the xml in setContentView function for the activity. For example, here’s how th