DotNetShoutout

jacobsebastian

Name:	jacobsebastian
Score:	4,772.5
Last Seen:	413 days, 38 minutes ago
Member Since:	6 April, 2010

8
Shouts

Shout it

Always use ANSI joins for accuracy

published 502 days, 11 hours, 2 minutes ago posted by

kinj312 503 days, 21 hours, 11 minutes ago

Suppose there are two tables which have 5 and 4 rows respectively and related by the column id. If you want to join these two tables and get data from table1 you can write old style join like below create table table1 (id int, names varchar(100)) insert... (more)

category: Data | clicked: 9 | 1 comment | | source: beyondrelational.com

tags: SQL Server, TSQL

8
Shouts

Shout it

SQL Server – T-SQL – ALTER SCHEMA…TRANSFER option – Change the schema of a database object, type or XML Schema Collection

published 500 days, 12 hours, 56 minutes ago posted by

kinj312 504 days, 18 hours, 23 minutes ago

Ever since SQL Server 2005 introduced user-schema separation, schemas have received due importance. Most new designs isolate functionality within the same database via the use of schemas. With the growing use schemas, did you ever face a situation wherein... (more)

category: Data | clicked: 20 | 1 comment | | source: beyondrelational.com

tags: SQL Server, TSQL

10
Shouts

Shout it

Get WCF Service Metadata on client application

published 502 days, 11 hours, 2 minutes ago posted by

kinj312 504 days, 18 hours, 22 minutes ago

Sometimes the client needs to programmatically verify whether a particular endpoint supports a particular contracts. Suppose Application administrator deployed application but it was pointing to development environment or some other address. If this feature... (more)

category: Web Dev | clicked: 37 | comment | | source: beyondrelational.com

tags: .NET, WCF, ASP.NET

9
Shouts

Shout it

SQL Traces and c2 auditing are different

published 500 days, 12 hours, 56 minutes ago posted by

kinj312 504 days, 18 hours, 21 minutes ago

Sometimes end users interchange the terms : C2 auditing and Traces. They server different purposes. c2 auditing records all attempts (successfull and failed) on objects and statements. Typically a SQL Server DBA will use a c2 audit to monitor security... (more)

category: Data | clicked: 21 | 1 comment | | source: beyondrelational.com

tags: SQL Server, TSQL, Database

9
Shouts

Shout it

Http POST or GET Method from MSSQL

published 498 days, 15 hours, 3 minutes ago posted by

kinj312 507 days, 18 hours, 52 minutes ago

Few days back I was trying to send sql data to my web API using Store-procedure and it was simple and interesting, you can use the same way to call web http post or get both method using such way CREATE function [dbo].[HttpGetMethod] ( @url varchar(8000... (more)

category: Data | clicked: 22 | 2 comments | | source: beyondrelational.com

tags: SQL Server, TSQL

8
Shouts

Shout it

I don’t want to be worry about WCF configuration on client side

published 504 days, 9 hours, 9 minutes ago posted by

kinj312 507 days, 18 hours, 53 minutes ago

I personally feels there is still too much configuration in setting up WCF service infact Microsoft has reduced in new .net frameworks. If client application wants to consume WCF service then you need to create proxy class using Visual Studio and create... (more)

category: Web Dev | clicked: 26 | 1 comment | | source: beyondrelational.com

tags: .NET, WCF, ASP.NET

8
Shouts

Shout it

Central Management Servers register error in SQL Server 2008 - "Can not add a shared registered server with the same name as configuration Server"

published 504 days, 18 hours, 13 minutes ago posted by

kinj312 507 days, 18 hours, 54 minutes ago

You may know how can we register SQL Server instances with Central Management Servers (CMS) and also how can we perform multi server query will all of instances of registered SQL Server instances. There you can see i have registered one shared SQL Server... (more)

category: Data | clicked: 4 | 1 comment | | source: beyondrelational.com

tags: SQL Server, TSQL

7
Shouts

Shout it

Easy URL routing in ASP.NET 4.0 web forms

published 500 days, 12 hours, 56 minutes ago posted by

dhara 508 days, 18 hours, 16 minutes ago

In this post I am going to explain URL routing in greater details. This post will contain basic of URL routing and will explain how we can do URL routing in fewer lines of code. Why we need URL routing? Let’s consider a simpler scenario we want to display... (more)

category: Web Dev | clicked: 21 | comment | | source: beyondrelational.com

tags: .NET, ASP.NET

7
Shouts

Shout it

Getting started with SQL Azure - Part 2: Creating Azure account and a SQL Azure Database

published 504 days, 18 hours, 13 minutes ago posted by

dhara 508 days, 18 hours, 17 minutes ago

In this article, we will first get you a Windows Azure account, if you don’t have one. Then, we will create a SQL Azure Database. And then, we will try connecting to it through SQL Server Management Studio running on our machine. (more)

category: Data | clicked: 8 | 1 comment | | source: beyondrelational.com

tags: SQL Server, SQL Azure, Azure

7
Shouts

Shout it

SSIS #103 – Learn SSIS NOW

published 504 days, 18 hours, 13 minutes ago posted by

dhara 508 days, 18 hours, 16 minutes ago

When I wrote the blog SSIS # 102 – Don’t be afraid to leverage TSQL in SSIS package , it was purely “inspired” by an ETL design I was working on during the day, and also an SSIS training piece I was reading from Pragmatic Works... (more)

category: Data | clicked: 12 | 1 comment | | source: beyondrelational.com

tags: SQL Server, TSQL, SSIS, BI

10
Shouts

Shout it

XQuery Lab 65 – Restructuring an XML document using FLWOR

published 504 days, 18 hours, 13 minutes ago posted by

kinj312 509 days, 17 hours, 43 minutes ago

I found this question in this SSC forum thread requesting help to shape the XML document. Here is the input XML document. (more)

category: Data | clicked: 9 | 1 comment | | source: beyondrelational.com

tags: SQL Server, xquery, xquery labs

10
Shouts

Shout it

Reduce heap table fragmentation

published 504 days, 18 hours, 13 minutes ago posted by

kinj312 509 days, 17 hours, 43 minutes ago

A table that does not have a clustered index is referred to as a Heap. While a lot has been written about index fragmentation and how to defrag indexes, there is not much that talks about how to defrag a heap table. To identify whether your heap table... (more)

category: Data | clicked: 14 | 1 comment | | source: beyondrelational.com

tags: SQL Server, TSQL, Database

11
Shouts

Shout it

SQL Database Status with sys.databases

published 504 days, 18 hours, 13 minutes ago posted by

kinj312 509 days, 17 hours, 42 minutes ago

I was creating a Powershell script for a SQL Server checkout procedure after a reboot , and used the state_desc column in sys.databases view to report on the database status. The descriptions, courtesy of BOL are: ONLINE - Database is available for access... (more)

category: Data | clicked: 16 | 1 comment | | source: beyondrelational.com

tags: SQL Server, Database

8
Shouts

Shout it

Getting started with SQL Azure - Part 1: What is SQL Azure?

published 504 days, 18 hours, 13 minutes ago posted by

dhara 510 days, 16 hours, 57 minutes ago

In this article, we are going to begin our journey of learning SQL Azure. We will first see where SQL Azure fits in the Windows Azure Platform offerings. We will then discuss about the ways in which we can define SQL Azure. (more)

category: Data | clicked: 20 | 1 comment | | source: beyondrelational.com

tags: SQL Azure, Azure

8
Shouts

Shout it

CAPTCHAs do not mitigate XSS worms

published 504 days, 18 hours, 13 minutes ago posted by

dhara 510 days, 16 hours, 56 minutes ago

One common misconception about web security is that protecting important actions with CAPTCHAs can prevent XSS attacks from doing real damage. By preventing malicious code from scripting critical tasks, the idea goes, XSS injections won’t... (more)

category: Web Dev | clicked: 33 | 1 comment | | source: beyondrelational.com

tags: .NET, ASP.NET

9
Shouts

Shout it

Find out the referenced tables of a table that to be added as articles in replication

published 504 days, 18 hours, 13 minutes ago posted by

dhara 510 days, 16 hours, 55 minutes ago

In replication, we need to add objects as articles to replicate the data to different server.The important point is here that if we have any reference(foreign keys) associated with the articles(tables choosen to be replicated), then we need to consider... (more)

category: Data | clicked: 25 | 1 comment | | source: beyondrelational.com

tags: SQL Server, TSQL, Database

9
Shouts

Shout it

SQL Server – T-SQL - Best Practice - Composite Primary Keys – Performance (and accuracy) impact

published 509 days, 3 hours, 34 minutes ago posted by

kinj312 511 days, 20 hours, 8 minutes ago

One of the reasons I enjoy working with Microsoft SQL Server because often I find that its behaviour is a classic case of GIGO (Garbage In Garbage Out). Jacob Sebastian ( blog ) always makes it a point to mention in his TechEd and Community Tech Days... (more)

category: Data | clicked: 39 | 1 comment | | source: beyondrelational.com

tags: SQL Server, TSQL

11
Shouts

Shout it

Day 7: Unpivot using UNNEST function in PostgreSQL

published 509 days, 3 hours, 34 minutes ago posted by

kinj312 511 days, 20 hours, 8 minutes ago

UnNest function in PostgreSQL In PostgreSQL, we can perform UnPivoting using the UnNest function. It accepts an array and expands the array items in set of rows. Syntax: UNNEST(Some array) Example Let us consider the below script Create Table tblUnPivotExample... (more)

category: Data | clicked: 13 | 1 comment | | source: beyondrelational.com

tags: SQL Server, TSQL

9
Shouts

Shout it

Create SQL Server scripts with Visio 2010

published 509 days, 3 hours, 34 minutes ago posted by

kinj312 511 days, 20 hours, 7 minutes ago

If you are using Visio 2010 and creating tables via the Database Model Diagram template, you may be surprised to learn there is not a way to build CREATE TABLE scripts from your resulting diagram. The last release that supported that was the Enterprise... (more)

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

tags: SQL Server

6
Shouts

Shout it

SQL Server 2012: Detecting Sort Warnings with Extended Events (sort_warning event) – Part 2

published 510 days, 19 hours, 41 minutes ago posted by

dhara 513 days, 20 hours, 47 minutes ago

In my last post, SQL Server 2012: Detecting Sort Warnings with Extended Events (sortwarning event) I showed how to use sortwarning event with sql_text action to detect sort warnings in database with statements sent to SQL server instance. We also saw... (more)

category: Data | clicked: 3 | 1 comment | | source: beyondrelational.com

tags: SQL Server, TSQL, sql server 2012

Welcome!

jacobsebastian

Always use ANSI joins for accuracy

SQL Server – T-SQL – ALTER SCHEMA…TRANSFER option – Change the schema of a database object, type or XML Schema Collection

Get WCF Service Metadata on client application

SQL Traces and c2 auditing are different

Http POST or GET Method from MSSQL

I don’t want to be worry about WCF configuration on client side

Central Management Servers register error in SQL Server 2008 - "Can not add a shared registered server with the same name as configuration Server"

Easy URL routing in ASP.NET 4.0 web forms

Getting started with SQL Azure - Part 2: Creating Azure account and a SQL Azure Database

SSIS #103 – Learn SSIS NOW

XQuery Lab 65 – Restructuring an XML document using FLWOR

Reduce heap table fragmentation

SQL Database Status with sys.databases

Getting started with SQL Azure - Part 1: What is SQL Azure?

CAPTCHAs do not mitigate XSS worms

Find out the referenced tables of a table that to be added as articles in replication

SQL Server – T-SQL - Best Practice - Composite Primary Keys – Performance (and accuracy) impact

Day 7: Unpivot using UNNEST function in PostgreSQL

Create SQL Server scripts with Visio 2010

SQL Server 2012: Detecting Sort Warnings with Extended Events (sort_warning event) – Part 2

Open ID Login

Standard Login

Forgot Password?

Sign up