(Rob Styles) I’ve been meaning to write this post for a little while, but things have been busy. So, with this afternoon free I figured I’d write it now.
Other News
IOT Secondary Indexes – The Logical ROWID Guess Component Part I (Lucky)
(Richard Foote) As discussed previously, an index entry within a Secondary Index on an Index Organized Table (IOT) basically consists of the indexed column(s) and the Logical Rowid, the PK column(s) and a “guess” to the physical block in the IOT containing the corresponding row.
Windows Azure: Working with Blob Storage in an ASP.NET Application
(Mahesh Sabnis) While developing high scalable and always available applications on Windows Azure, it is important for you to think about the kind of data you want to store in the Cloud. Here data does not always mean that it is coming from a relational database. Here data could mean Images, Videos,
String Matching in LINQ
Performing simple string equality tests is often not enough when application user convenience is key. Often only a fragment of a string is known to the user, or many of them. Sometimes there is a need to search for a fragment in multiple columns.
Adding SQL Full-Text Search to an existing SQL Server
(Rick Vanover) I don’t know about you, but I deal with a lot of applications that require SQL Server as their back end database. I like SQL Server for many reasons. For starters, it is broadly supported by applications. But probably most importantly, is that I feel I can support it to a certain exte
Changing an Analysis Services instance to tabular mode
(Cathy Dumas) Say you have already installed an Analysis Services instance of SQL Server 2012. Maybe you made a mistake in setup and accidentally set it up as a multidimensional instance. What do you do?
Taming DB2 for z/OS Dynamic SQL with Optim pureQuery Runtime
(Robert Catterall) There was a time, not too many years ago, when dynamic SQL was relatively uncommon in many DB2 for z/OS environments. DB2 systems programmers and DBAs insisted on the use of static SQL, and very often got their way.
DB2 Application Design for Big Data
(Lockwood Lyon) Current use of the term big data is a result of the confluence of several industry trends over the last decade. These trends include accumulation of large amounts of data in databases, the advent of the data warehouse, multiple means of high-speed data transfer, and an explosion in t
MySQL: Creating, Listing, and Removing Databases
(wubayou) Today’s MySQL database tutorial covers a few basic concepts. Specifically, we are going to discuss how to create a MySQL database in the first place. Next, you will learn how to list and select databases in MySQL. Finally, you will see the steps to remove databases in MySQL.
Practical Approach of Creating User Control in ASP.NET
(Lajapathy Arun) In this article we are going to see how to create a user control in ASP.NET.