kinj312

kinj312
Name: kinj312
Score: 2,488.52
Last Seen: 409 days, 10 hours, 47 minutes ago
Member Since: 26 October, 2010
DotNetShoutout
atom rss
10
Shouts
spam Shout it Mute it

Data Loading Performance Guide
published 528 days, 4 hours, 5 minutes ago posted by kinj312kinj312 531 days, 10 hours, 9 minutes ago
Tuesday, December 13, 2011 2:39:39 PM GMT Saturday, December 10, 2011 8:35:50 AM GMT
Bulk loading with large amounts of data requires strategy. The Data Loading Performance Guide for SQL Server 2008 and SQL Server 2005 is a very useful document. Highlights Understanding Minimally Logged Operations Trace Flag 610 (sql server 2008) Summarizing... (more)
category: Data | clicked: 28 | 1 comment | | source: beyondrelational.com
tags: SQL Server, Database
10
Shouts
spam Shout it Mute it

WCF # 10 – WCF channel shapes and communication patterns (Message exchange patterns)
published 528 days, 4 hours, 5 minutes ago posted by kinj312kinj312 531 days, 10 hours, 9 minutes ago
Tuesday, December 13, 2011 2:39:39 PM GMT Saturday, December 10, 2011 8:35:31 AM GMT
Hi Geek, In our last post Channels , we see how messages are exchange in WCF using channels , In this post we will see the types of message exchange patterns in WCF . WCF supports three distinct message-exchange patterns: 1) One Way 2) Duplex 3) Request... (more)
category: Web Dev | clicked: 16 | comment | | source: beyondrelational.com
tags: .NET, WCF, ASP.NET
6
Shouts
spam Shout it Mute it

MS DTC and sys.dm_tran_active_transactions
published 530 days, 6 hours, 32 minutes ago posted by kinj312kinj312 533 days, 9 hours, 4 minutes ago
Sunday, December 11, 2011 12:12:15 PM GMT Thursday, December 08, 2011 9:40:28 AM GMT
A sql reindex command was being blocked by two active transactions in MS DTC. Use sys.dmtranactivetransactions to report more detail on transactions select * from sys.dmtranactivetransactions where transaction_uow = '922D5B60-A5CA-4C96-8891... (more)
category: Data | clicked: 5 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
7
Shouts
spam Shout it Mute it

Day 72: Synonym in Oracle
published 530 days, 6 hours, 32 minutes ago posted by kinj312kinj312 533 days, 9 hours, 5 minutes ago
Sunday, December 11, 2011 12:12:15 PM GMT Thursday, December 08, 2011 9:39:57 AM GMT
Purpose: It is an alternative name/alias assigned to the objects like views, sequences, stored procedures etc. Syntax Create [or Replace] [Public] Synonym [Schema .] SynonymName For [schema .] objectname [@ dblink]; It is an alias for the following... (more)
category: Data | clicked: 4 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL, Oracle
7
Shouts
spam Shout it Mute it

Getting Started with SSRS - Part 6 - Creating, Deleting and Moving a folder in SSRS Server
published 530 days, 6 hours, 32 minutes ago posted by kinj312kinj312 533 days, 9 hours, 9 minutes ago
Sunday, December 11, 2011 12:12:15 PM GMT Thursday, December 08, 2011 9:35:26 AM GMT
In this article we are going to see how to manage the folders in Reporting Server. In our earlier articles we have seen how to create and deploy a report to the reporting server. We have seen cases where we need to manage the reports based on the requirement like moving a report to a folder and take a backup. (more)
category: Data | clicked: 2 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL, BI, SSRS
9
Shouts
spam Shout it Mute it

Choosing binding for WCF service
published 533 days, 14 hours, 18 minutes ago posted by kinj312kinj312 534 days, 9 hours, 51 minutes ago
Thursday, December 08, 2011 4:26:26 AM GMT Wednesday, December 07, 2011 8:53:58 AM GMT
There are different types of bindings supported by WCF. Now question is which binding is suitable for your service.Following is list of frequently used bindings in WCF: BasicHttpBinding : If clients can be non-WCF. This exposes service to the outside... (more)
category: Web Dev | clicked: 25 | 1 comment | | source: beyondrelational.com
tags: .NET, WCF, ASP.NET
8
Shouts
spam Shout it Mute it

