(Michael Singer) Making sense of related data has never been so necessary for enterprises trying to achieve a competitive advantage, which is why CIOs from several verticals are looking to semantic technology for help.
Other News
Oracle 11g Security – Setting default auditing as recommended by Oracle
(James F. Koopmann) Most of us probably give no thought to the auditing being done within an Oracle database. If we just fly through database creation we may not ever know that auditing is actually activated.
RUNSTATS and REORG-3: An effective REORG policy
(Sameer Kumar) Hi guys… so I am back with my blog sequence on reorgs and runstats… So just a recap my last two posts in this sequence had just explained “what is the importance of using RUNSTATs and REORGs” and then I discussed “How to ‘effectively’ automate RUNSTATS”…
How to compare the record differences of two similar tables
(0v34c10ck) The CHECKSUM TABLE result sets of two similar tables only indicate if there are differences between the two tables. It does not tell you what exactly the differences are between the two.
Basics of creating and using classes in C#
(Daniel Clark) In the previous chapter, you looked at how the .NET Framework was developed and how programs execute under the framework. That chapter introduced you to the Visual Studio IDE, and you gained some familiarity with working in it.
Update and Delete Rules for SQL Server Foreign Key Relationships
(Atif Shehzad) Foreign key constraints are an integral part of SQL Server database design. These are used to maintain integrity among related data in different tables. While implementing update and delete operations on values in the parent table (referenced table with primary key) we have to conside
Index Defragmentation
New SelecTViews Show Meredith Ryan Smith on the show today, plus the latest news for the database world. Also, what do fingers have to do with injection and SQL Server? Find out on the show… [Watch the Show] Also: Watch last week’s show here Index Defragmentation Indexes are one of the key components impacting the performance of a relational database. […]
I’m trying to import a CSV file into a SQL Server table using DTSWizard, but I get data truncation errors. Why?
(John Savill) DTSWizard is a great tool for importing data into SQL Server, including importing from a CSV file. (CSV files can be created easily in applications such as Excel.) However, I recently tried to import data but kept getting data truncation errors, even though my SQL tables destination co
Monitor SQL Server Replication Jobs
(Yaniv Etrogi) The Replication infrastructure in SQL Server is implemented using SQL Server Agent to execute the various components involved in the form of a job (e.g. LogReader agent job, Distribution agent job, Merge agent job)
XSLT in 5 minutes
(Jeremy Morgan) This is a simple introduction to XSLT, or eXtensible Stylesheet Language Transformation. It’s a way of applying styles and formatting to XML files, and it’s pretty useful. It’s yet another acronym you see thrown around on job descriptions for Web Developers. Don’t be scared, it’s rea