(Mark Kendall) I was excited about the new data connectivity features (BDC) of SharePoint 2010 when it was first released. In fact, External Lists were a staple in our development shop, and an “everything is a list” was the standard operating procedure SOP.
Other News
Retrieving Data with String and Arithmatic Expressions
(Joel Murach) In this third part of a nine-part series on retrieving data from tables with the SELECT statement, you will learn how to code both string and arithmetic expressions.
Automatically Capturing SQL Server Performance Metrics
(Gregory A. Larsen) A few months back I wrote an article on monitoring SQL Server performance. In that article, I defined 10 counters you should watch and monitor when looking at your SQL Server performance. One of my readers asked how you might programmatically collect these counter values.
‘The SQL Guy’ Post # 1: BEST PRACTICES FOR USING SQL SERVER NETWORK PROTOCOL
(DamirB) When I first joined my team at Microsoft, I was labelled “the SQL guy” for my SQL Server and Oracle background by others on the team. It didn’t help that the first major event that I was involved with at Microsoft was the SQL Server 2005 Launch Tour.
Implementing IBM InfoSphere Change Data Capture for DB2 z/OS V6.5
(Jason Arnold) IBM InfoSphere Change Data Capture for z/OS uses log-based change data capture technology to provide low impact capture and rapid delivery of changes to and from DB2 z/OS in heterogeneous environments without impacting source systems.
Indexes in MySQL
(Nilnandan Joshi) There are several types of indexes are available in MySQL:
Uploading and downloading files to/from a SQL Server database
(jchoponis) A while ago, I was working to find the right syntax and method for saving and retrieving files (.doc, .txt, .pdf) with regard to SQL Server 2005/2008. While I had found a few good examples showing how to upload files to a binary field type in SQL Server, I found a lack of good samples sh
End-to-end database monitoring with Optim Performance Manager Extended Insight
(Sujan Ghosh, Rajesh Sambandhan, Asim Singh, Anshul Dawra and David Chang) Learn how you can use IBM Optim Performance Manager Extended Insight to monitor end-to-end database response time for Java and CLI applications. Extended Insight extends database monitoring across the database client, the app
Moving database files for a replicated SQL Server database
(Mohammed Moinudheen) I am running out of disk space for one of my SQL Server replicated databases. I would like to move the database files of my publication database, which is part of transactional replication, to a drive on the same server, which is has more free space. Which is the better option
Is Access Dead?
Is Access Dead? Microsoft Access has filled a niche in software tools for departmental applications for many years. It provides a lot of rich functionality for less technical individuals to use filling business data requirements when development resources are not available. Some people have tried to create applications with a broader user base having different levels of success. The product […]