| Novick Software |
| Put this feed on your website |
| Description: |
The Novick Software web site brings you frequent articles
about software development using SQL Server, .Net and
related technologies. |
| Format: |
RSS 2.0 |
| Url: |
http://www.NovickSoftware.com/rss.xml |
| |
| Latest headlines |
Novick Software
|
SQL Azure Creating and Dropping Databases
Mon, 21 Jun 2010 09:28:52 -0400
This web video shows how to create and drop SQL Azure databases. It's up on the SQL Share site
|
Multi-Parameter Aggregate in SQL 2005
Mon, 21 Jun 2010 09:27:09 -0400
Multi-parameter aggregates can be achieved using a User-Defined Type. This article shows how.
|
SQL Server Performance with Solid State Disks (SSD)
Thu, 20 May 2010 10:35:21 -0400
This article summerizes my experience using Solid State Disk boards with SQL Server. The performance can be impressive for the right loads.
|
SQLCLR Table-Valued Function to list free space on the drives in your Server
Sat, 17 Apr 2010 16:07:49 -0400
This article shows how to construct a SQL CLR Table-Valued Function (TVF) that enumerates the drives on a server and reports on the available space on each drive. The article is published by MsSQLTips.
|
SQL Azure -- Relational Database in the Cloud - At Code Camp 13, Waltham Saturday March 27th at 4:20 PM
Fri, 26 Mar 2010 08:22:29 -0400
SQL Azure is Microsoft's relational database offering in the cloud. While it's similar to SQL Server 2008 there are enough differences that it's important to understand what you can and can not do with SQL Azure.
Topics:
* Signing up for SQL Azure
* Creating a database
* Differences from SQL Server 2008
* Moving schema and data up and down from the cloud
* Using the Sync Framework 2.0 to move data
|
Introduction to SQL Server Integration Services (SSIS)
Fri, 26 Mar 2010 08:17:29 -0400
This presentation and code example are an introduction to SQL Server Integration Services (SSIS) the ETL tool that is part of SQL Server 2005 and 2008. The presentation was first given at the New England Visual Basic Professionals in March 2010.
|
dba_spaceused
Tue, 5 Jun 2007 20:28:11 -0400
This article presents a stored procedure for convenient reporting of the space consumed by each table. It's uses SQL Server's sp_spaceused to compatibility but includes the schema so that like named tables can be distinguished.
|
