DotNetShoutout

jacobsebastian

Name:	jacobsebastian
Score:	4,772.5
Last Seen:	442 days, 10 hours, 24 minutes ago
Member Since:	6 April, 2010

3
Shouts

Shout it

TSQL Beginners Challenge 9 - Find the Parents and Adjacent Members of the Node - TSQL Challenges for Beginners

posted by

jacobsebastian 1106 days, 9 hours, 33 minutes ago

This challenge refers to a real-world problem I came across recently. The requirement was to identify all 'direct' or 'indirect' parents of a given child node and all its siblings. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

| flag as spam

tags: SQL Server, Puzzle, TSQL, developer, Database, challenge

8
Shouts

Shout it

Understanding SQL Server Datetime column - Part II

published 1106 days, 3 hours, 23 minutes ago posted by

jacobsebastian 1107 days, 7 hours, 35 minutes ago

SQL Server MVP, Madhivanan has come up with the second installment of his DateTime tutorial where he explains the problems of using ambiguous date formats. He also demonstrates a number of TSQL datetime processing tricks. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQL Server, DateTime, DataTypes, TSQL, Date, time

6
Shouts

Shout it

Calculating ROI on Performance Tuning - Never Say Never

published 1108 days, 2 hours, 51 minutes ago posted by

jacobsebastian 1108 days, 8 hours, 52 minutes ago

