By tag: beyondrelational
0
kicks
SQL Server 2008 R2 Released – Download it or try the Hosted Version
SQL Server 2008 R2 is officially released. See this post for a number of resources to help you to get started with SQL Server 2008 R2.
0
kicks
Explanation of my winninig solution to TSQL Challenge 17
Naomi explains her winning solution to TSQL Challenge 17
0
kicks
Adding breadcrumbs to your drillthrough reports (SSRS)
This post shows a trick that helps you to build breadcrumbs in SSRS drill through reports.
0
kicks
FOR XML Workshop – Understanding FOR XML RAW
This post explains how to generate XML documents using FOR XML RAW from TSQL (SQL Server)
0
kicks
Download Free ebook - Introducing Microsoft SQL Server 2008 R2
Introducing Microsoft SQL Server 2008 R2 is a 10 chapter, 216 page book writtenby Ross Mistry and Stacia Misner. Microsoft has made it available as a free ebook
0
kicks
Tips and tricks to create a Dashboards in SSRS 2008
SSRS 2008 version has changed so much for the better when you compare to the 2005 version, be it on terms of aesthetics or developer friendliness. This post shows a trick that demonstrates how to create a heatmap control on a report.
0
kicks
How to know the SQL Server Version ?
In order to know the SQL Server and Edition details you would be possibly looking at the SQL Server properties and find out the details. Occasionally it might be needed to check the same as part of a job / or a script, you need to query the SQL Server for this info. In order to do this you can use @...
0
kicks
SQL Server - Filtered Indexes
Having discussed about indexes into some level, now it is time to discuss new index type which came along with SQL Server 2008, filtered index. In filtered index, you can define index to the filter portion of your data.
0
kicks
Referencing an assembly inside SSIS script task
This post explains how to use a custom assembly inside SSIS script task.
0
kicks
TSQL Challenge 27 - Identify overlapping weekly schedules of Nurses
This challenge is related to a scheduling problem in the home health care industry. The task is to look into the schedules of nurses and identify any overlapping schedules.
0
kicks
SQL Server - Using SET NOCOUNT ON
This post explains the advantages of using SET NOCOUNT ON in stored procedures. A must read for SQL Server developers and DBAs
0
kicks
SSIS - Delete files in a folder older than a specified number of days
This post explains how to delete files created a number of days before current date using SSIS.
0
kicks
XQuery Lab 55 – Extracting values from XML elements that matches a str
Here is another XQuery exercise that uses the contains() function to match a string pattern against an XML element and retrieves values from a sibling element.
0
kicks
How to send HTML format Mail through SSIS
SSIS provide send mail task but its not very flexible. The body is in plain text. What if you want to send a formatted tabular data in the mail body? Check this out.
0
kicks
BRBR Post Review : Ashish Gilhotra on getting started with SSIS
This article is a beginner level tutorial where the author explains how to fetch data from SQL Server using a sql query or a stored procedure. Article is detailed enough for any beginner to follow all the steps and successfully create a working package by following the instructions provided througho...