DotNetShoutout

jacobsebastian

Name:	jacobsebastian
Score:	4,772.5
Last Seen:	412 days, 15 hours, 15 minutes ago
Member Since:	6 April, 2010

10
Shouts

Shout it

SQL CLR DLL Register error in SQL Server - "The database owner SID recorded in the master database differs from the database owner SID recorded in database"

published 535 days, 5 hours, 13 minutes ago posted by

kinj312 537 days, 7 hours, 41 minutes ago

Recently while working with SQL CLR functionality and created DLL for the SQL CLR. But while registering this DLL in the database i got one surprised error. Lt's show you the script so you have more idea. We have a script to register DLL as following... (more)

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

tags: SQL Server, CLR, TSQL

7
Shouts

Shout it

Getting Started with SSRS - Part 2 - Designing a report using Report Wizard

published 535 days, 5 hours, 13 minutes ago posted by

kinj312 538 days, 11 hours, 46 minutes ago

This article frames a guideline on how to make the use of the Report Wizard and create a simple report using the Business Intelligence Studio. A Report Wizard is the simplest form for creating a readymade report by simply selecting the data that should be displayed and by selecting the inbuilt templates available as per the requirement. (more)

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

tags: SQL Server, TSQL, BI, SSRS

7
Shouts

Shout it

T-SQL to get the SQL Server Service Start time and Up time of SQL Server service

published 535 days, 5 hours, 13 minutes ago posted by

kinj312 538 days, 11 hours, 50 minutes ago

There are number of occasions where we need to get to know the SQL Server service start date time and also from what time the SQL Services are up and running generally termed as Uptime. There are many ways to do it like check for temp DB Creation time... (more)

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

tags: SQL Server, TSQL

7
Shouts

Shout it

Day 65: Insert into multiple tables from a single table in Oracle by using the INSERT ALL statement

published 535 days, 5 hours, 13 minutes ago posted by

kinj312 538 days, 11 hours, 51 minutes ago

In Oracle, it is possible to split the record based on the columns and to insert them into multiple tables at the same time. Consider the below case where we have the tblEmployee as our base table SQL> Select * From tblEmployee; EMPID EMPNAME SALARY... (more)

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

tags: SQL Server, TSQL, Oracle

7
Shouts

Shout it

Getting Started with SSRS - Part 3 - Designing a report using Report Designer

published 535 days, 5 hours, 13 minutes ago posted by

kinj312 538 days, 12 hours, 3 minutes ago

This article would cover how to design a report using the Report Designer. In our previous article, we saw the option on designing a report using the Report Wizard with just the configurations used to design and develop the report with some simple steps. (more)

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

tags: SQL Server, TSQL, BI, SSRS

8
Shouts

Shout it

Quick way to know all computed columns across tables

published 535 days, 5 hours, 13 minutes ago posted by

kinj312 539 days, 12 hours, 13 minutes ago

A computed column in SQL Server is an expression which is based on another column in the same table. Consider the following example create table testtable ( id int, names varchar(100), custid as right('00000'+cast(id as varchar(10)),5) ) GO... (more)

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

tags: SQL Server, TSQL

8
Shouts

Shout it

SQL Server – Profiler – Part 2 – Profiler Templates, Template Types and Creating Customized Templates

published 535 days, 5 hours, 13 minutes ago posted by

kinj312 539 days, 12 hours, 13 minutes ago

Based on popular demand from my colleagues and you, the kind reader, I am currently writing a series of posts on the SQL Server Profiler. You can read the first part on What is a SQL Trace? Permissions, space requirements and launching the Profiler .... (more)

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

tags: SQL Server, TSQL

8
Shouts

Shout it

More on Table-valued Parameters (TVP’s)

published 535 days, 5 hours, 13 minutes ago posted by

kinj312 539 days, 12 hours, 12 minutes ago

While finalising some slides for my presentation at the Canberra .Net User Group on Using XML and TVP’s to Transport Relational Data , I stumbled across a couple of posts by Bob Beauchemin relating to how TVP’s cause plan recompiles when called from ADO... (more)

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

tags: SQL Server, TSQL, TVP, Database

9
Shouts

Shout it

SSRS Tutorial - Part 1 - SQL Server Reporting Services Overview and Installing in Windows Server 2008

published 541 days, 14 hours, 59 minutes ago posted by

kinj312 542 days, 12 hours, 14 minutes ago

In this article, we would see what SQL Server Reporting Services are and a high-level overview of the architecture and the components involved in running reports on the SQL Server. This article is the first part of the series on SQL Server Reporting Services right from the architectural overview to running the customized report on different servers with deployment. (more)

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

tags: SQL Server, TSQL, BI, SSRS

8
Shouts

Shout it

Quotename in SQL

published 541 days, 14 hours, 59 minutes ago posted by

kinj312 542 days, 12 hours, 20 minutes ago

Quotename() is a SQL Server String function. It accepts an input string of of up to 128 characters. Which is a limitation, although you could easily create a workaround with a UDF Returns a Unicode string of a valid delimited identifier. Why would you... (more)

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

tags: SQL Server, TSQL

8
Shouts

Shout it

SSIS # 102 – Don’t be afraid to leverage TSQL in SSIS package

published 541 days, 14 hours, 59 minutes ago posted by

kinj312 542 days, 12 hours, 20 minutes ago

I hope so far you are convinced that you need to learn at least one ETL tool in order to stay competitive in the SQL/BI profession. I also hope that Microsoft SSIS is your choice. I’ve worked with two types of people with very different views on... (more)

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

tags: SQL Server, TSQL, SSIS

8
Shouts

Shout it

