jacobsebastian

jacobsebastian
Name: jacobsebastian
Score: 4,772.5
Last Seen: 418 days, 20 minutes ago
Member Since: 6 April, 2010
DotNetShoutout
atom rss
6
Shouts
spam Shout it Mute it

Define IOPs for all database servers
published 630 days, 18 hours, 8 minutes ago posted by dharadhara 631 days, 16 hours, 37 minutes ago
Saturday, September 03, 2011 10:20:57 AM GMT Friday, September 02, 2011 11:51:30 AM GMT
The storage guy is configuring a new storage system. It includes RAID arrays, SVC, HBA & Fibre Channel configurations. He’s asked me to define some configurations for optimal SQL Server performance. Rather than supply him with configurations... (more)
category: Data | clicked: 7 | 5 comments | | source: beyondrelational.com
tags: SQL Server, Database
7
Shouts
spam Shout it Mute it

WCF # 1 – WCF Introduction (ENDPOINTs)
published 630 days, 18 hours, 8 minutes ago posted by dharadhara 631 days, 16 hours, 37 minutes ago
Saturday, September 03, 2011 10:20:57 AM GMT Friday, September 02, 2011 11:52:04 AM GMT
Hi Friends , This is the first time i m posting on Beyond Rational , and I hope my posts will be helpful for you to understand some interesting Microsoft Technologies,I would like to thank JACOB as he gave me an opportunity to start with BeyondRational... (more)
category: Web Dev | clicked: 27 | 1 comment | | source: beyondrelational.com
tags: .NET, WCF, ASP.NET
6
Shouts
spam Shout it Mute it

TSQL Challenge 63 - A TSQL Sudoku
published 630 days, 18 hours, 8 minutes ago posted by dharadhara 631 days, 16 hours, 36 minutes ago
Saturday, September 03, 2011 10:20:57 AM GMT Friday, September 02, 2011 11:52:32 AM GMT
This challenge is a puzzle of numbers. Everyone of you might have came across this puzzle named 'Sudoku'. (more)
category: Data | clicked: 11 | 3 comments | | source: beyondrelational.com
tags: SQL Server, tsql challenges, TSQL
7
Shouts
spam Shout it Mute it

SQL Server – "Denali" – PERCENT_RANK() Analytic Function
published 630 days, 18 hours, 8 minutes ago posted by kinj312kinj312 633 days, 20 hours, 34 minutes ago
Saturday, September 03, 2011 10:20:57 AM GMT Wednesday, August 31, 2011 7:54:12 AM GMT
PERCENTRANK() returns the position of a row within the result set. In contrast to RANK() function, PERCENTRANK() ranks rows between 0 and 1, both inclusive. Computation formula used by PERCENT_RANK(): (RANK() – 1) / (Number of Rows – 1)... (more)
category: Data | clicked: 28 | comment | | source: beyondrelational.com
tags: SQL Server, denali
7
Shouts
spam Shout it Mute it

Data centre management for database servers
published 630 days, 18 hours, 8 minutes ago posted by kinj312kinj312 633 days, 20 hours, 34 minutes ago
Saturday, September 03, 2011 10:20:57 AM GMT Wednesday, August 31, 2011 7:54:35 AM GMT
Setting up a new database server environment in a new data centre requires testing. It’s a mix of benchmarking and stress testing. Unless you can recreate the underlying traffic and recreate a “realistic” production environment, then... (more)
category: Data | clicked: 11 | 1 comment | | source: beyondrelational.com
tags: SQL Server, Database
9
Shouts
spam Shout it Mute it

MSBI # 23 – SSIS # 10 – Control Flow Tasks # 5 – For Each Loop Container Task
published 630 days, 18 hours, 8 minutes ago posted by kinj312kinj312 633 days, 20 hours, 32 minutes ago
Saturday, September 03, 2011 10:20:57 AM GMT Wednesday, August 31, 2011 7:56:46 AM GMT
Continuing from my last post on SSIS Control flow task in which we talk lot about For Loop Container: MSBI # 22 – SSIS # 9 – Control Flow Tasks # 4 – For Loop Container Task « (B)usiness (I)ntelligence Mentalist We are covering following points in this... (more)
category: Data | clicked: 10 | 3 comments | | source: beyondrelational.com
tags: SQL Server, MSBI, BI
6
Shouts
spam Shout it Mute it