Difference between TcpBinding and HttpDualBinding for Callback in WCF
published 533 days, 14 hours, 18 minutes ago posted by kinj312kinj312 534 days, 9 hours, 51 minutes ago
Thursday, December 08, 2011 4:26:26 AM GMT Wednesday, December 07, 2011 8:53:32 AM GMT
The Http bindings serialized messages into XML and send them via HTTP. HTTP is request response protocol, which is one way communication at a time. Caller sends requests to the server and server responds and sends response messages. Once the response... (more)
category: Web Dev | clicked: 16 | comment | | source: beyondrelational.com
tags: .NET, WCF, ASP.NET
8
Shouts
spam Shout it Mute it

SQL Server – Profiler – Part 4 – Review T-SQL code to identify objects no longer supported by Microsoft - Deprecation Event
published 533 days, 14 hours, 18 minutes ago posted by kinj312kinj312 534 days, 9 hours, 52 minutes ago
Thursday, December 08, 2011 4:26:26 AM GMT Wednesday, December 07, 2011 8:53:04 AM GMT
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. Three 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: 4 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
9
Shouts
spam Shout it Mute it

Day 71: Sequence in Oracle
published 533 days, 14 hours, 18 minutes ago posted by kinj312kinj312 535 days, 10 hours, 54 minutes ago
Thursday, December 08, 2011 4:26:26 AM GMT Tuesday, December 06, 2011 7:50:18 AM GMT
Purpose: Generates auto number field in tables. Syntax CREATE SEQUENCE sequence_name MINVALUE value MAXVALUE value START WITH value INCREMENT BY value CACHE value; We can create a sequence as under SQL> CREATE SEQUENCE MySequence 2 MINVALUE 1 3 MAXVALUE... (more)
category: Data | clicked: 29 | 1 comment | | source: beyondrelational.com
tags: SQL Server, Oracle
7
Shouts
spam Shout it Mute it

Linux Server OS information
published 533 days, 14 hours, 18 minutes ago posted by kinj312kinj312 535 days, 10 hours, 55 minutes ago
Thursday, December 08, 2011 4:26:26 AM GMT Tuesday, December 06, 2011 7:49:43 AM GMT
The following commands are useful to gather Linux server information . The Linux system information is useful for such scenarios as: a) The Server Engineer requests a spec for a new Linux server build from the DBA. b) Collating inventory information for... (more)
category: Data | clicked: 10 | comment | | source: beyondrelational.com
tags: Linux, SQL Server
7
Shouts
spam Shout it Mute it

ALTER INDEX permissions
published 533 days, 14 hours, 18 minutes ago posted by kinj312kinj312 535 days, 10 hours, 55 minutes ago
Thursday, December 08, 2011 4:26:26 AM GMT Tuesday, December 06, 2011 7:49:23 AM GMT
Developers like to have some control over the development process. An example is index building. Asking a DBA repeatedly for changes to a Development Database might not be the best use of time – for either parties. For example, a developer may want to... (more)
category: Data | clicked: 5 | comment | | source: beyondrelational.com
tags: SQL Server, DBA, TSQL
8
Shouts
spam Shout it Mute it

Getting Started with SSRS - Part 5 - Deploying a report to the Server
published 533 days, 14 hours, 18 minutes ago posted by kinj312kinj312 535 days, 10 hours, 56 minutes ago
Thursday, December 08, 2011 4:26:26 AM GMT Tuesday, December 06, 2011 7:48:38 AM GMT
In our earlier articles, we have seen how to design a report and connect to the database to pull out the values based on the requirement to be shown in the report. Also, we have seen the configuration section on how to configure the SQL Server Reporting Services manually by providing the Report Server name. (more)
category: Data | clicked: 5 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL, BI, SSRS
7
Shouts
spam Shout it Mute it

Day 70: Dual table in Oracle
published 533 days, 14 hours, 18 minutes ago posted by kinj312kinj312 536 days, 8 hours, 13 minutes ago
Thursday, December 08, 2011 4:26:26 AM GMT Monday, December 05, 2011 10:31:08 AM GMT
Purpose: It is a dummy table in Oracle with one row and one Varchar2 column whose length is 1. It's structure looks as under SQL> Desc Dual; Name Null? Type ----------------------------------------- -------- ------------- DUMMY VARCHAR2(1) The... (more)
category: Data | clicked: 1 | comment | | source: beyondrelational.com
tags: SQL Server, Oracle
9
Shouts
spam Shout it Mute it

