tag:blogger.com,1999:blog-33967696212189517602024-03-13T12:26:39.771-07:00T-SQL/MSBI Knowledge Share Sreehari Katagerihttp://www.blogger.com/profile/13938254162453228472noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-3396769621218951760.post-39011954912657371462014-09-03T11:56:00.001-07:002014-09-03T11:56:40.085-07:00TSQL/MSBI Knowledge Share: Load Multiple Excel Sheet Data to Table<iframe allowfullscreen="" frameborder="0" height="270" src="//www.youtube.com/embed/GbfkIqhliAg" width="480"></iframe>Sreehari Katagerihttp://www.blogger.com/profile/13938254162453228472noreply@blogger.com0tag:blogger.com,1999:blog-3396769621218951760.post-25598444766221791872013-12-29T23:24:00.001-08:002013-12-30T01:43:37.820-08:00SQL Server & MSBI Basics<div dir="ltr" style="text-align: left;" trbidi="on">
<strong>List of SQL Server 2008 Services available?</strong><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-PfG23-008DY/UsEhJkuPPFI/AAAAAAAAD_A/MzgFcDFRabI/s1600/zgffg.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="483" src="http://4.bp.blogspot.com/-PfG23-008DY/UsEhJkuPPFI/AAAAAAAAD_A/MzgFcDFRabI/s640/zgffg.jpg" width="640" /></a></div>
<br />
Here is a basic overview of the services:<br />
<strong>Analysis Services:</strong> This is Microsoft's data warehousing solution. It allows you to create data cubes and other warehousing features. Provides tools to make it easier to create what-if scenarios. This runs on top of SQL Server. Data warehousing is also referred to as Business Intelligence applications because the warehouses are used to mine and analyze data.<br />
<strong>Reporting Services:</strong> Allows you to build database reports more easily. It provides a report designer and management functionality. This service is supposed to make it easier and faster to create rich reports. The reporting service also works against non-SQL Server data services.<br />
<strong>Integration Services:</strong> Provides functionality to build Extract, Transform, Load (ETL) functionality. ETL tools integrate individual data sets and help with extracting, aggregating, cleaning and uploading data. Like the other services, it provides a GUI that is supposed to make these packages easier to create. <br />
The <b>Distributed Transaction Coordinator</b> (MSDTC) service is a component of modern versions of Microsoft Windows that is responsible for coordinating transactions that span multiple resource managers, such as databases, message queues, and file systems. <br />
<strong>SQL Server Agent</strong> is a Microsoft Windows service that executes scheduled administrative tasks, which are called <span class="parameter">jobs.</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<span style="font-family: Calibri;"><span style="font-family: Times New Roman;"><strong>SQL Server Browser </strong></span><strong>: </strong></span><a href="http://www.mssqltips.com/sqlservertip/1946/overview-of-the-sql-server-browser-service/">http://www.mssqltips.com/sqlservertip/1946/overview-of-the-sql-server-browser-service/</a><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<span style="font-family: Calibri;"><strong><span style="font-family: Times New Roman;">SQL Server Full Text Search : </span></strong></span><a href="https://www.simple-talk.com/sql/learn-sql-server/understanding-full-text-indexing-in-sql-server/">https://www.simple-talk.com/sql/learn-sql-server/understanding-full-text-indexing-in-sql-server/</a></div>
</div>
</div>
Sreehari Katagerihttp://www.blogger.com/profile/13938254162453228472noreply@blogger.com0tag:blogger.com,1999:blog-3396769621218951760.post-40231093805161545632013-07-10T01:38:00.000-07:002014-07-10T01:46:34.320-07:00DWH and Data Modelling Reference links<div dir="ltr" style="text-align: left;" trbidi="on">
<b style="background-color: #fefdfa; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.200000762939453px;">Learn Data Modelling with real time example</b><br />
<a href="http://www.databaseanswers.org/downloads/Data_Modeling_by_Example_Vol_1.pdf" style="background-color: #fefdfa; color: #7d181e; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.200000762939453px; text-decoration: none;">http://www.databaseanswers.org/downloads/Data_Modeling_by_Example_Vol_1.pdf</a><br />
<a href="http://www.databaseanswers.org/downloads/Chapter_1_Data_Modelling_at_Windsor_Castle.pdf" style="background-color: #fefdfa; color: #7d181e; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.200000762939453px; text-decoration: none;">http://www.databaseanswers.org/downloads/Chapter_1_Data_Modelling_at_Windsor_Castle.pdf</a></div>
Sreehari Katagerihttp://www.blogger.com/profile/13938254162453228472noreply@blogger.com0