Solve the FizzBuzz problem with SQL code
published 632 days, 18 hours, 3 minutes ago posted by dharadhara 634 days, 21 hours, 25 minutes ago
Thursday, September 01, 2011 10:25:36 AM GMT Tuesday, August 30, 2011 7:03:49 AM GMT
Brent Ozar , a SQL Server MCM and MVP, posted about Top 10 SQL Server DBA Interview Questions . The question no 10 is about solving FizzBuzz problem. The FizzBuzz problem is described as Write a program that prints the numbers from 1 to 100. But for multiples... (more)
category: Data | clicked: 20 | comment | | source: beyondrelational.com
tags: SQL Server
7
Shouts
spam Shout it Mute it

How to report a SQL Server performance problem
published 632 days, 18 hours, 3 minutes ago posted by dharadhara 634 days, 21 hours, 25 minutes ago
Thursday, September 01, 2011 10:25:36 AM GMT Tuesday, August 30, 2011 7:03:23 AM GMT
You’re experiencing a sudden slow down in SQL Server performance. Users are complaining. Many reasons could be causing this sudden slowdown. For SQL Server performance problems, gathering and analyzing data is not enough. A lot of time can be wasted... (more)
category: Data | clicked: 10 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

Query Plan Re-use: Write your T-SQL queries with the proper case for plan re-use and better query performance
published 632 days, 18 hours, 3 minutes ago posted by dharadhara 634 days, 21 hours, 26 minutes ago
Thursday, September 01, 2011 10:25:36 AM GMT Tuesday, August 30, 2011 7:02:54 AM GMT
I had an interesting time at the office recently. We were undertaking a performance tuning exercise for the canned reports of an OLTP that were migrated from Crystal Reports to SSRS, and had to come up with some ground rules for all database developers... (more)
category: Data | clicked: 39 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
7
Shouts
spam Shout it Mute it

MSBI # 22 - SSIS # 9 - Control Flow Tasks # 4 - For Loop Container Task
published 634 days, 6 hours, 43 minutes ago posted by dharadhara 635 days, 22 hours, 40 minutes ago
Tuesday, August 30, 2011 9:45:16 PM GMT Monday, August 29, 2011 5:48:56 AM GMT
Continuing from my last post on SSIS Control flow task on : MSBI # 14 – SSIS # 7 – Control Flow Tasks # 2- Details of Control Flow Task {Part – II} In this post we are going to look at every aspects of For Loop Container Task. We are covering following... (more)
category: Data | clicked: 9 | comment | | source: beyondrelational.com
tags: SQL Server, MSBI, SSIS, BI
9
Shouts
spam Shout it Mute it

Creating Basic RSS Reader in ASP.NET MVC 3
published 634 days, 6 hours, 43 minutes ago posted by dharadhara 635 days, 22 hours, 41 minutes ago
Tuesday, August 30, 2011 9:45:16 PM GMT Monday, August 29, 2011 5:47:53 AM GMT
In this post I am going to explain you how we can create a basic RSS Reader with the help of Linq-To-Xml and ASP.NET MVC3 Razor. Those who are writing or reading Blogs already knows what is RSS Reader. But those who does not know What is RSS. Below... (more)
category: Web Dev | clicked: 42 | 4 comments | | source: beyondrelational.com
tags: ASP.NET MVC, .NET
7
Shouts
spam Shout it Mute it

RAID server configuration and disk amounts
published 634 days, 6 hours, 43 minutes ago posted by dharadhara 635 days, 22 hours, 41 minutes ago
Tuesday, August 30, 2011 9:45:16 PM GMT Monday, August 29, 2011 5:47:26 AM GMT
Choosing the optimal amount of disks for a RAID server configuration and block sizes can be a challenge. Typical questions from the SAN\Storage guy to the DBA are: “How many disks in a RAID configuration?” “What is the optimal block... (more)
category: Data | clicked: 16 | 5 comments | | source: beyondrelational.com
tags: SQL Server, TSQL
7
Shouts
spam Shout it Mute it

First look at ColumnStore Indexes in SQL Server DENALI
published 635 days, 9 hours, 31 minutes ago posted by dharadhara 638 days, 18 hours, 29 minutes ago
Monday, August 29, 2011 6:57:44 PM GMT Friday, August 26, 2011 10:00:01 AM GMT
By this time everyone are aware that the next version of SQL Server i.e DENALI comes with ColumnStore Indexes which is a new concept in SQL Server. If you haven’t tried this feature yet then its about time to try it out on CTP3. I am pretty sure... (more)
category: Data | clicked: 35 | 1 comment | | source: beyondrelational.com
tags: SQL Server, denali
7
Shouts
spam Shout it Mute it

