When information is exchanged in XML format, there needs to be an agreement between the sender and receiver about the structure and content of the XML document. An XSD (XML Schema Definition Language) Schema can be used to enforce this contract and validate the XML data being exchanged. Jacob Sebastian's book explains all.
2013-03-15
5,478 reads
FILESTREAM is implemented as an extension to the VARBINARY(MAX) data type and allows large object data to be stored in a special folder on the NTFS file system, while bringing that data under the transactional control of SQL Server. This book describes both the way it works and the implementation, administration and troubleshooting of it.
2012-11-12
636 reads
FILESTREAM is implemented as an extension to the VARBINARY(MAX) data type and allows large object data to be stored in a special folder on the NTFS file system, while bringing that data under the transactional control of SQL Server. This book describes both the way it works and the implementation, administration and troubleshooting of it.
2012-11-12
630 reads
The challenge is to compare the data of the rows and group the input data. The data needs to be grouped based on the Product ID, Date, TotalLines, LinesOutOfService.
2012-10-08
1,887 reads
The challenge is to find the Tax Code based on Price. Each sales amount is uniquely made up by the sum of one or more prices. Based on this you should assign the tax code to each price.
2012-09-17
1,429 reads
This challenge is to generate a game scheduler based on the Teams given in a table.
2012-07-04
1,545 reads
The challenge is to find the minimal set of intervals without creating gaps.
2012-04-16
1,586 reads
The challenge is to find the Islands(gaps) in sequential dates. You need to write a query to identify continuous intervals from the start date and end date.
2012-04-02
915 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,641 reads
The challenge is to transform monthly resource efforts into weekly actuals.
2012-03-05
757 reads
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
Wa:083849450961 Jl. RC. Veteran. 9, dan No.9A, RT.9/RW.3, Bintaro, Kec. Pesanggrahan, Kota Jakarta Selatan,...
Wa:083849450961 Jl. Mangga Raya No.20, RT.4/RW.3, Duri Kepa, Kec. Kb. Jeruk, Kota Jakarta Barat,...
Comments posted to this topic are about the item Training the next generation
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers