Auditing with Microsoft Assessment and Planning (MAP) Toolkit 5.0 - Part 3
Part 3 of the series on using MAP 5.0 looks at Software Usage Tracker audit mecanism, as well as migrating and uninstalling the MAP database.
2010-10-12
1,605 reads
Additional Articles
Working with the INSERT statement in SQL Server
The INSERT statement in SQL Server is versatile. It now allows the insertion of multiple rows of literal values. It also provides the output clause that solves a number of common problems such as ascertaining the value of identity fields, and other calculated fields in tables, or for auditing the rows that are added to tables. Robert, once again, gives a clear introduction.
2010-10-11
5,220 reads
Event Notifications in SQL Server for Tracking Changes
As a DBA, we often need a way to track what events are occurring (changes that are being made) on SQL Server or at the database level. So what is a way to track these changes without much impact on SQL Server performance?
2010-10-08
5,125 reads
Auditing with Microsoft Assessment and Planning (MAP) Toolkit 5.0 - Part 2
Part 2 of the series on using MAP 5.0 looks at using the toolkit to inventory servers, preparing audit reports and server virtualization planning.
2010-10-07
2,031 reads
Scripts to use XML to insert and update rows in a SQL Server table
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
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
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?
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
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
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
Blogs
Enterprise AI Operating Rhythm – Top 5 practices for 2026
2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened...
Stop Being Surprised by Your Azure Bill: Use Budgets
By John
When organizations migrate workloads to Azure, the focus is usually on architecture, performance, and...
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
Forums
The Max PK Length
Comments posted to this topic are about the item The Max PK Length
My experience using the GitHub Copilot in SSMS 22
Comments posted to this topic are about the item My experience using the GitHub...
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
Question of the Day
The Max PK Length
If I create a multiple column Primary Key constraint, what is the most number of bytes I can include in the constraint?
See possible answers