Database Development
|
| SQL Server |
23 Jun 2011
Updated: 23 Jun 2011
Rating: 4.61/5
Votes: 31
Popularity: 6.88
Licence: CPOL
Views: 171,878
Bookmarked: 57
Downloaded: 0
An article on replication in MS SQL Server
|
|
22 Dec 2011
Updated: 22 Dec 2011
Rating: 0.00/5
Votes: 0
Popularity: 0.00
Licence: CPOL
Views: 12,810
Bookmarked: 6
Downloaded: 0
This demo session demonstrates a little POC as to how can you make your SSIS talk to you.
|
|
6 Jan 2012
Updated: 6 Jan 2012
Rating: 3.00/5
Votes: 2
Popularity: 0.90
Licence: CPOL
Views: 32,862
Bookmarked: 5
Downloaded: 0
This video demonstrates a standard extract-transform-load in SSIS
|
|
25 Feb 2011
Updated: 25 Feb 2011
Rating: 4.60/5
Votes: 5
Popularity: 3.22
Licence: CPOL
Views: 18,540
Bookmarked: 19
Downloaded: 0
A very exciting feature in Microsoft SQL Server
|
|
28 Feb 2011
Updated: 28 Feb 2011
Rating: 4.64/5
Votes: 7
Popularity: 3.92
Licence: CPOL
Views: 30,971
Bookmarked: 22
Downloaded: 0
Monitoring Free Space on Microsoft SQL Server
|
|
8 Mar 2011
Updated: 8 Mar 2011
Rating: 4.80/5
Votes: 14
Popularity: 5.50
Licence: CPOL
Views: 90,022
Bookmarked: 29
Downloaded: 0
CDC is a new feature for logging DML changes. In this article, we will see how CDC could be put to use and how efficiently it could serve our purpose.
|
|
8 Mar 2011
Updated: 8 Mar 2011
Rating: 4.71/5
Votes: 6
Popularity: 3.67
Licence: CPOL
Views: 80,335
Bookmarked: 22
Downloaded: 0
An important new feature of MS SQL Server 2008 that provides a true auditing solution - SQL Server Audit.
|
|
11 Mar 2011
Updated: 11 Mar 2011
Rating: 4.50/5
Votes: 3
Popularity: 2.15
Licence: CPOL
Views: 41,340
Bookmarked: 10
Downloaded: 0
How the Copy Database Wizard can be helpful to users working on upgrades and migration projects.
|
|
2 May 2011
Updated: 2 May 2011
Rating: 4.84/5
Votes: 72
Popularity: 8.97
Licence: CPOL
Views: 306,466
Bookmarked: 102
Downloaded: 0
This article focuses on how MS SQL Server uses indexes to read and write data.
|
|
13 May 2011
Updated: 13 May 2011
Rating: 4.50/5
Votes: 3
Popularity: 2.15
Licence: CPOL
Views: 31,432
Bookmarked: 5
Downloaded: 0
SQL Server 2008 provides a very efficient SQL policy administrator which constantly monitors the server and reports errors appropriately. Administrators can define policies and ensure that they are being adhered to by evaluating the policies.
|
|
26 May 2011
Updated: 26 May 2011
Rating: 4.60/5
Votes: 4
Popularity: 2.77
Licence: CPOL
Views: 23,294
Bookmarked: 8
Downloaded: 0
Through this video I have tried to explain the concept of log shipping in MS SQL Server. It's broken into 2 parts, this is the first part.
|
|
26 May 2011
Updated: 26 May 2011
Rating: 0.00/5
Votes: 0
Popularity: 0.00
Licence: CPOL
Views: 18,120
Bookmarked: 2
Downloaded: 0
Through this video I have tried to explain the concept of log shipping in MS SQL Server. It's broken into 2 parts, this is the second part.
|
|
9 Jun 2011
Updated: 9 Jun 2011
Rating: 4.13/5
Votes: 5
Popularity: 2.89
Licence: CPOL
Views: 19,340
Bookmarked: 24
Downloaded: 0
Mirroring is the best database fail over option used by the SQL Server DBAs today. I hope this contribution adds little value to the beginner level DBAs.
|
|
9 Jun 2011
Updated: 9 Jun 2011
Rating: 4.13/5
Votes: 5
Popularity: 2.89
Licence: CPOL
Views: 17,101
Bookmarked: 16
Downloaded: 0
Mirroring is the best database fail over option used by the SQL Server DBAs today. I hope this contribution adds little value to the beginner level DBAs.
|
|
14 Jun 2011
Updated: 14 Jun 2011
Rating: 4.63/5
Votes: 19
Popularity: 5.92
Licence: CPOL
Views: 75,851
Bookmarked: 29
Downloaded: 0
An introduction to the database snapshot functionality in MS SQL Server. It is one of the important tools used for generating data for reporting purposes.
|
|
15 Jul 2011
Updated: 15 Jul 2011
Rating: 4.50/5
Votes: 4
Popularity: 2.71
Licence: CPOL
Views: 20,710
Bookmarked: 7
Downloaded: 0
This article is nothing but a very critical real time scenario that I have faced for a Delta Derivation warehousing project where I found the newly incorporated Merge keyword in SQL Server of immense importance.
|
|
11 Oct 2011
Updated: 11 Oct 2011
Rating: 4.81/5
Votes: 31
Popularity: 7.10
Licence: CPOL
Views: 205,179
Bookmarked: 36
Downloaded: 0
Views In SQL Server
|
|
1 Nov 2011
Updated: 1 Nov 2011
Rating: 4.87/5
Votes: 38
Popularity: 7.46
Licence: CPOL
Views: 231,274
Bookmarked: 40
Downloaded: 0
CTE In SQL Server
|
|
6 Jan 2012
Updated: 6 Jan 2012
Rating: 4.33/5
Votes: 2
Popularity: 1.30
Licence: CPOL
Views: 17,430
Bookmarked: 7
Downloaded: 0
This video explores how we can setup a system to detect issues when, my replication fails or SQL Job fails or there is an alert fired.
|
|
2 Apr 2012
Updated: 2 Apr 2012
Rating: 4.75/5
Votes: 4
Popularity: 2.86
Licence: CPOL
Views: 27,220
Bookmarked: 17
Downloaded: 0
This is a technical article for new bees on how to upload/update/download files (picture/mp3/excel/doc) into sql server database.
|
|
2 Apr 2012
Updated: 2 Apr 2012
Rating: 3.75/5
Votes: 4
Popularity: 2.26
Licence: CPOL
Views: 23,241
Bookmarked: 6
Downloaded: 0
This video describes how to generate table scripts with/without data in SQL Server 2008.
|
|
2 Apr 2012
Updated: 2 Apr 2012
Rating: 4.17/5
Votes: 3
Popularity: 1.99
Licence: CPOL
Views: 14,701
Bookmarked: 11
Downloaded: 0
This video discusses a typical scenario where mirroring and replication happens hand in hand on the same database. It is important for those who implement mirroring as high availability solution for their database and also replicate/publish some articles (tables). There are certain settings which al
|
Productivity Apps and Services
|
| Microsoft Office |
16 Dec 2011
Updated: 16 Dec 2011
Rating: 4.86/5
Votes: 7
Popularity: 4.10
Licence: CPOL
Views: 51,741
Bookmarked: 12
Downloaded: 0
In this video article
|
Programming Languages
|
| SQL |
7 Aug 2012
Updated: 7 Aug 2012
Rating: 4.00/5
Votes: 3
Popularity: 1.91
Licence: CPOL
Views: 27,762
Bookmarked: 5
Downloaded: 0
This is a very simple and brief video on variables, expression and casting of them in SSIS. It will also teach developers to pass result sets in SQL task.
|
|
2 Apr 2012
Updated: 2 Apr 2012
Rating: 3.00/5
Votes: 3
Popularity: 1.43
Licence: CPOL
Views: 13,270
Bookmarked: 4
Downloaded: 0
In this video you will learn to make adhoc reports on the fly with the help of MS excel. You will be able to connect to SQL Server Databases or SQL Server Analysis Server Cubes and generate reports for specific business
|
SSIS
|
|
19 Dec 2011
Updated: 19 Dec 2011
Rating: 3.89/5
Votes: 2
Popularity: 1.17
Licence: CPOL
Views: 32,702
Bookmarked: 7
Downloaded: 0
Dynamically export data to Flat File using SSIS
|
|
21 Dec 2011
Updated: 21 Dec 2011
Rating: 4.17/5
Votes: 6
Popularity: 3.24
Licence: CPOL
Views: 23,193
Bookmarked: 4
Downloaded: 0
This video shows the essence of parallel processing in SSIS.
|
|
23 Dec 2011
Updated: 23 Dec 2011
Rating: 2.38/5
Votes: 5
Popularity: 1.67
Licence: CPOL
Views: 37,621
Bookmarked: 5
Downloaded: 0
In this video you will learn to deploy SSIS package in both SQL Server (MSDB) format and File System format
|
|
23 Dec 2011
Updated: 23 Dec 2011
Rating: 5.00/5
Votes: 3
Popularity: 2.39
Licence: CPOL
Views: 25,751
Bookmarked: 2
Downloaded: 0
This article describes how to pass values from parent package to a child in SSIS.
|
|
7 Aug 2012
Updated: 7 Aug 2012
Rating: 4.00/5
Votes: 1
Popularity: 0.00
Licence: CPOL
Views: 38,160
Bookmarked: 7
Downloaded: 0
This video introduces Package Configurations to the SSIS developers, you will learn: XML Configuration a.) Direct b.) Indirect (Using Environment Variables), Environment Variables, and SQL Server Configuration
|
|
30 Aug 2012
Updated: 30 Aug 2012
Rating: 5.00/5
Votes: 2
Popularity: 1.51
Licence: CPOL
Views: 26,182
Bookmarked: 3
Downloaded: 0
This SSIS training video will explain data viewers.
|
|
30 Aug 2012
Updated: 30 Aug 2012
Rating: 5.00/5
Votes: 2
Popularity: 1.51
Licence: CPOL
Views: 15,790
Bookmarked: 4
Downloaded: 0
This video explains conditional split transformation for SSIS.
|
Submit an article or tip