Recently on the SSC forums, someone asked about how to measure the money in an actual dollar figure that they have saved the company with their performance tuning. I've often struggled with this myself, and so I started thinking about it a bit deeper. I started to respond in the thread; then decided I was going to be a bit too long winded so I moved it here. The following are some of my thoughts/opinions on the subject. I think everyone will agree that it's probably not worth the time to optimize a ... (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: ROI, SQLServer

6
Shouts

Shout it

Display Total on top of Stacked Chart - Some Random Thoughts

published 1111 days, 17 minutes ago posted by

jacobsebastian 1111 days, 8 hours, 8 minutes ago

It is a normal phenomenon that human beings take most of the simple things for granted. Take this case, one of my blog readers sent me a mail asking how to display the total on top of a stacked chart in SSRS. The first time I read it, I was almost going to blurt - just enable some property to display subtotals. But the more I thought about it, the more elusive the property became and that is when I realized there is no such property. So for the benefit of all, I thought about posting the workaround that ... (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQLServer, SSRS

6
Shouts

Shout it

TSQL Challenge 31 - Managing multiple overlapping date intervals.

published 1111 days, 17 minutes ago posted by

jacobsebastian 1112 days, 8 hours, 28 minutes ago

This challenge is adapted from a budgeting system used in a large company to perform quarterly analysis of what kind of work will be done and where it will be done. Project Managers make plans and the estimated hours of work required from each employee each month end up in a central database. Top managers want to see a synthesis of this by department and profession. Your job is to provide this synthesis using all the other information in that database described below. In particular, we are interested in... (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: tsql challenges, TSQL, puzzles, SQLServer

10
Shouts

Shout it

SQL SERVER – Stored Procedure and Transactions « Journey to SQL Authority with Pinal Dave

published 1110 days, 2 hours, 49 minutes ago posted by

pinaldave 1112 days, 13 hours, 13 minutes ago

Learn the truth behind following statement - “I do not use Transactions in SQL as I use Stored Procedure“. (more)

category: Data | clicked: 0 | comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

4
Shouts

Shout it

SELECT * FROM XML - Jacob's Blog

published 1112 days, 5 hours, 9 minutes ago posted by

jacobsebastian 1113 days, 19 minutes ago

This post shows how to run a SELECT * kind of query on an XML document to see the elements, attributes, values and the XPath Expression of each element and attribute in the document. (more)

category: Data | clicked: 2 | comment | | source: beyondrelational.com

tags: xquery, XML, SQLServer

6
Shouts

Shout it

Auto-update of parameter datasets in SSRS 2008 - Some Random Thoughts

published 1113 days, 4 hours, 31 minutes ago posted by

jacobsebastian 1114 days, 4 hours, 28 minutes ago

The times I have spent with SSRS 2008 can be likened to that of a married couple’s life story. The moment I first laid my eyes on her during the Microsoft seminars and community previews, I knew that she was going to be the one. I secretly started collecting details about her, as much as possible and awaited her arrival. Needless to say, I was one of the very first to have the trial version installed and in the dates that followed, I was just astounded at her potential – she seemed so full and promising.... (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

3
Shouts

Shout it

Delimited String Tennis (Again)… The Final Volley? - SQL Server Community Blogs

published 1114 days, 3 hours, 51 minutes ago posted by

jacobsebastian 1115 days, 8 hours, 3 minutes ago

This is a continuation of my previous blog post, Delimited String Tennis Anyone?, which playfully talked about a virtual T-SQL Tennis match… a friendly rally back and forth between SQL Server MVP Adam Haines and myself in discussing methods of shredding comma-delimited strings in our blogs. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: XML, SQLServer

2
Shouts

Shout it

Explanation of my winning solution to TSQL Challenge 19 - Dave Ballantyne's Blog

published 1116 days, 4 hours ago posted by

jacobsebastian 1117 days, 2 hours, 41 minutes ago

I have received a number of requests for an explanation of my winning query of TSQL Challenge 19. This involved traversing a hierarchy of employees and rolling a count of orders from subordinates up to superiors. The first concept I shall address is the hierarchyId , which is constructed within the CTE called cteTree. cteTree is a recursive cte that will expand the parent-child hierarchy of the personnel in the table @emp. One useful feature with a recursive cte is that data can be ‘passed’ from the... (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: tsql challenges, challenges, TSQL, puzzles, SQLServer

3
Shouts

Shout it

Understanding Datetime column - Part I - Madhivanan's TSQL Blog

published 1116 days, 4 hours ago posted by

jacobsebastian 1117 days, 7 hours, 38 minutes ago

There are N number of questions asked in the forums about handling dates in query Most of the people who ask questions dont understand how datetime column works in SQL Server Some of the questions frequently asked are about 1 using dates in the WHERE caluse 2 formatting dates using SQL 3 inserting dates to the table with specific date format etc In this series of blog posts, I would explain them with examples These example are for versions prior to 2008 (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

3
Shouts

Shout it

Create Indexes from the Missing Indexes DMV - Never Say Never

published 1117 days, 3 hours, 26 minutes ago posted by

jacobsebastian 1118 days, 5 hours, 9 minutes ago

Glenn Berry (Blog) writes a lot of queries to extract information from the system DMV’s. One of them in particular I found extremely helpful in fixing some of the issues in my system. I took his query (the CTE at the top) and added some text manipulation to actually generate the create statements for you to save you some time. I had much grander plans for this, but unfortunately I’ve been meaning to post this for over a month now and simply haven’t had time to get back to it, so rather than just let i... (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

6
Shouts

Shout it

Static Named Sets v/s Dynamic Named Sets - Some Random Thoughts

published 1117 days, 3 hours, 26 minutes ago posted by

jacobsebastian 1118 days, 6 hours, 43 minutes ago

Many times, it can happen that we end up writing very complex MDX expressions revolving sets. To simplify such expressions or to improve the performance of some queries, we can extract the definitions of some sets into a separate named set expression which are called named sets. A named set can be created either using a CREATE SET statement or a WITH SET statement (For syntax, refer Building Named Sets in MDX). In SQL Server 2005, there was only the Static named sets feature but in SQL Server 2008, both ... (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SSAS, MDX

6
Shouts

Shout it

TSQL Beginners Challenge 8 - Identify the release dates of movies on different cities - TSQL Challenges for Beginners

published 1118 days, 2 hours, 48 minutes ago posted by

jacobsebastian 1119 days, 1 hour, 1 minute ago

Let us one again play with a date related problem. The challenge is to identify the various movies released in cities. There are two tables involved in this challenge. The first table is MovieReleaseDates which will contain the names of movies along with their release dates. The second table will hold the details of releases that happened in different cities. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

4
Shouts

Shout it

SQL Server XML - Un-Making a List (or Shredding of Evidence) - SQL Server Community Blogs

posted by

jacobsebastian 1119 days, 11 hours, 3 minutes ago

In my previous blog entry, I described in detail how you could use the FOR XML clause to create a column with a comma-separated list of entries acquired from rows in a table somewhere. In this article, we will do the opposite… We will take a comma-separated list and “shred” the individual items into rows. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

| flag as spam

3
Shouts

Shout it

Simplifying updates on multiple database servers using Red Gate SQL Multi Script - beyondrelational.com

published 1116 days, 4 hours ago posted by

jacobsebastian 1120 days, 2 hours, 23 minutes ago

This post explains how to speed up script updates on multiple database servers using a third party tool. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

4
Shouts

Shout it

Tips and Tricks to prevent SQL Injection in .Net Code - Deepak Palkar's Blog

posted by

jacobsebastian 1120 days, 9 hours, 24 minutes ago

SQL Injection is an attack in which malicious code is inserted into strings that are later passed to an instance of SQL Server for parsing and execution. This can allow an attacker to steal the data as well as modify and delete it. Conventional security measures like use of SSL and IPSec, do not protect the application from SQL injection attacks. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

| flag as spam

3
Shouts

Shout it

Quick overview of Data Compression SQL server 2008 new feature - Abhijit More's Blog

posted by

jacobsebastian 1122 days, 4 hours, 49 minutes ago

Data Compression is a new feature in Microsoft SQL Server 2008 Enterprise and Developer editions, which helps to reduce the database size as well the improves the IO performance. However, implementing data compression requires additional CPU resources. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

| flag as spam

3
Shouts

Shout it

Whitepaper: Master Data Management from a Technical Perspective - SQL Server White Papers

posted by

jacobsebastian 1122 days, 4 hours, 50 minutes ago

This article provides a technology-centric view of master data management concepts, including possible implementation techniques. After reading this paper, information technology professionals should be able to accurately define the master data management problem for their organizations and have a vision for what the solution may be. They should be able to engage the business and recognize the proper role that IT must play in this process long term. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

| flag as spam

4
Shouts

Shout it

Delimited String Tennis Anyone? - SQL Server Community Blogs

published 1123 days, 3 hours, 31 minutes ago posted by

jacobsebastian 1123 days, 20 hours, 12 minutes ago

SQL Server MVP Adam Haines and I have been going back and forth for months in our blogs on the subject of creating and splitting a delimited string… it’s been kind of a virtual T-SQL Tennis match… not a competition, but rather a friendly rally, knocking the subject back and forth, practicing our skills. Between the two of us, we’ve just about beaten the subject to death; however, I like to think that our collective research has been a win-win situation for the SQL Server community. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

Welcome!

jacobsebastian

TSQL Beginners Challenge 9 - Find the Parents and Adjacent Members of the Node - TSQL Challenges for Beginners

Understanding SQL Server Datetime column - Part II

Calculating ROI on Performance Tuning - Never Say Never

Display Total on top of Stacked Chart - Some Random Thoughts

TSQL Challenge 31 - Managing multiple overlapping date intervals.

SQL SERVER – Stored Procedure and Transactions « Journey to SQL Authority with Pinal Dave

SELECT * FROM XML - Jacob's Blog

Auto-update of parameter datasets in SSRS 2008 - Some Random Thoughts

Delimited String Tennis (Again)… The Final Volley? - SQL Server Community Blogs

Explanation of my winning solution to TSQL Challenge 19 - Dave Ballantyne's Blog

Understanding Datetime column - Part I - Madhivanan's TSQL Blog

Create Indexes from the Missing Indexes DMV - Never Say Never

Static Named Sets v/s Dynamic Named Sets - Some Random Thoughts

TSQL Beginners Challenge 8 - Identify the release dates of movies on different cities - TSQL Challenges for Beginners

SQL Server XML - Un-Making a List (or Shredding of Evidence) - SQL Server Community Blogs

Simplifying updates on multiple database servers using Red Gate SQL Multi Script - beyondrelational.com

Tips and Tricks to prevent SQL Injection in .Net Code - Deepak Palkar's Blog

Quick overview of Data Compression SQL server 2008 new feature - Abhijit More's Blog

Whitepaper: Master Data Management from a Technical Perspective - SQL Server White Papers

Delimited String Tennis Anyone? - SQL Server Community Blogs

Open ID Login

Standard Login

Forgot Password?

Sign up