Additional Articles

Scripts to use XML to insert and update rows in a SQL Server table

by Additional Articles

MSSQLTips.com

The following production code is what I used for inserting and updating database tables using XML as the input. These scripts are for processing data for any table to insert or update data. The support functions provided, retrieve the table schema with their data types, functions to deal with XML dates, primary keys of the table and what fields can be updated. The following article breaks down this process from beginning to end.

2010-10-06

4,867 reads

Auditing with Microsoft Assessment and Planning (MAP) Toolkit 5.0 - Part 1

by Additional Articles

SQL Server Performance

Auditing

The first in this three part series on using Microsoft Assessment and Planning (MAP) Toolkit 5.0 introduces the toolkit and gets started with install and using it.

2010-10-05

1,671 reads

Standardize data storage for geography spatial data type in SQL Server

by Additional Articles

MSSQLTips.com

Spatial Data

Geography is one of the spatial data types introduced in SQL Server 2008. One of the characteristic of the geography data type is that it can accommodate any supported geometry based on any supported spatial reference system in the same field. So if the data that is stored in a column of geography data type is not standardized, it can be a very tedious and resource intensive task to figure out the geometry and spatial reference system associated with each value. To deal with this issue, we need to standardize the data stored in a field of that has the geography data type and in this tip we will look at how to deal with this issue.

2010-10-04

2,316 reads

PowerShell Version 2: What is new and why is it important?

by Additional Articles

SimpleTalk

PowerShell

It was a year ago that Microsoft shipped PowerShell 2. Jonathan Medd lists the top ten reasons why PowerShell 2 should be an important tool for your work

2010-10-01

4,489 reads

SSIS Events and Handlers

by Additional Articles

Database Journal

Integration Services (SSIS)

Explore how SQL Server 2008 Integration Services' events are triggered during package execution and the ability to react to their outcome through event handlers.

2010-09-30

2,337 reads

Partition offset and allocation unit size of a disk for SQL Server

by Additional Articles

MSSQLTips.com

Administration

SQL Server performance is dependent on the server resources available and disk performance is probably the most important resource. To maximize disk performance for SQL Server, I've always been told that the drive's partition offset must be set to 32K and the allocation unit size set to 64K for partitions that hold data and 8K for partitions that hold logs. How do I find out the allocation unit size and partition offset for my drives?

2010-09-29

3,355 reads

Creating User-Defined Functions in Microsoft SQL Server

by Additional Articles

Database Journal

SQL Server's own list of functions is limited as far as what is available for database developers to use in their applications. Starting with SQL Server 2000, database developers were given the ability to create their own routines that accept parameters, perform custom actions and return results.

2010-09-28

4,570 reads

Migrating Your SQL Server Database Applications to SQL Azure

by Additional Articles

Database Journal

Azure

Most business applications you write probably utilize some kind of relational database. And, as a .NET developer, the chances are that database is Microsoft SQL Server. This article walks you through migrating your SQL Server database applications to the cloud with SQL Azure.

2010-09-27

3,374 reads

Mission Critical: SQL Server Upgrade

by Additional Articles

SimpleTalk

upgrading

You're faced with the task of doing a SQL Server Upgrade? Do you know all the steps, and the right order to do them? You do? Even with interruptions and distractions? Maybe, but it is wise to be able to refer to the Mission-Critical Task checklist.

2010-09-24

4,416 reads

Setting up your own free Virtualized test environment

by Additional Articles

SimpleTalk

Virtualization, containers, and k8s

If you need to test new software, configurations, patches or operating systems, a virtual machine saves time, risk and hardware. You can set up a virtual test environment for free with some products such as VMware Server 2. All you need is a simple set of instructions about how to set it up; and here it is, thanks to Sean Duffy.

2010-09-24

3,860 reads

All authors

Additional Articles

Scripts to use XML to insert and update rows in a SQL Server table

Auditing with Microsoft Assessment and Planning (MAP) Toolkit 5.0 - Part 1

Standardize data storage for geography spatial data type in SQL Server

PowerShell Version 2: What is new and why is it important?

SSIS Events and Handlers

Partition offset and allocation unit size of a disk for SQL Server

Creating User-Defined Functions in Microsoft SQL Server

Migrating Your SQL Server Database Applications to SQL Azure

Mission Critical: SQL Server Upgrade

Setting up your own free Virtualized test environment

Blogs

Monday Monitor Tips: Virtual Machine Usage and Cost

Advice I Like: Respect

Blue Sky Programming – The Optimism Trap

Forums

SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About

SQL Server Still Wins

DBCC CHECKDB Limits I

Question of the Day

DBCC CHECKDB Limits I