Jeremiah Clark's Blog

A place to collect my ramblings about Microsoft and the .NET Framework.

Browse by Tags

Tagged Content List
  • Blog Post: PowerShell and SQL Server Compact 4.0: A Happy Mix

    Using SQL Server Compact 4.0 from PowerShell is easy and powerful. Here is an example that shows how to reference the needed libraries, create the database, and add a table to the database – all from PowerShell. 1: $binpath = "C:\Program Files\Microsoft SQL Server Compact Edition\v4.0\Desktop\";...
  • Blog Post: Tip: Change the Owner of SQL Reporting Services Subscription

    Here is the scenario: Your organization has a SQL Reporting Server that generates custom reports based on some of your data.  These reports need to be generated each day at noon and then emailed to someone important.  So Tom, your current DBA, creates subscriptions for the reports so that they...
  • Blog Post: SQL 2008 February CTP

    The SQL Server 2008 Feb CTP has been released and can be found here: I can't wait to test some of the new spatial features, compression, and the long awaited MERGE statement.
  • Blog Post: SQL: If Exists Update Else Insert

    This is a pretty common situation that comes up when performing database operations. A stored procedure is called and the data needs to be updated if it already exists and inserted if it does not. If we refer to the Books Online documentation, it gives examples that are similar to: IF EXISTS (SELECT...
Page 1 of 1 (4 items)