jacobsebastian

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

Auditing in SQL server
published 558 days, 20 hours, 24 minutes ago posted by dharadhara 561 days, 18 hours, 47 minutes ago
Sunday, November 13, 2011 6:26:32 AM GMT Thursday, November 10, 2011 8:04:07 AM GMT
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Audit... (more)
category: Data | clicked: 18 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
5
Shouts
spam Shout it Mute it

SQL Server: Simple Parameterization
published 559 days, 23 hours, 28 minutes ago posted by dharadhara 562 days, 18 hours, 34 minutes ago
Saturday, November 12, 2011 3:22:30 AM GMT Wednesday, November 09, 2011 8:16:57 AM GMT
Simple parameterization is SQL Server feature which allow the optimizer to parameterize submitted queries. If submitted query has no parameters and has constant values plugged in, the optimizer can choose to treat constant values as parameters and automatically... (more)
category: Data | clicked: 6 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
5
Shouts
spam Shout it Mute it

Study of WAITSTATS(Part 3) - WRITELOG
published 559 days, 23 hours, 28 minutes ago posted by dharadhara 562 days, 18 hours, 35 minutes ago
Saturday, November 12, 2011 3:22:30 AM GMT Wednesday, November 09, 2011 8:16:02 AM GMT
When a transaction happens, say for an example data is bening inserted, there are mainly two things happens: 1. data page in the buffer cache is updated. 2. Data is written to the log cache.(This is to ensure the ACID property incase of any rollback.... (more)
category: Data | clicked: 4 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
5
Shouts
spam Shout it Mute it

SQL Server – SSMS - Profiler - Extracting Deadlock Event Data to XDL files
published 559 days, 23 hours, 28 minutes ago posted by dharadhara 562 days, 18 hours, 35 minutes ago
Saturday, November 12, 2011 3:22:30 AM GMT Wednesday, November 09, 2011 8:15:43 AM GMT
A deadlock occurs when there is a cyclic dependency between two or more threads, or processes, for some set of resources within SQL Server. We can use the SQL Server Profiler to capture deadlock information. Today, we will see how to use the SQL Server... (more)
category: Data | clicked: 6 | comment | | source: beyondrelational.com
tags: SQL Server, ssms, TSQL
5
Shouts
spam Shout it Mute it

TSQL Challenge 68 - Generate kaprekar kernel or series from numbers
published 559 days, 23 hours, 28 minutes ago posted by dharadhara 562 days, 18 hours, 36 minutes ago
Saturday, November 12, 2011 3:22:30 AM GMT Wednesday, November 09, 2011 8:15:07 AM GMT
This challenge invites you to Generate kaprekar kernel or series from numbers.Kaprekar Series and Kaprekar Constants are numbers generated by applying the Kaprekar Routine on a number! (more)
category: Data | clicked: 3 | comment | | source: beyondrelational.com
tags: SQL Server, tsql challenges, TSQL
8
Shouts
spam Shout it Mute it

Rule “SQL Server "Denali" CTP3 Feature Upgrade” Failed
published 559 days, 23 hours, 28 minutes ago posted by dharadhara 563 days, 17 hours, 2 minutes ago
Saturday, November 12, 2011 3:22:30 AM GMT Tuesday, November 08, 2011 9:49:13 AM GMT
UPDATE: Hindsight is a wonderful thing. If I had remembered that you can’t upgrade ANY current edition of SQL Server to an evaluation edition , I wouldn’t have wasted time building a SQL Server 2008 R2 VM and then trying to upgrade it to SQL Server 2012... (more)
category: Data | clicked: 5 | 4 comments | | source: beyondrelational.com
tags: SQL Server, denali, CTP
7
Shouts
spam Shout it Mute it

Day 44: First and Last function of Oracle
published 561 days, 37 minutes ago posted by dharadhara 563 days, 17 hours, 1 minute ago
Friday, November 11, 2011 2:13:31 AM GMT Tuesday, November 08, 2011 9:49:34 AM GMT
Let Us Learn Oracle - Part 44 of N [ First and Last function of Oracle ] Purpose: Both of these acts as analytical and aggregate function. They atc on a set of rows that act as First or Last as per the given sorting specification. They accepts any numeric... (more)
category: Data | clicked: 4 | 1 comment | | source: beyondrelational.com
tags: SQL Server, Oracle
7
Shouts
spam Shout it Mute it

SPACE function will return maximum of 8000 spaces only
published 561 days, 37 minutes ago posted by dharadhara 563 days, 18 hours, 10 minutes ago
Friday, November 11, 2011 2:13:31 AM GMT Tuesday, November 08, 2011 8:40:23 AM GMT
We can use SPACE function to replicate spaces for a string. Consider the following statement select 'A'+space(10)+'B' The result is ------------ A B As you see space function adds 10 spaces between the string A and B. Note that the space... (more)
category: Data | clicked: 3 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

All About Data Flow Diagrams (DFD)
published 561 days, 37 minutes ago posted by dharadhara 564 days, 18 hours, 41 minutes ago
Friday, November 11, 2011 2:13:31 AM GMT Monday, November 07, 2011 8:09:21 AM GMT
What is a DFD? A Data Flow Diagram called DFD is a graphical representation of the "flow" of data. DFD depicts the flow of data from external entities to the system. As the name suggests it shows how data moved from one process to another. It... (more)
category: Data | clicked: 16 | 1 comment | | source: beyondrelational.com
tags: UML, DFD
6
Shouts
spam Shout it Mute it

Day 42: Percentile_Disc Function of Oracle
posted by dharadhara 564 days, 17 hours, 37 minutes ago
Monday, November 07, 2011 9:13:26 AM GMT
Let Us Learn Oracle - Part 42 of N [ Percentile_Disc function of Oracle ] It acts both as Aggregate and analytic function. Purpose: An inverse distribution function which takes a percentile value and a sort specification and returns an element from the... (more)
category: Data | clicked: 3 | comment | | source: beyondrelational.com
tags: SQL Server, Oracle
6
Shouts
spam Shout it Mute it

Study of WAITSTATS(Part 2) - CMEMTHREAD
posted by dharadhara 564 days, 18 hours, 47 minutes ago
Monday, November 07, 2011 8:03:42 AM GMT
These wait types are indicative of a shortage of memory objects.This special type of wait occurs when a task is waiting for a thread-safe memory object. The wait time might increase when there is contention caused by multiple tasks trying to allocate... (more)
category: Data | clicked: 3 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

WCF # 8 - WCF Contracts
posted by dharadhara 564 days, 18 hours, 42 minutes ago
Monday, November 07, 2011 8:08:27 AM GMT
Hi , Today we will see the most important concept in the WCF Framework called CONTRACTS. * IN every day world , a contract is a binding agreement between two or more parties that specifies the supply of goods or services for a known price. * In the world... (more)
category: Web Dev | clicked: 4 | comment | | source: beyondrelational.com
tags: .NET, WCF, ASP.NET
11
Shouts
spam Shout it Mute it

What is Microsoft TAP and RDP?
published 563 days, 9 hours, 36 minutes ago posted by dharadhara 566 days, 17 hours, 15 minutes ago
Tuesday, November 08, 2011 5:14:55 PM GMT Saturday, November 05, 2011 9:35:44 AM GMT
Technology Adoption Program (TAP) and Rapid Deployment Program (RDP) are ways for Microsoft to get early feedback on new products or product updates as well as give important customers a heads-up on what Microsoft is up to. Participation is by invitation... (more)
category: Data | clicked: 14 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
11
Shouts
spam Shout it Mute it

Multiple query plans for the same query?
published 563 days, 9 hours, 36 minutes ago posted by dharadhara 566 days, 17 hours, 14 minutes ago
Tuesday, November 08, 2011 5:14:55 PM GMT Saturday, November 05, 2011 9:36:47 AM GMT
A while back i was creating a stored procedure to be used for pulling data from the SQL Server into cacti . The procedure was pulling data from a rather large table, which I had made sure was indexed properly for my query. When I executed the stored procedure... (more)
category: Data | clicked: 8 | 1 comment | | source: beyondrelational.com
tags: SQL Server
11
Shouts
spam Shout it Mute it

Study of WAITSTATS(Part 1) - CXPACKET
published 563 days, 9 hours, 36 minutes ago posted by dharadhara 566 days, 17 hours, 15 minutes ago
Tuesday, November 08, 2011 5:14:55 PM GMT Saturday, November 05, 2011 9:36:00 AM GMT
Analysis of waitstats is the first step that I would take with any performance tuning activities on a system. Thats important because it is an easy and efficient way to understand the issues with a system at a very high level. There are many different... (more)
category: Data | clicked: 12 | 1 comment | | source: beyondrelational.com
tags: SQL Server
7
Shouts
spam Shout it Mute it

Default datatype of NULL
posted by dharadhara 567 days, 21 hours, 45 minutes ago
Friday, November 04, 2011 5:06:14 AM GMT
As you know NULL is the absence of data and any datatype can be NULL. But by default a NULL value is considered to be of INT datatype. Let us run the following code select null as t into #t GO exec tempdb..sp_help #t A NULL value is copied to a temporary... (more)
category: Data | clicked: 5 | comment | | source: beyondrelational.com
tags: SQL Server
7
Shouts
spam Shout it Mute it

SQL Server – TempDB – Is it a copy of the Model database?
posted by dharadhara 567 days, 21 hours, 45 minutes ago
Friday, November 04, 2011 5:05:25 AM GMT
Microsoft SQL Server comes with a whole range of system databases, which I visited in my post – How to programmatically identify system and user databases on a SQL Server instance . System databases are special, and there some very specific and peculiar... (more)
category: Data | clicked: 5 | comment | | source: beyondrelational.com
tags: SQL Server, Database
6
Shouts
spam Shout it Mute it

SSIS – Consuming Microsoft Access or Microsoft Excel Data Sources in 64-bit Environments
posted by dharadhara 567 days, 21 hours, 46 minutes ago
Friday, November 04, 2011 5:05:05 AM GMT
The problems discussed in this post are far from new however they are problems still discussed frequently on various forums and problems which, for some reason or another, are still difficult to debug. Please Note: The content of this post applies... (more)
category: Data | clicked: 6 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL, SSIS
7
Shouts
spam Shout it Mute it

WCF # - 7 Create and host a WCF website in IIS
posted by dharadhara 568 days, 17 hours, 34 minutes ago
Thursday, November 03, 2011 9:16:42 AM GMT
Hi Geeks, In this article,we will cover following things Create a WCF Website Host a WCF website in IIS [Internet Information Services] Test the hosted site [To check whether it is correctly hosted or not] NOTE: To host the WCF website in IIS.Before ... (more)
category: Web Dev | clicked: 7 | comment | | source: beyondrelational.com
tags: .NET, WCF, ASP.NET
7
Shouts
spam Shout it Mute it

Formula engine and storage engine in SSAS
posted by dharadhara 568 days, 17 hours, 37 minutes ago
Thursday, November 03, 2011 9:14:14 AM GMT
In SSAS, to improve query performance, it’s important to understand what happens inside analysis services when a query is run. Analysis Services is made up of two engines: Formula Engine (FE) – It is single-threaded. It processes the MDX queries... (more)
category: Data | clicked: 7 | comment | | source: beyondrelational.com
tags: SQL Server, SSAS, BI
Previous 1 2 ... 6 7 8 9 10 11 12 13 14 15 ... 55 56 Next