(Wei-Meng Lee) With the release of Visual Studio 2008, Microsoft has also updated the VB language to the latest version 9.0. VB 9.0 boasts several key language enhancements that have been made to support the new Language Integrated Query (LINQ) feature that Microsoft has earlier announced. Part 2 of
Other News
How to Handle Recursive Relationship in ASP.NET with SQL Server Database
(Thomas Yan) I was involved in the development of a Corporation Authorization Matrix Management System which maintains the information about who would approve certain IT system access to internal or external end users for specific organizational unit(s). It was aimed to help enforcing the compliance
Executing multiple stored procedures within a single transaction context from ADO.Net
(Santhosh Veeraraman LnT) This aims to explain how we can execute different stored procedures in ADO.Net with different parameter values with in a single Transaction context, so that if anything gone wrong in any of the stored procedure, all others should be roll backed or else committed.
Understanding Variables in VBScript
(Nilpo) In VBScript, as with any programming language, it is extremely important to familiarize yourself with variables and how they work. Variable usage in VBScript is highly simplified, but before we begin, let’s take a look at what variables are exactly.
The Baker’s Dozen: 13 Tips for Querying OLAP Databases with MDX
(Kevin S. Goff) MDX is just like Transact-SQL, right? MDX is English-like and therefore easy to learn, right? Different software tools offer MDX generators and therefore I don’t need to learn MDX, right? MDX isn’t that popular, right?
Composite keys, selectivity and range scans involving date columns
(Justin Swanhart) Typically, when choosing a composite index structure, your favorite DBA will tell you to put the most selective columns first. Now, when I tell people that I tend to get a few blank stares, so first, what does selective really mean?
Build directory structures using SQL Server 2005
(Tim Chapman) If you ever work with directory structures on the filing system, you know how challenging it can be to traverse through folders to find specific file(s). If you store this type of information structure in the database, you are even more aware of what it takes to retrieve the data. Writ
Set based delimiting of strings to columns
(Simon Sabin) I recently presented on using CLR in SQL at DevWeek and commented on how TSQL Udfs just don’t perform. A common scenario people in the audience were using TSQL Udfs for was splitting delimited strings.
Adding Reporting Services to an existing SQL Server installation
(Tim Ford) Servers don’t last forever. With Microsoft SQL Server 2005 going on three years many of us are in the process of acquiring new hardware and getting new instances up and running. In our company this means a shuffle of some of our Database Services, Reporting Services, and Analysis Service
Webcast Today – Data Protection Options
(Shhh…. the SQL Server Virtual Conference for June has soft-launched…) Webcast Today Data Protection and Recovery Options with SQL Server We’ll look into the various data protection options you have with SQL Server when it comes to setting up a recovery system for your server. We’ll explain the pros and cons of each and where you can apply them in […]