jacobsebastian

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

Getting started with SQL Azure - Part 5: SQL Azure's Security Model
published 497 days, 17 hours, 46 minutes ago posted by kinj312kinj312 498 days, 3 hours, 3 minutes ago
Tuesday, January 10, 2012 8:26:19 PM GMT Tuesday, January 10, 2012 11:09:55 AM GMT
In this article, we are going to explore the security model of SQL Azure. Following are the topics that we are going to cover: 1. SQL Azure Firewall 2. Authentication 3. Authorization [Logins and Users] 4. Encryption and SQL Azure (more)
category: Data | clicked: 20 | comment | | source: beyondrelational.com
tags: SQL Server, SQL Azure, Azure
7
Shouts
spam Shout it Mute it

SQL Server 2012 – new conversion functions
published 497 days, 17 hours, 46 minutes ago posted by kinj312kinj312 498 days, 3 hours, 1 minute ago
Tuesday, January 10, 2012 8:26:19 PM GMT Tuesday, January 10, 2012 11:11:07 AM GMT
With SQL Server 2012 comes a new set of conversion functions , that will certainly help doing type casts and conversions in t-sql. These functions are: TRYPARSE TRYCONVERT PARSE TRYPARSE() Syntax from BOL: TRYPARSE ( stringvalue AS datatype [ USING... (more)
category: Data | clicked: 16 | comment | | source: beyondrelational.com
tags: SQL Server, denali, sql server 2012
8
Shouts
spam Shout it Mute it

WCF # 11–WCF Channel Objects [WCF Channel Listeners,WCF Factories]
published 497 days, 17 hours, 46 minutes ago posted by kinj312kinj312 498 days, 3 hours, 2 minutes ago
Tuesday, January 10, 2012 8:26:19 PM GMT Tuesday, January 10, 2012 11:10:35 AM GMT
Hi Geeks, In our last post Channel shapes and Communication Patterns we saw how channels are used to transform message from client to server and vice versa. Today we will see Channel Objects and how they work . There are three categories of channel objects... (more)
category: Web Dev | clicked: 14 | comment | | source: beyondrelational.com
tags: .NET, WCF, ASP.NET
7
Shouts
spam Shout it Mute it

SSAS #26 – SSRS and SSAS Integration: how bad it is and our hope with two types of data providers
published 497 days, 17 hours, 46 minutes ago posted by dharadhara 499 days, 6 hours, 8 minutes ago
Tuesday, January 10, 2012 8:26:19 PM GMT Monday, January 09, 2012 8:04:19 AM GMT
A few months ago, I had a post, SSAS #21 – Steps to create a SSRS report with MDX accessing a Cube . If you have worked on creating SSRS reports accessing cubes for a little while, you already knew that my post really doesn’t help you much... (more)
category: Data | clicked: 8 | 2 comments | | source: beyondrelational.com
tags: SQL Server, SSAS, TSQL, BI
7
Shouts
spam Shout it Mute it

Implement Role based security using Windows Groups in WCF
published 497 days, 17 hours, 46 minutes ago posted by dharadhara 499 days, 6 hours, 8 minutes ago
Tuesday, January 10, 2012 8:26:19 PM GMT Monday, January 09, 2012 8:04:47 AM GMT
This is third blog on security concept in WCF. You can read previous posts: Something about Security in WCF- I Implement windows authentication and security in WCF Service Today I’ll describe how we can implement role based authorization using Windows... (more)
category: Web Dev | clicked: 43 | 1 comment | | source: beyondrelational.com
tags: .NET, WCF, ASP.NET
7
Shouts
spam Shout it Mute it

MSBI # 59 - SSIS # 23 – Data Flow Task # 9 - Audit Transformation Task- Detailed information & Explanation with example, Use & Properties
published 497 days, 17 hours, 46 minutes ago posted by dharadhara 499 days, 6 hours, 7 minutes ago
Tuesday, January 10, 2012 8:26:19 PM GMT Monday, January 09, 2012 8:05:17 AM GMT
Hi friends I have started explaining each Data flow task, i.e continuing from my last as well as link MSBI # 55 – SSIS # 21 – Data Flow Task # 7 – All Transformation in Data Flow task MSBI # 57 – SSIS # 22 – Data Flow Task # 8 – Aggregate Transformation... (more)
category: Data | clicked: 8 | comment | | source: beyondrelational.com
tags: SQL Server, MSBI, TSQL, BI
9
Shouts
spam Shout it Mute it

DB2 Tuning Tables
published 497 days, 17 hours, 46 minutes ago posted by kinj312kinj312 501 days, 6 hours, 36 minutes ago
Tuesday, January 10, 2012 8:26:19 PM GMT Saturday, January 07, 2012 7:36:24 AM GMT
Find bottlenecks in DB2 performance is part of maintaining good response times. Here's a useful approach to locating slow query response times. Focusing on scans 1) Run a “user level” workload and check “get snapshot for database” . Add “Rollback... (more)
category: Data | clicked: 10 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
9
Shouts
spam Shout it Mute it

Junk dimensions
published 497 days, 17 hours, 46 minutes ago posted by kinj312kinj312 501 days, 6 hours, 36 minutes ago
Tuesday, January 10, 2012 8:26:19 PM GMT Saturday, January 07, 2012 7:36:02 AM GMT
Junk dimensions are dimensions that contain miscellaneous data such as flags and indicators. When designing a data warehouse, you might come across a source system that has a bunch of yes/no indicator fields. If those fields needs to be tracked in a fact... (more)
category: Data | clicked: 25 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
9
Shouts
spam Shout it Mute it

SQL Server - Database Backup Statistics and History
published 497 days, 17 hours, 46 minutes ago posted by kinj312kinj312 501 days, 6 hours, 37 minutes ago
Tuesday, January 10, 2012 8:26:19 PM GMT Saturday, January 07, 2012 7:35:41 AM GMT
Every DBA has a daily activity review or monitor database backups as these database backups used for the restoration at other place and using for the database restore which used for reporting purpose or used in log shipping purpose. Because database backups... (more)
category: Data | clicked: 29 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL, Database
8
Shouts
spam Shout it Mute it

The Dark Side of Covariance
published 500 days, 29 minutes ago posted by dharadhara 502 days, 6 hours, 41 minutes ago
Sunday, January 08, 2012 1:43:59 PM GMT Friday, January 06, 2012 7:31:31 AM GMT
What’s wrong with the following code? var names = new HashSet (more)
category: Web Dev | clicked: 37 | 1 comment | | source: beyondrelational.com
tags: .NET, ASP .NET
8
Shouts
spam Shout it Mute it

SQL Server – SQL Agent – Jobs – Automatically delete SQL Server Agent jobs
published 500 days, 29 minutes ago posted by dharadhara 502 days, 6 hours, 42 minutes ago
Sunday, January 08, 2012 1:43:59 PM GMT Friday, January 06, 2012 7:30:43 AM GMT
I would start today’s post with a question – Have you ever faced a requirement to delete a job once it successfully completes? Once I had to achieve just that – a SQL Server job had to be created, and the requirement was to delete the job after it’s execution... (more)
category: Data | clicked: 8 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
8
Shouts
spam Shout it Mute it

Implement windows authentication and security in WCF Service
published 500 days, 29 minutes ago posted by dharadhara 502 days, 6 hours, 42 minutes ago
Sunday, January 08, 2012 1:43:59 PM GMT Friday, January 06, 2012 7:30:16 AM GMT
This is continuation with previous post on “Security in WCF -I”. Here I’ll explain how we can implement windows authentication with transport level security in intranet environment. Windows authentication In intranet environment, client and service are... (more)
category: Web Dev | clicked: 32 | comment | | source: beyondrelational.com
tags: .NET, WCF, ASP.NET
9
Shouts
spam Shout it Mute it

SQL Server - NOLOCK Hint & READ UNCOMMITTED Isolation level on table and Query/Session level
published 500 days, 29 minutes ago posted by kinj312kinj312 503 days, 4 hours, 21 minutes ago
Sunday, January 08, 2012 1:43:59 PM GMT Thursday, January 05, 2012 9:51:33 AM GMT
When we created a new database it will be created with default isolation level and that is "READ COMMITTED". If some update transactions are running in with table rows under READ COMMITTED isolation level, How can we get data from table in another... (more)
category: Data | clicked: 9 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
9
Shouts
spam Shout it Mute it

Something about Security in WCF- I
published 500 days, 29 minutes ago posted by kinj312kinj312 503 days, 4 hours, 21 minutes ago
Sunday, January 08, 2012 1:43:59 PM GMT Thursday, January 05, 2012 9:51:09 AM GMT
Authentication and authorization are key aspects for secure communication between client and server. The service needs to authenticate its callers and correspondingly allow to use allowed operations. Service level authentication is not only thing for... (more)
category: Web Dev | clicked: 35 | 1 comment | | source: beyondrelational.com
tags: .NET, WCF, ASP.NET
9
Shouts
spam Shout it Mute it

Getting started with SQL Azure - Part 4: SQL Azure's Architecture
published 500 days, 29 minutes ago posted by kinj312kinj312 503 days, 4 hours, 22 minutes ago
Sunday, January 08, 2012 1:43:59 PM GMT Thursday, January 05, 2012 9:50:42 AM GMT
In this article, we are going to discuss the SQL Azure Architecture and see what happens inside SQL Azure. (more)
category: Data | clicked: 30 | 1 comment | | source: beyondrelational.com
tags: SQL Server, SQL Azure, Azure
7
Shouts
spam Shout it Mute it

MSBI # 55 - SSIS # 21 - Data Flow Task # 7 - All Transformation in Data Flow task (Introduction and Usage) {Part - VI}
published 503 days, 20 hours, 28 minutes ago posted by dharadhara 504 days, 4 hours, 47 minutes ago
Wednesday, January 04, 2012 5:44:44 PM GMT Wednesday, January 04, 2012 9:25:03 AM GMT
Hi friends , As I am getting more time today I want to utilized same for blogging only !! Today only I have completed 2 post which is in series of All Transformation in Data Flow task So here is complete sequence form my last continuing post MSBI # 36... (more)
category: Data | clicked: 22 | comment | | source: beyondrelational.com
tags: SQL Server, MSBI, TSQL, SSIS
8
Shouts
spam Shout it Mute it

MSSQL transaction log
published 501 days, 22 hours, 21 minutes ago posted by dharadhara 504 days, 4 hours, 47 minutes ago
Friday, January 06, 2012 3:51:12 PM GMT Wednesday, January 04, 2012 9:25:23 AM GMT
It is good if you backed up the LOG file also when we take the full backup of the database. If you are not backed up the .LDF file or LOG then it will become huge and occupy the large number of space, if you need to clean up the transaction log. Follow... (more)
category: Data | clicked: 11 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

Nic Teaming
published 503 days, 20 hours, 28 minutes ago posted by dharadhara 504 days, 4 hours, 47 minutes ago
Wednesday, January 04, 2012 5:44:44 PM GMT Wednesday, January 04, 2012 9:25:49 AM GMT
Network card teaming or NIC teaming are networking terms describing methods of combining multiple parallel network connections . The main purposes are 1) increasing throughput beyond a single connection and 2) redundancy. The three main teaming configurations... (more)
category: Data | clicked: 9 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL, Database
8
Shouts
spam Shout it Mute it

MSBI # 53 - SSIS # 19 - Data Flow Task # 5 – All Transformation in Data Flow task (Introduction and Usage) {Part – IV}
published 503 days, 20 hours, 28 minutes ago posted by kinj312kinj312 505 days, 6 hours, 36 minutes ago
Wednesday, January 04, 2012 5:44:44 PM GMT Tuesday, January 03, 2012 7:36:12 AM GMT
Hi Folks, Its has been very long time I have not posted on SSIS,Some of my reader really wan me to post only on SSIS really thanks to all of your comment. Now lets continuing form my last post on basics of Data flow task in which we have covered following... (more)
category: Data | clicked: 14 | comment | | source: beyondrelational.com
tags: SQL Server, MSBI, TSQL, SSIS, BI
8
Shouts
spam Shout it Mute it

Getting started with SQL Azure - Part 3: Provisioning and Billing Model of SQL Azure
published 503 days, 20 hours, 28 minutes ago posted by kinj312kinj312 505 days, 6 hours, 37 minutes ago
Wednesday, January 04, 2012 5:44:44 PM GMT Tuesday, January 03, 2012 7:35:21 AM GMT
In this article, we are going to discuss the SQL Azure Provisioning Model and then we will talk about SQL Azure Billing Model. So first, let's start with Provisioning Model of SQL Azure. This is what the model looks like diagrammatically: (more)
category: Data | clicked: 12 | 1 comment | | source: beyondrelational.com
tags: SQL Server, SQL Azure, Azure
Previous 1 2 3 4 5 6 7 8 9 10 ... 55 56 Next