DotNetShoutout - Stories tagged with SQL Server
7
Shouts

MSBI # 59 - SSIS # 23 – Data Flow Task # 9 - Audit Transformation Task- Detailed information & Explanation with example, Use & Properties

published 497 days, 7 hours, 26 minutes ago posted by dharadhara 498 days, 19 hours, 47 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
7
Shouts

SSAS #26 – SSRS and SSAS Integration: how bad it is and our hope with two types of data providers

published 497 days, 7 hours, 26 minutes ago posted by dharadhara 498 days, 19 hours, 48 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
9
Shouts

DB2 Tuning Tables

published 497 days, 7 hours, 26 minutes ago posted by kinj312kinj312 500 days, 20 hours, 16 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

Junk dimensions

published 497 days, 7 hours, 26 minutes ago posted by kinj312kinj312 500 days, 20 hours, 17 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

SQL Server - Database Backup Statistics and History

published 497 days, 7 hours, 26 minutes ago posted by kinj312kinj312 500 days, 20 hours, 17 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

SQL Server – SQL Agent – Jobs – Automatically delete SQL Server Agent jobs

published 499 days, 14 hours, 9 minutes ago posted by dharadhara 501 days, 20 hours, 22 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
9
Shouts

SQL Server - NOLOCK Hint & READ UNCOMMITTED Isolation level on table and Query/Session level

published 499 days, 14 hours, 9 minutes ago posted by kinj312kinj312 502 days, 18 hours, 1 minute 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

Getting started with SQL Azure - Part 4: SQL Azure's Architecture

published 499 days, 14 hours, 9 minutes ago posted by kinj312kinj312 502 days, 18 hours, 2 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
6
Shouts

Nic Teaming

published 503 days, 10 hours, 8 minutes ago posted by dharadhara 503 days, 18 hours, 27 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

MSSQL transaction log

published 501 days, 12 hours, 1 minute ago posted by dharadhara 503 days, 18 hours, 27 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
7
Shouts

MSBI # 55 - SSIS # 21 - Data Flow Task # 7 - All Transformation in Data Flow task (Introduction and Usage) {Part - VI}

published 503 days, 10 hours, 8 minutes ago posted by dharadhara 503 days, 18 hours, 28 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

MSBI # 53 - SSIS # 19 - Data Flow Task # 5 – All Transformation in Data Flow task (Introduction and Usage) {Part – IV}

published 503 days, 10 hours, 8 minutes ago posted by kinj312kinj312 504 days, 20 hours, 16 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

Always use ANSI joins for accuracy

published 503 days, 10 hours, 8 minutes ago posted by kinj312kinj312 504 days, 20 hours, 17 minutes ago
Wednesday, January 04, 2012 5:44:44 PM GMT Tuesday, January 03, 2012 7:35:42 AM GMT
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

Getting started with SQL Azure - Part 3: Provisioning and Billing Model of SQL Azure

published 503 days, 10 hours, 8 minutes ago posted by kinj312kinj312 504 days, 20 hours, 17 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
9
Shouts

SQL Traces and c2 auditing are different

published 501 days, 12 hours, 1 minute ago posted by kinj312kinj312 505 days, 17 hours, 26 minutes ago
Friday, January 06, 2012 3:51:12 PM GMT Monday, January 02, 2012 10:26:08 AM GMT
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
8
Shouts

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

published 501 days, 12 hours, 1 minute ago posted by kinj312kinj312 505 days, 17 hours, 28 minutes ago
Friday, January 06, 2012 3:51:12 PM GMT Monday, January 02, 2012 10:24:16 AM GMT
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
9
Shouts

Http POST or GET Method from MSSQL

published 499 days, 14 hours, 9 minutes ago posted by kinj312kinj312 508 days, 17 hours, 58 minutes ago
Sunday, January 08, 2012 1:43:59 PM GMT Friday, December 30, 2011 9:55:04 AM GMT
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

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

published 505 days, 17 hours, 19 minutes ago posted by kinj312kinj312 508 days, 18 hours ago
Monday, January 02, 2012 10:33:49 AM GMT Friday, December 30, 2011 9:52:37 AM GMT
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

SSIS #103 – Learn SSIS NOW

published 505 days, 17 hours, 19 minutes ago posted by dharadhara 509 days, 17 hours, 22 minutes ago
Monday, January 02, 2012 10:33:49 AM GMT Thursday, December 29, 2011 10:30:55 AM GMT
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
7
Shouts

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

published 505 days, 17 hours, 19 minutes ago posted by dharadhara 509 days, 17 hours, 23 minutes ago
Monday, January 02, 2012 10:33:49 AM GMT Thursday, December 29, 2011 10:29:59 AM GMT
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
Previous 1 2 3 4 5 6 7 8 9 10 ... 43 44 Next