Default trace - A Beginner's Guide
This article is the beginner's guide to Default Trace. The article outlines how to query the default trace for key trace events, with a focus on DDL history.
2010-06-11 (first published: 2008-11-11)
53,622 reads
Articles
How to Conduct Effective Data Warehouse and Business Intelligence Software Evaluations
Denise Rogers discusses the essential tasks in conducting effective software evaluations revolving around data warehousing and business intellegence. Each step has a dependency on the previous one, starting with establishing the framework of the evaluation and adding progressively elaborate data that facilitates a decision making process that is resolute.
2010-06-11
4,369 reads
Make a 100+ Server Inventory in 30 minutes
Learn how you can generate a server inventory in 30 minutes for all of your servers with this new article from Stanley Chan.
2010-06-10
11,343 reads
Who Wants to Lead the Community?
Steve Jones talks about the PASS Board of Directors election coming up this fall and hopes some of you will apply.
2010-06-10
61 reads
Exploring Derived Column Transformation in SQL Server Integration Services
Marcin Policht examines SQL Server Integration Services' component, Derived Column Transformation,and how its usefulness is enhanced by its ability to implement fairly elaborate mathematical, logical, and string operations.
2010-06-10
2,976 reads
2010-06-09
8,419 reads
Speeding Up Incremental ETL Processes in SSIS by Using MD5 Hashes
Speeding up incremental ETL processes in SSIS by tracking changes to records in an MD5 Hash
2010-06-08
20,122 reads
SQL Server and the XML Data Type : Data Manipulation
The introduction of the xml data type, with its own set of methods for processing xml data, made it possible for SQL Server developers to create columns and variables of the type xml. Deanna Dicken examines the modify() method, which provides for data manipulation of the XML data stored in the xml data type via XML DML statements.
2010-06-08
3,264 reads
Partitions in Analysis Services
A look at partitioning in Analysis Services from Shahfaisal Muhammed. Learn how it works, what it can do, and how to implement partitions for your cubes.
2010-06-07
11,459 reads
Import and Export Registered SQL Servers To Other Machines
I need to setup other computers the same way that are used to manage my SQL Servers. Instead of having to manually add the registered servers on each computer in this tip I show you how you can import and export registered servers between computers.
2010-06-07
3,141 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
SQL Server 2025 Backup Compression Algorithm
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers