This SSIS package performs multiple XSL transformations on an XML document, then shreds the transformed document and inserts its data into a SQL Server table.
2012-03-21
3,890 reads
SQL Saturday is hitting Dublin for the first time on March 24th.
2012-03-20 (first published: 2011-12-23)
5,623 reads
This article describes my experience in upgrading a four node cluster with three active instances to SQL 2008
2012-03-20
2,414 reads
SQL Server includes a subset of four ranking functions that can be used to rank the rows of your result set over a partition. This article presents those functions and examples of their use.
2012-03-20
3,874 reads
When rounded detail quantities are created by an allocation, often the total must foot back exactly to the allocated amount.
2012-03-19
5,906 reads
The database field contains long string with data for Quantity and Parts. The challenge is to parse the data into separate (Quantity and Parts) fields for displaying in a report.
2012-03-19
2,605 reads
The first SQL Saturday event in Turkey, on Mar 31, 2012 at the Microsoft office in Istanbul. Sign up and come for a free day of SQL Server training.
2012-03-19
1,391 reads
What do you do when you need to remove an orphaned user, but they are the owner of a Schema or Role on that database?
2012-03-16
3,321 reads
This article describes how to add a log shipping monitor to a log shipping configuration that is already in place.
2012-03-15
7,130 reads
This is the first in a four-part series on the new AlwaysOn feature in SQL Server 2012. In this article, AlwaysOn is introduced and contrasted with previous high-availability solutions in SQL Server. The second part of the series will commence with a detailed walkthrough on preparing the environment for AlwaysOn
2012-03-15
3,949 reads
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Comments posted to this topic are about the item What's new in R 4.6
Comments posted to this topic are about the item Interesting Changes in R, which...
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers