DotNetShoutout

SQL Server

8
Shouts

Shout it

Day 4: Find the Version of PostgreSQL

published 518 days, 9 hours, 39 minutes ago posted by

kinj312 519 days, 4 minutes ago

We can get the version information in PostgreSQL by using the version function as shown under select version(); /* Result */ version ------- "PostgreSQL 9.1.0, compiled by Visual C++ build 1500, 32-bit" In Sql Server we use @@Version Hope this... (more)

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

tags: SQL Server, TSQL

10
Shouts

Shout it

SQL Server – TempDB v/s Model database – Minimum size considerations – CREATE DATABASE - Error Msg 1803

published 514 days, 1 hour, 29 minutes ago posted by

kinj312 519 days, 4 minutes ago

A few weeks ago, I wrote a post related to the tempdb where I attempted to answer the question – Is TempDB a copy of the model database? The post attracted a couple of follow-up comments (which I really appreciate, because it gives everyone a great deal... (more)

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

tags: SQL Server, TSQL, Database

7
Shouts

Shout it

Day 3: Overlay function in PostgreSQL

published 518 days, 9 hours, 39 minutes ago posted by

dhara 519 days, 20 hours, 24 minutes ago

Purpose: To replace substring from a specified position to a specified position. Syntax: Overlay(string placing string from int [for int]) Example Select Overlay('www.beyondnational.com' Placing 'relational' From 11 For 8) "Overlay... (more)

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

tags: SQL Server, TSQL

8
Shouts

Shout it

Automated Trigger To Require a WHERE Clause

published 518 days, 9 hours, 39 minutes ago posted by

dhara 519 days, 20 hours, 35 minutes ago

The Problem I was working on an ERP project for an electrical company. As a DBA my main task was to maintain database security and data consistency. A database developer was appointed on the client side to maintain the database. By mistake the developer... (more)

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

tags: SQL Server, TSQL

7
Shouts

Shout it

Getting Started with SSRS - Part 9 - Creating Matrix Report with inbuilt styles in SSRS

published 518 days, 9 hours, 39 minutes ago posted by

dhara 519 days, 20 hours, 41 minutes ago

In this article we are going to see how to create a Matric Report with the help of the Report Wizard and Report Designer. In our earlier articles, we have covered how to design and deploy the report to the server with the option to design using the wizard and also with the report designer. However, in this article we are going to see how to make a matrix type report, since most of the business reports are developed based on the pivot format to analyze. (more)

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

tags: SQL Server, TSQL, BI, SSRS

8
Shouts

Shout it

Day 2: String aggregation in PostgreSQL

published 519 days, 14 hours, 12 minutes ago posted by

kinj312 520 days, 22 hours, 43 minutes ago

Aim: A query to show which employees works for which department Option 1: Using StringAgg function Purpose: This values helps to concatenate the input values into a string, separated by delimiter. We can pass any delimiter in this function Syntax: StringAgg... (more)

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

tags: SQL Server, TSQL

8
Shouts

Shout it

SQL Server 2012 (“Denali”) Licensing

published 519 days, 14 hours, 12 minutes ago posted by

kinj312 520 days, 22 hours, 44 minutes ago

Microsoft has posted the licensing for SQL Server 2012. It has simplified licensing: SQL Server 2012 will offer two licensing options – one that is based on computing power (“core based”), and one that is based on users or devices (“Server... (more)

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

tags: SQL Server, denali

8
Shouts

Shout it

System Reserved Partition and monitoring

published 519 days, 14 hours, 12 minutes ago posted by

kinj312 520 days, 22 hours, 59 minutes ago

On Windows 2008 R2 , a System Reserved Partition is created. It is 100 MB and acts as a preparatory step for implementing Bitlocker. The installation doesn’t install Bitlocker. BitLocker is a disk encryption method for full disk encryption. The System... (more)

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

tags: SQL Server, TSQL, Database

2
Shouts

Shout it

c# :- Class1 creates objects of Class2 and Class2 creates of Class1 what will happen ?

posted by

questpond 522 days, 22 hours, 2 minutes ago

c# :- Class1 creates objects of Class2 and Class2 creates of Class1 what will happen ? .NET and C# interview questions and OOP (more)

category: Web Dev | clicked: 5 | comment | | source: youtu.be

| flag as spam

tags: SQL Server, .NET and C# interview questions, OOP, Asp.Net Interview Question

8
Shouts

Shout it

SQL Server – Profiler – Part 6 – Correlating the Profiler Trace with Windows Performance Log Data

published 518 days, 9 hours, 39 minutes ago posted by

kinj312 524 days, 1 hour, 49 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. Five parts have been published till date, and for your kind reference, here are the links to them: What is a SQL... (more)

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

tags: SQL Server, TSQL

8
Shouts

Shout it

Where did my RDL.DATA files go?

published 519 days, 14 hours, 12 minutes ago posted by

kinj312 524 days, 1 hour, 50 minutes ago

Today morning, I was reading an old post on Clearing SSRS Query cache by Alex Whittles ( blog | twitter ). That is when I decided to try out something and opened up my most recent project to find some rdl.data files. Surprisingly, I did not find a single... (more)

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

tags: SQL Server, TSQL

8
Shouts

Shout it

SQL Server 2008 - Database Backup Compression, Amazing feature for DBA

published 519 days, 14 hours, 12 minutes ago posted by

kinj312 524 days, 1 hour, 50 minutes ago

Production Database servers may have databases which are heavily in size. For the maintenance of those database backups are very hard and lengthy as the backups of those heavily databases take more tome to execute and very CPU, memory and IO consumptive... (more)

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

tags: SQL Server, DBA, TSQL

7
Shouts

Shout it

Multipart names and keyboard shortcuts

published 519 days, 14 hours, 12 minutes ago posted by

dhara 525 days, 36 minutes ago

I had blogged about Different ways to know structure of the tables . One of the methods is to highlight the object name and press Alt+F1. But this will not work if the object name contains multiparts ie database name, owner name etc. Consider the following... (more)

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

tags: SQL Server, TSQL

7
Shouts

Shout it

DB2 Database code set

published 518 days, 9 hours, 39 minutes ago posted by

dhara 525 days, 36 minutes ago

The DB2 code set value defines the character encoding used by the database. Setting the appropriate value for translation, for example: Euro symbol and DB2 database codeset To get the DB2 database code set value, use: db2 get db cfg for MY_DB --From a... (more)

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

tags: SQL Server, TSQL, Database

7
Shouts

Shout it

Getting Started with SSRS - Part 8 -Show SSRS Report in ASP.NET Web Page

published 518 days, 9 hours, 39 minutes ago posted by

dhara 525 days, 37 minutes ago

In this article, we will cover how to use the deployed SSRS Report on to the ASP.NET Web application. In our earlier articles we have seen the steps to create and deploy the report to the Reporting Server and administer the deployed reports. In real time, we have seen requirements on accessing the reports from different clients. (more)

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

tags: SQL Server, TSQL, BI, SSRS

7
Shouts

Shout it

CONCAT() – SQL Server 2012

published 519 days, 14 hours, 12 minutes ago posted by

kinj312 526 days, 27 minutes ago

With SQL Server 2012 a new string function is born – CONCAT(). The output is a string, as the result of the concatenation of two or more strings – if the input is another type than string a conversion will be done implicit. The CONCAT() function takes... (more)

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

tags: SQL Server, denali, sql server 2012

7
Shouts

Shout it

Study of WAITSTATS(Part 5) - ASYNC_NETWORK_IO

published 519 days, 14 hours, 12 minutes ago posted by

kinj312 526 days, 28 minutes ago

ASYNCNETWORKIO, as the name suggests it is a wait type associated with the network. Infact it deals with the network buffers. Does it mean it is completely a network issue? - Never, it might be a network issue or not. However we need to check our end... (more)

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

tags: SQL Server, TSQL

9
Shouts

Shout it

Day 76: PL/SQL - 14 (Writing Dynamic SQL Queries in PL/SQL using Native Dynamic SQL(NDS))

published 519 days, 14 hours, 12 minutes ago posted by

dhara 527 days, 3 minutes ago

Sign in | JoinHomeBlogsAskJust LearnedPostswhat.isnew.inPuzzlesToolsQuizModules (beta) Getting Started with SSRS - Part 6 : Creating Deleting and Moving a folder in SSRS Server 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. niladri.biswasHomeRSS for PostsRecent Blog PostsDay 12: Math functions and operators in PostgreSQL...Day 11: Math functions and op... (more)

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

tags: SQL Server, PL/SQl, TSQL

9
Shouts

Shout it

TSQL Challenge 70 - Find the longest sequence of alphabets in a string – Part 2

published 519 days, 14 hours, 12 minutes ago posted by

dhara 527 days, 5 minutes ago

This challenge invites you to identify the longest sequence of alphabets from a string. This challenge is Version 2 of the TSQL Challenge 67. The difference is that in this version, you should apply circling while finding the longest sequence. (more)

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

tags: SQL Server, tsql challenges, TSQL

9
Shouts

Shout it

Getting Started with SSRS - Part 7 - User Roles and Permissions in SSRS Server

published 519 days, 14 hours, 12 minutes ago posted by

dhara 527 days, 5 minutes ago

In this article, we will see how to set user access roles and permissions for a specified user in SQL Server Reporting Services. User permissions in SSRS server is a big challenge for accessing the server for specified users. In this article, we will see how to add a new user role and provide permissions for the user to access particular components of the server reports. (more)

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

tags: SQL Server, TSQL, SSRS

Welcome!

SQL Server

Day 4: Find the Version of PostgreSQL

SQL Server – TempDB v/s Model database – Minimum size considerations – CREATE DATABASE - Error Msg 1803

Day 3: Overlay function in PostgreSQL

Automated Trigger To Require a WHERE Clause

Getting Started with SSRS - Part 9 - Creating Matrix Report with inbuilt styles in SSRS

Day 2: String aggregation in PostgreSQL

SQL Server 2012 (“Denali”) Licensing

System Reserved Partition and monitoring

c# :- Class1 creates objects of Class2 and Class2 creates of Class1 what will happen ?

SQL Server – Profiler – Part 6 – Correlating the Profiler Trace with Windows Performance Log Data

Where did my RDL.DATA files go?

SQL Server 2008 - Database Backup Compression, Amazing feature for DBA

Multipart names and keyboard shortcuts

DB2 Database code set

Getting Started with SSRS - Part 8 -Show SSRS Report in ASP.NET Web Page

CONCAT() – SQL Server 2012

Study of WAITSTATS(Part 5) - ASYNC_NETWORK_IO

Day 76: PL/SQL - 14 (Writing Dynamic SQL Queries in PL/SQL using Native Dynamic SQL(NDS))

TSQL Challenge 70 - Find the longest sequence of alphabets in a string – Part 2

Getting Started with SSRS - Part 7 - User Roles and Permissions in SSRS Server

Open ID Login

Standard Login

Forgot Password?

Sign up