Aggregate functions always return at least a row although table is empty
published 533 days, 14 hours, 18 minutes ago posted by kinj312kinj312 536 days, 8 hours, 14 minutes ago
Thursday, December 08, 2011 4:26:26 AM GMT Monday, December 05, 2011 10:30:27 AM GMT
There are many aggregate functions available in SQL Server. One thing that most of the people forget is that Aggregate functions always return atleast a row no matter if there are rows in the table or where clause returns or does not return any resultset... (more)
category: Data | clicked: 15 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
9
Shouts
spam Shout it Mute it

SQL Server 2012: Service Accounts Changes
published 533 days, 14 hours, 18 minutes ago posted by kinj312kinj312 536 days, 8 hours, 15 minutes ago
Thursday, December 08, 2011 4:26:26 AM GMT Monday, December 05, 2011 10:29:13 AM GMT
After SQL Server 2012 RC0 installation I noticed a few changes in SQL Server services account configuration. In previous versions (SQL Server 2005 and 2008/R2) during stand-alone SQL Server installation, local Windows group is created and service account... (more)
category: Data | clicked: 13 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
7
Shouts
spam Shout it Mute it

Monitoring a Rollback and sys.dm_exec_requests
published 533 days, 14 hours, 18 minutes ago posted by kinj312kinj312 538 days, 11 hours, 28 minutes ago
Thursday, December 08, 2011 4:26:26 AM GMT Saturday, December 03, 2011 7:16:56 AM GMT
The dynamic management view ( DMV ) sys.dmexecrequests returns information about each request that is executing within SQL Server. Instead of using Activity Monitor to view the status of a Rollback, use this T-SQL code . Activity monitor is based on... (more)
category: Data | clicked: 10 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

SQL Server trace flags
published 533 days, 14 hours, 18 minutes ago posted by kinj312kinj312 538 days, 11 hours, 28 minutes ago
Thursday, December 08, 2011 4:26:26 AM GMT Saturday, December 03, 2011 7:16:24 AM GMT
Normally I’m not a big fan of using traceflags, my advice is only to use these when it is absolutely necessary otherwise don’t. Here is a list of the documented traceflags that you can use with SQL Server. That is the documented once, besides that there... (more)
category: Data | clicked: 4 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

Day 69: SOUNDEX function in Oracle
published 533 days, 14 hours, 18 minutes ago posted by kinj312kinj312 538 days, 11 hours, 30 minutes ago
Thursday, December 08, 2011 4:26:26 AM GMT Saturday, December 03, 2011 7:14:19 AM GMT
Purpose: It compares the field values that sounds like the supplied input word. Syntax: SOUNDEX(Value to compare) SQL> Select * From tblPlayers 2 Where Soundex(BELONGSTO) = Soundex('Lindia'); PLAYERID PLAYERFIRS PLAYERLAST BELONGSTO DOB FEEPERMATCH... (more)
category: Data | clicked: 1 | comment | | source: beyondrelational.com
tags: SQL Server, Oracle
8
Shouts
spam Shout it Mute it

Getting Started with SSRS - Part 4 - Configuring SQL Server Reporting Services in Windows Server 2008
published 533 days, 14 hours, 18 minutes ago posted by kinj312kinj312 539 days, 8 hours, 46 minutes ago
Thursday, December 08, 2011 4:26:26 AM GMT Friday, December 02, 2011 9:58:48 AM GMT
In our previous articles, we have seen how to install SQL Server Reporting Services and to create a new report using the Report Wizard and Report Designer Window. Now, in this article we are going to see how to configure SQL Server Reporting Services in Windows Server 2008 environment. (more)
category: Data | clicked: 5 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL, BI, SSRS
9
Shouts
spam Shout it Mute it

SQL SERVER: Develop Reports with RDLC (Asp.Net)
published 533 days, 14 hours, 18 minutes ago posted by kinj312kinj312 539 days, 8 hours, 46 minutes ago
Thursday, December 08, 2011 4:26:26 AM GMT Friday, December 02, 2011 9:58:17 AM GMT
As, I mentioned in my post, Load Reports without SQL SERVER Reporting Service with Asp.Net , we can develop a report without SQL SERVER Reporting Service. That is very simple to do with Microsoft Visual Studio. Please follow the following steps to generate... (more)
category: Web Dev | clicked: 10 | 1 comment | | source: beyondrelational.com
tags: SQL Server, RDLC, ASP.NET
Previous 1 2 3 4 5 6 7 8 9 10 11 Next