|
|
-
|
|
Project Crescent is a new data visualization tool that will be part of the next version of SQL Server – code named Denali. “Crescent” is the code name given to the new reporting/visualization tools and it looks like the name may change by the time the product is released. Crescent is expected to r......
|
|
-
|
|
In the past I have published a few queries that allows you to query SQL Server Reporting Services database – to retrieve specific information about various reports deployed in the Reporting Server Instance. Recently, I got a question in my ASK forum who wanted to identify all the reports that use a ......
|
|
-
|
|
After the recent SQL Server Quiz we got several requests to start a .NET quiz that follows the similar model. We have been working hard for the last couple of months and finally the .NET Quiz is Ready. The SQL Server Quiz was our first attempt in this area and we came to know about several stuff we......
|
|
-
|
|
One of the applications we worked on recently had to deal with storing TSQL queries in a table and executing them based on some business logic. It was not a very complicated project, but the development team had a tough time with the formatting of the queries stored in the table. This was a huge pro......
|
|
-
|
|
I saw this question on the forum today and after writing an example that demonstrates this, I thought of including it as part of the XQuery Labs. Here is the sample XML we need to process.
The task is to delete all notes elements that a......
|
|
-
|
|
Code snippets allow you to quickly insert code templates into your query window to perform common TSQL tasks. By using a keyword short cut you can invoke the code snippet window and select the desired code snippet. This will copy the pre-defined code template to your query with placeholders which cl......
|
|
-
|
|
One of the most interesting error handling enhancements added in SQL Server 2005 is the support for structured exception handling using TRY / CATCH blocks. This reduced the complexity of error handling in TSQL significantly. Exception Handling using TRY/CATCH Exception handling using TRY/CATCH is......
|
|
-
|
|
In the previous post, we saw the new TSQL syntax introduced in SQL Server 2011 to support server side paging. We saw the new TSQL keywords OFFSET and FETCH NEXT in the previous post. These new keywords are introduced as an extension to the ORDER BY clause. Let us examine them in detail. OFFSET OF......
|
|
-
|
|
Server Side Paging is a common scenario most application developers must have encountered while creating front end applications that requires paging support. Instead of returning all the rows from the database and implement paging at the client side, you might want to implement the paging on the ser......
|
|
-
|
|
If you like to win an iPad, Amazon Kindle, iPod or software licenses worth over $20,000, it is time to get ready for the upcoming SQL Server Quiz 2010. Brush up your SQL Server skills and win your favorite gadgets and software tools. Even if you already have those gadgets and software tools, you mi......
|
|