Day 63: PL/SQL - 11 (CONTINUE and CONTINUE-WHEN statement in Oracle 11g's Pl/SQL)

published 541 days, 14 hours, 59 minutes ago posted by

kinj312 542 days, 12 hours, 19 minutes ago

CONTINUE statement Introduce in Oracle 11g,this statement provides an easy way to force an immediate jump to the loop control statement Let us see this into action by writing a simple Even..Odd number program SQL> BEGIN 2 FOR i IN 1 .. 10 LOOP 3 IF... (more)

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

tags: SQL Server, PL/SQl

8
Shouts

Shout it

Day 62: PL/SQL - 10 (EXIT and EXIT-WHEN statement in Pl/SQL)

published 541 days, 14 hours, 59 minutes ago posted by

kinj312 543 days, 12 hours, 12 minutes ago

EXIT statement EXIT statement is similar to the BREAK statement found in other programing languages like C, C++, Java, C# , JavaScript, SQL SERVER etc. It breaks the loop statement once the specified condition becomes true and then control comes to the... (more)

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

tags: SQL Server, PL/SQl, TSQL

8
Shouts

Shout it

Study of WAITSTATS(Part 4) - PREEMPTIVE_*

published 541 days, 14 hours, 59 minutes ago posted by

kinj312 543 days, 12 hours, 11 minutes ago

PREEMPTIVE_XXX wait types are basically associated with the worker thread outside SQL engine. These wait types have been newly introduced in SQL server 2008. (SQL server will not have any control over the work.) Thank you to SQL server team introducing... (more)

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

tags: SQL Server, TSQL

8
Shouts

Shout it

SQL SERVER – Puzzle to Win Print Book – Functions FIRST_VALUE and LAST_VALUE with OVER clause and ORDER BY « Journey to SQLAuthority

published 554 days, 12 hours, 57 minutes ago posted by

pinaldave 556 days, 12 hours, 38 minutes ago

Some time an interesting feature and smart audience makes total difference at places. From last two days, I have been writing on SQL Server 2012 feature FIRSTVALUE and LASTVALUE. Please read following post before I continue today as this question is based on the same.Introduction to FIRSTVALUE and LASTVALUEIntroduction to FIRSTVALUE and LASTVALUE with OVER clause As a comment of the second post I received excellent question from Nilesh Molankar. He asks what will happen if we change few things in... (more)

category: Data | clicked: 61 | 1 comment | | source: blog.sqlauthority.com

5
Shouts

Shout it

SQL Server – SSMS – Table Designer v/s ALTER TABLE – Best Practices - Msg 1701 - Creating or altering table failed….This exceeds the maximum allowable table row size of 8060 bytes

published 554 days, 12 hours, 57 minutes ago posted by

dhara 556 days, 13 hours, 16 minutes ago

A few months ago, I wrote about how one might end up with a Message #1701 error when attempting to execute an ALTER TABLE…ALTER COLUMN statement. You can refer the original post here . Vishal Gajjar ( blog ) recently wrote about the Table Designer component. (more)

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

tags: SQL Server, TSQL

5
Shouts

Shout it

Day 49: UserEnv function of Oracle

published 554 days, 12 hours, 57 minutes ago posted by

dhara 556 days, 13 hours, 16 minutes ago

Let Us Learn Oracle - Part 49 of N [ UserEnv Function of Oracle 10g ] Purpose: This function retrives information about current Oracle Session. Syntax: UserEnv(Parameter) Where, Parameter = > It is value return from the current Oracle Session Examp;le... (more)

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

tags: SQL Server, Oracle

5
Shouts

Shout it

XEvent Session - System_health

published 554 days, 12 hours, 57 minutes ago posted by

dhara 556 days, 13 hours, 16 minutes ago

Today Am going to explain something about the ring buffer which is an internal structure in SQL server that captures various information like security errors, any kind of exceptions, scheduler information, resource monitor information etc. How did I reach... (more)

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

tags: SQL Server, TSQL

6
Shouts

Shout it

Day 48: Bin_To_Num function of Oracle

published 554 days, 12 hours, 57 minutes ago posted by

dhara 557 days, 11 hours, 19 minutes ago

Let Us Learn Oracle - Part 48 of N [ BinToNum Function of Oracle 10g ] Purpose: This function converts a bit vector to it's corresponding numeric value Syntax: BinToNum(value1,value2,value3...,valueN) Where, value1,...valueN => are the bit... (more)

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

tags: SQL Server, Oracle

6
Shouts

Shout it

Backup/restore/checkdb/shrinkfile progress

published 554 days, 12 hours, 57 minutes ago posted by

dhara 557 days, 11 hours, 18 minutes ago

Have you ever wonderet how long you need to wait for a backup or restore command to complete? If you perform the backup or restore from the gui in management studio, it shows you the progres for every 10%. But what to do if you issuet the backup or restore... (more)

category: Data | clicked: 28 | 3 comments | | source: beyondrelational.com

tags: SQL Server, Database

Welcome!

jacobsebastian

SQL CLR DLL Register error in SQL Server - "The database owner SID recorded in the master database differs from the database owner SID recorded in database"

Getting Started with SSRS - Part 2 - Designing a report using Report Wizard

T-SQL to get the SQL Server Service Start time and Up time of SQL Server service

Day 65: Insert into multiple tables from a single table in Oracle by using the INSERT ALL statement

Getting Started with SSRS - Part 3 - Designing a report using Report Designer

Quick way to know all computed columns across tables

SQL Server – Profiler – Part 2 – Profiler Templates, Template Types and Creating Customized Templates

More on Table-valued Parameters (TVP’s)

SSRS Tutorial - Part 1 - SQL Server Reporting Services Overview and Installing in Windows Server 2008

Quotename in SQL

SSIS # 102 – Don’t be afraid to leverage TSQL in SSIS package

Day 63: PL/SQL - 11 (CONTINUE and CONTINUE-WHEN statement in Oracle 11g's Pl/SQL)

Day 62: PL/SQL - 10 (EXIT and EXIT-WHEN statement in Pl/SQL)

Study of WAITSTATS(Part 4) - PREEMPTIVE_*

SQL SERVER – Puzzle to Win Print Book – Functions FIRST_VALUE and LAST_VALUE with OVER clause and ORDER BY « Journey to SQLAuthority

SQL Server – SSMS – Table Designer v/s ALTER TABLE – Best Practices - Msg 1701 - Creating or altering table failed….This exceeds the maximum allowable table row size of 8060 bytes

Day 49: UserEnv function of Oracle

XEvent Session - System_health

Day 48: Bin_To_Num function of Oracle

Backup/restore/checkdb/shrinkfile progress

Open ID Login

Standard Login

Forgot Password?

Sign up