DB2 event monitor and snapshot monitor
published 635 days, 9 hours, 31 minutes ago posted by dharadhara 638 days, 18 hours, 28 minutes ago
Monday, August 29, 2011 6:57:44 PM GMT Friday, August 26, 2011 10:00:33 AM GMT
I collect database usage information in two different ways. Snapshots and Monitoring Events. Either method collects real-time database usage information such as SQL queries, buffer pool activity and locking information. An event monitor is a statement... (more)
category: Data | clicked: 8 | 1 comment | | source: beyondrelational.com
tags: SQL Server, Database
7
Shouts
spam Shout it Mute it

Summary - SQL server to SQL Azure migration
published 635 days, 9 hours, 31 minutes ago posted by dharadhara 638 days, 18 hours, 28 minutes ago
Monday, August 29, 2011 6:57:44 PM GMT Friday, August 26, 2011 10:00:59 AM GMT
In this blog post, I aim to summarize database migration options that I have been blogging about for past few weeks. Choosing right tool is a key decision when you decide to migrate SQL server to SQL Azure – And I hope this blog post can help you decide... (more)
category: Data | clicked: 14 | 3 comments | | source: beyondrelational.com
tags: SQL Server, SQL Azure
8
Shouts
spam Shout it Mute it

Database Tuning overview – Buffer Tuning
published 638 days, 55 minutes ago posted by kinj312kinj312 639 days, 18 hours, 46 minutes ago
Saturday, August 27, 2011 3:33:58 AM GMT Thursday, August 25, 2011 9:42:51 AM GMT
As part of the Performance Tuning series – Performance Stack , this section looks at Buffer Managment tuning. The purpose of the series is a general approach to Performance Tuning – independent of database server platform. A large proportion... (more)
category: Data | clicked: 9 | 1 comment | | source: beyondrelational.com
tags: SQL Server, Database
10
Shouts
spam Shout it Mute it

Visual Studio 2010 Color Theme Editor- Customize look of visual studio
published 636 days, 7 hours, 42 minutes ago posted by kinj312kinj312 639 days, 18 hours, 46 minutes ago
Sunday, August 28, 2011 8:46:16 PM GMT Thursday, August 25, 2011 9:42:27 AM GMT
We have all love Visual Studio 2010 and I am sure you all want to change color for menus, toolbars and title etc. Today I have found one of the most interesting Extension for Visual studio 2010 from which you can manage all this things. Don’t believe... (more)
category: Web Dev | clicked: 45 | 1 comment | | source: beyondrelational.com
tags: Visual Studio 2010, ASP.NET
8
Shouts
spam Shout it Mute it

Playing with dropdownlist using jQuery - SelectedValue, SelectedText, SelectionChange, Adding, Removing Items
published 638 days, 55 minutes ago posted by kinj312kinj312 639 days, 18 hours, 47 minutes ago
Saturday, August 27, 2011 3:33:58 AM GMT Thursday, August 25, 2011 9:41:56 AM GMT
You might be working with ASP.NET Dropdown list or normal html dropdownlist while working with web development. In common scenarios and day to day applications we need to get value filed ( usually ID ) and text filed of the selected item in the drop down... (more)
category: Web Dev | clicked: 33 | 3 comments | | source: beyondrelational.com
tags: .NET, jQuery, ASP.NET
8
Shouts
spam Shout it Mute it

Calculate disk IO throughput and MB per second
published 638 days, 55 minutes ago posted by dharadhara 640 days, 16 hours, 51 minutes ago
Saturday, August 27, 2011 3:33:58 AM GMT Wednesday, August 24, 2011 11:37:19 AM GMT
The Storage \ SAN administrator asks “ can I have some targets to aim for in testing a new storage IO subsystem installation”. Of course, as the SQL Server DBA I normally reply by saying “ I don’t have any targets apart from activity... (more)
category: Data | clicked: 11 | comment | | source: beyondrelational.com
tags: SQL Server
8
Shouts
spam Shout it Mute it

Export to Excel upgrades in SSRS Denali CTP3
published 639 days, 6 hours, 51 minutes ago posted by dharadhara 640 days, 16 hours, 52 minutes ago
Thursday, August 25, 2011 9:37:21 PM GMT Wednesday, August 24, 2011 11:36:47 AM GMT
I don’t know whether it is the same with you guys but for me, it is a bit hard to get on track and start work after a long vacation. Usually, the initial few days are spent idle before the computer and if I don’t make an effort to control it, my moods... (more)
category: Data | clicked: 5 | comment | | source: beyondrelational.com
tags: SQL Server, BI, SSRS
Previous 1 2 ... 13 14 15 16 17 18 19 20 21 22 ... 55 56 Next