XML is becoming more and more prevalent in applications and more SQL Server DBAs are learning to work with this data structure. Raj Vasant brings us part 2 of his series on using OPENXML inside SQL Server, looking at passing XML into your stored procedures this time.
2006-02-16
8,400 reads
This white paper discusses how to integrate and deploy Microsoft SQL Server Express-based applications by using configuration files and the ClickOnce deployment technology in Microsoft Visual Studio.
2006-02-16
2,574 reads
This paper discusses the challenges that face businesses that rely on data integration technologies to provide meaningful, reliable information to maintain a competitive advantage in today’s business world. It discusses how SQL Server 2005 Integration Services (SSIS) can help Information Technology departments meet data integration requirements in their companies. Real-world scenarios are included.
2006-02-15
2,649 reads
Many people have posed the question of how to generate sequential numbers for some report when the underlying data has no numbering system. The solutions have always been complicated derived or temporary tables and are difficult to implement. SQL Server 2005, however, brings us the ROW_NUMBER() function and author Michael Coles shows us how this can be used to easily add sequential numbering to your results.
2006-02-14
19,074 reads
By using Microsoft® SQL Server™ 2005 Integration Services (SSIS) to perform metrics calculations on data extracted from the Siebel Call Center database, the cross-IT (XIT) group in Microsoft Information Technology (Microsoft IT) was able to replace a former reporting application with a new scalable and flexible reporting application to improve reporting throughout the organization
2006-02-14
1,956 reads
Merge replication is probably not used as often as it could be, mainly because of the potential complexities of this tool. New author Satia Madimchetty brings us a great article that simplifies one part of this SQL Server feature, the conflict resolution issues.
2006-02-13
13,999 reads
SQL Server Integration Services (SSIS) is an enterprise-level data integration platform. SSIS is an entirely new subsystem in SQL Server 2005. This paper tells you how to take advantage of the SSIS management and deployment features.
2006-02-10
3,557 reads
Our very own Brian will be giving 2 2-day classes in 2 weeks in Jacksonille, FL. One will be on SSIS and another on SSAS.
2006-02-10
1,412 reads
There are lots of systems for developing software, but it often seems that DBAs don't adhere to any of them. New author Sudheer Palyam brings us a look at one that he has used in developing T-SQL applications, whereby the test scripts are written first.
2006-02-09
9,941 reads
This month we will begin creating reports using the SQL Server Business Intelligence Development Studio (BIDS).
2006-02-09
3,195 reads
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Comments posted to this topic are about the item The day-to-day pressures of a...
I recently used accounting assignment help, and it made a huge difference in my...
Comments posted to this topic are about the item This Week's AI Trust Problem...
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers