SQL Server 2008 SP1 CTP

Download the CTP of SQL Server 2008 SP1.

Read more from the original source: 
SQL Server 2008 SP1 CTP

SQL Server 2008 Express Edition SP1 CTP

Download the CTP of SQL Server 2008 Express Edition SP1.

See the rest here: 
SQL Server 2008 Express Edition SP1 CTP

.NET Basics for the Database Developer: Take the Plunge

This short introduction to .NET shows Access and SQL Server developers how to use a development tool to create connections to data and a user interface to manipulate that data.

Read the original here: 
.NET Basics for the Database Developer: Take the Plunge

PHP on Windows Training Kit

The PHP on Windows Training Kit includes a comprehensive set of technical content including demos and hands-on labs to help you understand how to build PHP applications using Windows, IIS 7 and SQL Server 2008.

Continued here: 
PHP on Windows Training Kit

Microsoft details changes coming to SQL Data Services

After acknowledging a couple of weeks ago that it was changing direction with SQL Data Services (SDS), Microsoft officials are filling in the gaps about exactly what will be changing when.

Read the original here:
Microsoft details changes coming to SQL Data Services

ComponentOne Offers Innovative Web Parts for Microsoft Office …

ComponentOne DataGrid(TM) for SharePoint (C1DataGrid) provides a scrollable view of an Office SharePoint Server 2007 list or Microsoft SQL Server query …

Here is the original:
ComponentOne Offers Innovative Web Parts for Microsoft Office …

Use VBA To Reset Task Due Dates in Outlook

There was an earlier version of this post. It had more words and as it went on and on about how I track damn near everything in Outlook. It’s true. Everything. If I don’t track something I want to do or have to do as an Outlook task, it won’t get done.

I deleted that post by accident as I thought I was deleting something else. As it turns out, the wrong Window had the focus when I hit the Delete button and I deleted this post. Dammit!

Anyways, I always fall way behind on the deadlines I set for my tasks. So each Monday morning, I set the deadlines to a week from the current day.

Here is the VBA code to achieve this.

Sub ResetTaskDeadlines()
    Dim ns As NameSpace
    Dim fld As Folder
    Dim task As TaskItem
    Dim items As Outlook.items
    Dim rest As Outlook.items
    Dim filterSQL As String

    Set ns = Application.GetNamespace("MAPI")
    Set fld = ns.GetDefaultFolder(olFolderTasks)
    Set items = fld.items
    filterSQL = "@SQL=" & """http://schemas.microsoft.com/mapi/id/"
    filterSQL = filterSQL & "{00062003-0000-0000-C000-000000000046}/"
    filterSQL = filterSQL & "81010003""" & " <> 2"
    Set rest = items.Restrict("[Status] <> 'Completed'")

    For Each task In rest
    ''UNCOMMENT THE OPTION YOU WANT TO USE
        ''task.DueDate = "1/1/4501" 'Set to NO Due Date
        ''task.DueDate = task.DueDate + 7 ' Set to 7 days from current due date
        task.DueDate = today() + 7 'Set to a week from today
        ''task.DueDate = FirstDayOfNextMonth ' Set to first day of next month
        'task.Save
    Next

End Sub

Function FirstDayOfNextMonth() As Date
   Dim d As Date
   d = Date
   FirstDayOfNextMonth = DateSerial(Year(d), Month(d) + 1, 1)
End Function

I pretty much use VSTO to build Outlook add-ins professionally. But for quick personally useful scripts like this, VBA still reins.

Managing Files with SQL Server 2008′s FILESTREAM Feature

SQL Server’s new FILESTREAM feature simplifies the process of keeping file-based data, such as images, in sync with relational data.

Read more: 
Managing Files with SQL Server 2008′s FILESTREAM Feature

How Do I: Setup and Configure the Excel Data-Mining Add-in?

New video on MSDN…

This video shows how configure to setup the Data Mining Client For Excel addin. This addin is part of the Microsoft SQL Server 2008 Data Mining Add-ins for Microsoft Office 2007 download available at: http://www.microsoft.com/DOWNLOADS/details.aspx?familyid=896A493A-2502-4795-94AE-E00632BA6DE7.

Here is the original post:
How Do I: Setup and Configure the Excel Data-Mining Add-in?

Microsoft Makes Sweeping Changes To BI Software Strategy

Read the original here:
Microsoft Makes Sweeping Changes To BI Software Strategy

By Mary Hayes Weier Microsoft will discontinue PerformancePoint Server as an independent product and will fold some of its capabilities into SharePoint … See all stories on this topic