jacobsebastian

jacobsebastian
Name: jacobsebastian
Score: 4,772.5
Last Seen: 412 days, 10 hours, 46 minutes ago
Member Since: 6 April, 2010
DotNetShoutout
atom rss
7
Shouts
spam Shout it Mute it

FOR XML Workshop – Understanding FOR XML EXPLICIT - Jacob's Blog
posted by ashishgilhotraashishgilhotra 1109 days, 6 hours, 1 minute ago
Friday, May 07, 2010 8:54:04 AM GMT
EXPLICIT is the most powerful directive that you can use with FOR XML, which gives you total control over the shape of XML being generated. Using EXPLICIT mode, you can generate XML documents with almost any structure and shape. However, the syntax of FOR XML EXPLICIT is quite complex and that makes many people hate this handsome young guy! (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
6
Shouts
spam Shout it Mute it

DFT 2 DFT - Sudeep's Domain
published 1109 days, 20 hours, 38 minutes ago posted by http://rajsudeep.blogspot.com/http://rajsudeep.blogspot.com/ 1110 days, 8 hours, 23 minutes ago
Thursday, May 06, 2010 6:17:09 PM GMT Thursday, May 06, 2010 6:31:54 AM GMT
This article talks about the ways in which we can transfer data between 2 Data flow tasks in SSIS. beyondrelational.comSign in | Join | Help HomeBlogsForumsBIXMLTC The XML Resource Center has got a new RSS Feed. Click here to subscribe! First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login. Sudeep's DomainHomeContactRSS for Posts SSIS scenarios...Recent Blog... (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: RAW FILE, MSBI, DFT, OLEDB destination, SSIS, flat file source
3
Shouts
spam Shout it Mute it

SQL 2008 R2 MDS Easter Egg - Bob's blog
posted by jacobsebastianjacobsebastian 1110 days, 1 hour, 30 minutes ago
Thursday, May 06, 2010 1:25:02 PM GMT
I've been having a play with SQL 2008 R2 and it's new Master Data Services (MDS). I was pleased to see it adds some additional functions when you create a new MDS database. These include mdq.Split and mdq.RegexReplace which implement handy Regular Expression functions. Most of these are documented at: http://msdn.microsoft.com/en-us/library/ee633712(SQL.105).aspx (more)
category: Data | clicked: 3 | comment | | source: beyondrelational.com
6
Shouts
spam Shout it Mute it

Getting Started with LINQ – Part 2 (Language Enhancements) - Deepak Palkar's Blog
published 1109 days, 20 hours, 38 minutes ago posted by jacobsebastianjacobsebastian 1110 days, 1 hour, 30 minutes ago
Thursday, May 06, 2010 6:17:09 PM GMT Thursday, May 06, 2010 1:24:29 PM GMT
In my previous post I summarized Microsoft Language Integrated Query (LINQ). Briefly discussed about its components as well as showed some code examples to highlight the sql query type syntax it uses. Please don’t get confused about the title of this post. We sure are going to talk about language enhancements but they are the features of C# 3.0, and not the features of LINQ. But they are the building blocks of the LINQ. In this post I will discuss these features a little further as follows. (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
3
Shouts
spam Shout it Mute it

TSQL Challenge 29 - Reorganize sales data by sales amount - TSQL Challenges
published 1109 days, 20 hours, 38 minutes ago posted by jacobsebastianjacobsebastian 1110 days, 1 hour, 31 minutes ago
Thursday, May 06, 2010 6:17:09 PM GMT Thursday, May 06, 2010 1:23:58 PM GMT
This challenge presents a tough task of reorganizing the data in a sales table. The table is not normalized correctly and the sales detail data of three items are stored in each row. Your job is to reorganize the items in the table by sales amount (quantity * price). Reorganize the items from left to right, bottom to top. The item with the highest sales amount should come on top left of each invoice. (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
5
Shouts
spam Shout it Mute it

Getting Started with LINQ - Deepak Palkar's Blog
published 1109 days, 20 hours, 38 minutes ago posted by jacobsebastianjacobsebastian 1110 days, 1 hour, 32 minutes ago
Thursday, May 06, 2010 6:17:09 PM GMT Thursday, May 06, 2010 1:23:16 PM GMT
In this we’ll continue to discuss how to go about the SQL Server Data Access using various technologies. This post will discuss Microsoft Language Integrated Query, otherwise known as LINQ. I will discuss how it can be used to accomplish the same tasks we have discussed in previous posts. But before that it surely requires a good introduction to start with. (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
3
Shouts
spam Shout it Mute it

Better way of repeating charts based on parameters
published 1109 days, 20 hours, 38 minutes ago posted by jacobsebastianjacobsebastian 1110 days, 1 hour, 32 minutes ago
Thursday, May 06, 2010 6:17:09 PM GMT Thursday, May 06, 2010 1:22:44 PM GMT
Ok, so this is not your everyday run-of-the-mill post which talks about how to repeat the same chart for each value selected in the report parameters. I know you have been listening to countless posts instructing how you can do the same with Lists in SSRS (in case you haven't, this would be a nice place to start). But the subtle issue with just using a list is that they grow only downwards. Now this would mean that in the case of small charts, we would not be using the page efficiently as there would be ... (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
4
Shouts
spam Shout it Mute it

Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques - SQL Server White Papers
published 1109 days, 20 hours, 38 minutes ago posted by jacobsebastianjacobsebastian 1110 days, 1 hour, 33 minutes ago
Thursday, May 06, 2010 6:17:09 PM GMT Thursday, May 06, 2010 1:22:05 PM GMT
This best practices white paper discusses three many-to-many query performance optimization techniques, including how to implement them, and the performance testing results for each technique. (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
5
Shouts
spam Shout it Mute it

Setting default member in role playing dimensions - Some Random Thoughts
published 1109 days, 20 hours, 38 minutes ago posted by jacobsebastianjacobsebastian 1110 days, 1 hour, 33 minutes ago
Thursday, May 06, 2010 6:17:09 PM GMT Thursday, May 06, 2010 1:21:23 PM GMT
Today I got a call from one of my colleagues asking how to set a default member for a dimension attribute . I was a little surprised as I thought setting a default member is quite straight forward and was even more surprised to learn that the dimension had processed successfully but the cube had failed with errors. (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
5
Shouts
spam Shout it Mute it

Downgrading SQL Server Enterprise Edition to Standard Edition
published 1109 days, 20 hours, 38 minutes ago posted by jacobsebastianjacobsebastian 1110 days, 1 hour, 34 minutes ago
Thursday, May 06, 2010 6:17:09 PM GMT Thursday, May 06, 2010 1:20:48 PM GMT
In this article, we shall look at something that may not be done as frequently as you would want to. It is Downgrading a SQL Server 2005 from an Enterprise Edition to Standard Edition. First you need to know why such an exercise is carried out any way. The reason would be, due to oversight, an Enterprise Edition was installed which in the first place must have been a Standard Edition, or the decision makers decide to go with Standard Edition of SQL Server due to the cost difference in the both the Editi... (more)
category: Data | clicked: 1 | comment | | source: beyondrelational.com
5
Shouts
spam Shout it Mute it

Getting Started with SQL Server Data Access using Data Access Application Block - Deepak Palkar's Blog
published 1109 days, 20 hours, 38 minutes ago posted by jacobsebastianjacobsebastian 1110 days, 1 hour, 35 minutes ago
Thursday, May 06, 2010 6:17:09 PM GMT Thursday, May 06, 2010 1:19:50 PM GMT
In my previous post, Getting Started with SQL Server Data Access using ADO.Net, we saw how we can use the ADO.Net objects to retrieve / update the data from and to the SQL Server. In this post, we’ll see how the same tasks that we did using ADO.Net objects can be done using Data Access Application Block. We will also see how it makes the code much more tidier. Data Access Application Block is part of Microsoft Enterprise Library. (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
7
Shouts
spam Shout it Mute it

SQL Server – Issues with generating XML using string operations
published 1117 days, 3 hours, 46 minutes ago posted by ashishgilhotraashishgilhotra 1118 days, 2 hours, 49 minutes ago
Thursday, April 29, 2010 11:08:29 AM GMT Wednesday, April 28, 2010 12:05:36 PM GMT
Building XML documents using string functions – concatenating XML tags and embedding values between them using string operations – is not a recommended method. This post tries to look into some of the problems this approach can bring in.. (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
3
Shouts
spam Shout it Mute it

Amazing Strategy!! - Deepak Palkar's Blog
published 1109 days, 20 hours, 38 minutes ago posted by jacobsebastianjacobsebastian 1110 days, 1 hour, 37 minutes ago
Thursday, May 06, 2010 6:17:09 PM GMT Thursday, May 06, 2010 1:18:10 PM GMT
recently downloaded a cool fighter plane game (iFighter lite) on my iPhone. As I started playing, I felt that plane is moving a bit slow!! But soon enough I saw a little perk on the screen and I flew over it and suddenly plane's speed increased. Soon enough, enemy planes started attacking me and I shot back at them. But again I felt my bullets were too slow! I shot down few planes and a new perk showed up on the screen. As soon as I collected it, my plane started shooting more bullets per attack!! Yeeee... (more)
category: Agile | clicked: 0 | comment | | source: beyondrelational.com
5
Shouts
spam Shout it Mute it

SQL Server 2008 R2 Express Database Size Limit Increased to 10GB! Download Now!!
published 1109 days, 20 hours, 38 minutes ago posted by jacobsebastianjacobsebastian 1110 days, 1 hour, 38 minutes ago
Thursday, May 06, 2010 6:17:09 PM GMT Thursday, May 06, 2010 1:17:01 PM GMT
So what is so exciting about the SQL Server 2008 R2 Release? Well, along with plenty of BI features and enhancements, there is a tiny cute feature that I am sure all of us will appreciate a lot. The product team has increased the Database Size limit for SQL Server 2008 R2 Express from 4 GB to 10 GB. So if you have got a growing SQL Server Express database that is close to the 4 GB Limit, hurry, upgrade to R2 Express. (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
4
Shouts
spam Shout it Mute it

Post Upgrade Experience: SQL 2000 to 2008 - Never Say Never
published 1109 days, 20 hours, 38 minutes ago posted by jacobsebastianjacobsebastian 1110 days, 1 hour, 39 minutes ago
Thursday, May 06, 2010 6:17:09 PM GMT Thursday, May 06, 2010 1:16:10 PM GMT
Whew! So I've been super busy the past week and a half upgrading our production server from SQL 2000 to SQL 2008 and haven't had time for any new posts. Finally starting to see everything calm down again though and running smoother than ever before. I had hoped to do a comparison of 2000 and 2008 disk activity pre and post compression, but due to the number of "emergencies" in the week prior to the changeover and the number of times our plans changed with reconfiguring raid arrays etc. I never had an ... (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
7
Shouts
spam Shout it Mute it

Getting Started with SQL Server Data Access
published 1108 days, 7 hours, 16 minutes ago posted by jacobsebastianjacobsebastian 1110 days, 1 hour, 39 minutes ago
Saturday, May 08, 2010 7:38:35 AM GMT Thursday, May 06, 2010 1:15:24 PM GMT
I am going to write a series of articles to discuss about how to work with SQL Server Database using different technologies available out there, like ADO.Net., Microsoft Data Access Application Blocks and LINQ. Here’s the first one in that order which will simply discuss and show how to use ADO.Net objects to do the basic tasks to work with SQL Server. (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
3
Shouts
spam Shout it Mute it

TSQL Beginners Challenge 6 - Count the number of mobile phones and generate a summary - TSQL Challenges for Beginners
posted by jacobsebastianjacobsebastian 1110 days, 1 hour, 40 minutes ago
Thursday, May 06, 2010 1:14:36 PM GMT
This challenge aims to test your string parsing and summarizing skills using TSQL. The challenge is to count the number of mobile phones each person has and generate a summary row. (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
5
Shouts
spam Shout it Mute it

Loading data from text files to SQL Server Tables – CSV Files, Tab Separated Files or Fixed Column Length Files
published 1109 days, 20 hours, 38 minutes ago posted by jacobsebastianjacobsebastian 1110 days, 1 hour, 51 minutes ago
Thursday, May 06, 2010 6:17:09 PM GMT Thursday, May 06, 2010 1:04:16 PM GMT
In the previous post we looked in How to Execute SQL Query or Store Procedure from SSIS and successfully created a package which execute SQL Query or Procedure on targeted SQL Server with the help of this. In this post we look in How to Load Data from text Files to SQL Server, in daily life several time we need to load data in SQL Server tables, we can achieve this with the help of SSIS. We look into the detailed process of loading data from text files to SQL Server tables. (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
4
Shouts
spam Shout it Mute it

Improving cell security performance in SSAS - Some Random Thoughts
posted by jacobsebastianjacobsebastian 1110 days, 1 hour, 51 minutes ago
Thursday, May 06, 2010 1:03:37 PM GMT
Now this one was in the coming for quite some time. All of us who have tried to implement cell security would have had some or the other woes to relate with performance. At least for me, the MDX query which I had beautifully tuned to come out in 2 sec suddenly became an embarrassment in the form of a hideously slow 2 min query the moment I switched over to a security based role. And this blog is a direct result of my quest to understand how SSAS works beneath my mean machine (yeah, my laptop is damn cool!). (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
3
Shouts
spam Shout it Mute it

Extracting numbers - Part 2 - Madhivanan's TSQL Blog
posted by jacobsebastianjacobsebastian 1110 days, 1 hour, 52 minutes ago
Thursday, May 06, 2010 1:02:57 PM GMT
In this post Extract only numbers from a String, I described a method of extrating numbers from a string using split and concatenate technique In this post Regular expression, I described a method to extract whole numbers if a specific digit is found Consider that you have a situation where you need to extract only amounts from a text Here is a way to do it Consider this example (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
| flag as spam
Previous 1 2 ... 47 48 49 50 51 52 53 54 55 56 Next