Pretty basic introduction to Microsoft Sql Server Dynamic Management Views and DBCC commands

[youtube http://www.youtube.com/watch?v=LcVgQ7ZrYdE?feature=player_detailpage&w=640&h=360]
From: http://sitestree.com/?p=1441
Categories:Root, By Sayed Ahmed, MS SQL Server, SQL Server Reporting
Tags:
Post Data:2014-08-24 15:26:15

Shop Online: https://www.ShopForSoul.com/
(Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com
In Bengali: http://Bangla.SaLearningSchool.com
http://SitesTree.com
8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning)
Shop Online: https://www.ShopForSoul.com/
Medium: https://medium.com/@SayedAhmedCanada

Microsoft SQL Server’s performance can be monitored using the system performance and resource monitoring tool as comes with Windows Operating Systems. With that information, you can tune for optimum performance.

I found the following resource to be very useful

SQL Server performance tuning using Windows Performance Monitor: http://www.sqlshack.com/sql-server-performance-tuning-using-windows-performance-monitor/

You can check this resource for a step by step learning (Follow the steps as shown in the left)

http://msdn.microsoft.com/en-us/library/ms187522.aspx

Other Resources:

Which performance counters can you look at on a SQL Server Instance to determine it’s performance and overall health? – https://dba.stackexchange.com/questions/4449/which-performance-counters-can-you-look-at-on-a-sql-server-instance-to-determine

How to troubleshoot SQL Server performance issues – https://support.microsoft.com/kb/298475

From: http://sitestree.com/?p=1439
Categories:Root, By Sayed Ahmed, MS SQL Server, SQL Server Reporting
Tags:
Post Data:2014-08-24 15:48:18
Shop Online: https://www.ShopForSoul.com/ (Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com In Bengali: http://Bangla.SaLearningSchool.com http://SitesTree.com 8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) Shop Online: https://www.ShopForSoul.com/ Medium: https://medium.com/@SayedAhmedCanada

Inspired By: Tuning Queries: SQl Server – http://salearningschool.com/displayArticle.php?table=Articles&articleID=1156&title=Tuning%20Queries:%20SQl%20Server

What are these? Dynamic Management Views, and DBCC Commands

Dynamic Management Views:

“Dynamic management views and functions return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance.” From: http://msdn.microsoft.com/en-us/library/ms188754.aspx

DBCC Statements:

” DBCC statements act as Database Console Commands for SQL Server” From: http://msdn.microsoft.com/en-us/library/ms188796.aspx

Examples for Dynamic Management Views: http://www.mssqltips.com/sqlservertutorial/273/dynamic-management-views/

From: http://sitestree.com/?p=1435
Categories:Root, By Sayed Ahmed, MS SQL Server, SQL Server Reporting
Tags:
Post Data:2014-08-24 14:08:16
Shop Online: https://www.ShopForSoul.com/ (Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com In Bengali: http://Bangla.SaLearningSchool.com http://SitesTree.com 8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) Shop Online: https://www.ShopForSoul.com/ Medium: https://medium.com/@SayedAhmedCanada

Advances in Electrical and Computer Engineering Are Transforming Everything
Out with the Old, In with the New: Remarkable Advances in Electrical & Computer Engineering

Ohio University Online From: http://sitestree.com/?p=1754
Categories:Root, By Sayed Ahmed, MS SQL Server, SQL Server Reporting, Data Warehouse, Analysis Service
Tags:
Post Data:2014-12-13 20:48:21

Shop Online: https://www.ShopForSoul.com/
(Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com
In Bengali: http://Bangla.SaLearningSchool.com
http://SitesTree.com
8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning)
Shop Online: https://www.ShopForSoul.com/
Medium: https://medium.com/@SayedAhmedCanada

Create a Knowledge base and use that Knowledge base to create a Data Quality Project to Clean Data for an existing Database
[youtube http://www.youtube.com/watch?v=Bcrq1-3xxTg?feature=player_detailpage&w=640&h=360] From: http://sitestree.com/?p=1752
Categories:Root, By Sayed Ahmed, MS SQL Server, SQL Server Reporting, Data Warehouse, Analysis Service
Tags:
Post Data:2014-12-12 22:25:02

Shop Online: https://www.ShopForSoul.com/
(Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com
In Bengali: http://Bangla.SaLearningSchool.com
http://SitesTree.com
8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning)
Shop Online: https://www.ShopForSoul.com/
Medium: https://medium.com/@SayedAhmedCanada

SQL Server : random master data services
[youtube http://www.youtube.com/watch?v=G3Hnc_nfiXk?feature=player_detailpage&w=640&h=360] From: http://sitestree.com/?p=1750
Categories:Root, By Sayed Ahmed, MS SQL Server, SQL Server Reporting, Data Warehouse, Analysis Service
Tags:
Post Data:2014-12-12 21:50:00

Shop Online: https://www.ShopForSoul.com/
(Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com
In Bengali: http://Bangla.SaLearningSchool.com
http://SitesTree.com
8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning)
Shop Online: https://www.ShopForSoul.com/
Medium: https://medium.com/@SayedAhmedCanada

SQL Server Master Data Services Configurations Overview
[youtube http://www.youtube.com/watch?v=u60NaQb6UkI?feature=player_detailpage&w=640&h=360] From: http://sitestree.com/?p=1748
Categories:Root, By Sayed Ahmed, MS SQL Server, SQL Server Reporting, Data Warehouse, Analysis Service
Tags:
Post Data:2014-12-12 21:48:44

Shop Online: https://www.ShopForSoul.com/
(Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com
In Bengali: http://Bangla.SaLearningSchool.com
http://SitesTree.com
8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning)
Shop Online: https://www.ShopForSoul.com/
Medium: https://medium.com/@SayedAhmedCanada

SQL Server Data Quality Server and Data Quality Client Installation
[youtube http://www.youtube.com/watch?v=8Tk1YyZAejU?feature=player_detailpage&w=640&h=360]
From: http://sitestree.com/?p=1746
Categories:Root, By Sayed Ahmed, MS SQL Server, SQL Server Reporting, Data Warehouse, Analysis Service
Tags:
Post Data:2014-12-12 21:46:10

Shop Online: https://www.ShopForSoul.com/
(Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com
In Bengali: http://Bangla.SaLearningSchool.com
http://SitesTree.com
8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning)
Shop Online: https://www.ShopForSoul.com/
Medium: https://medium.com/@SayedAhmedCanada

Exporting Reports to Other Rendering Formats

http://msdn.microsoft.com/en-us/library/dd239307.aspx

Add Code to a Report (SSRS)

http://msdn.microsoft.com/en-ca/library/ms156028.aspx

Sub Reports, Reports within Reports

http://msdn.microsoft.com/en-us/library/dd239314.aspx

Viewing and Interacting with SSRS Reports on an iPad

http://blogs.technet.com/b/dataplatforminsider/archive/2013/04/26/viewing-and-interacting-with-ssrs-reports-on-an-ipad.aspx

Cause and Resolution for Reporting Services Error Messages

http://msdn.microsoft.com/en-ca/library/ms165307.aspx

Error Handling in Reporting Services

http://www.dotnetfunda.com/articles/show/1253/error-handling-implementation-in-ssrs

Integrate reporting and analyses services with Team Foundation Server 2013

http://nakedalm.com/integrate-reporting-and-analyses-services-with-team-foundation-server-2013/

Using Charts in Reports

http://msdn.microsoft.com/en-us/library/dd239351.aspx

Using Images in Reports

http://msdn.microsoft.com/en-us/library/dd239394.aspx

Data Regions and Maps (Report Builder and SSRS)

http://msdn.microsoft.com/en-us/library/dd207125.aspx

How to: Add Interactive Sort to a Table or Matrix (Reporting Services)

http://technet.microsoft.com/en-us/library/cc627509%28v=sql.100%29.aspx

Create a Basic Table Report (SSRS Tutorial)

http://msdn.microsoft.com/en-us/library/ms167305.aspx

Creating Matrix Reports

http://msdn.microsoft.com/en-ca/library/dd207149.aspx

Report Parameters (Report Builder and Report Designer)

http://msdn.microsoft.com/en-us/library/dd220464.aspx

Some Misc Topics:

http://msdn.microsoft.com/en-ca/library/ms159106.aspx From: http://sitestree.com/?p=1416
Categories:Root, By Sayed Ahmed, MS SQL Server, SQL Server Reporting, Misc. Reading
Tags:
Post Data:2014-08-17 16:47:49

Shop Online: https://www.ShopForSoul.com/
(Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com
In Bengali: http://Bangla.SaLearningSchool.com
http://SitesTree.com
8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning)
Shop Online: https://www.ShopForSoul.com/
Medium: https://medium.com/@SayedAhmedCanada

Tools for Business Intelligence Development in SQL Server and Visual Studio

http://curah.microsoft.com/30004/sql-server-data-tools-ssdt-and-sql-server-business-intelligence

 

ASP.NET MVC Tutorial

http://www.w3schools.com/aspnet/mvc_intro.asp

 

Web and Mobile Development with Kendo UI

http://www.telerik.com/kendo-ui#a-complete-framework-for-modern-web-and-mobile-app-development

There is an Open Source Version that you can give it a try

 

Kendo UI components

http://demos.telerik.com/kendo-ui/

 

Telerik has UI components for PHP, JSP, and .Net

 

JQuery UI vs Kendo UI

http://jqueryuivskendoui.com/

 

Telerik Tools

http://www.telerik.com/support/demos

 

Telerik UI components for PHP

http://demos.telerik.com/php-ui/

 

Telerik UI Components for JSP

http://demos.telerik.com/jsp-ui/

 

 

 

  From: http://sitestree.com/?p=1364
Categories:Root, By Sayed Ahmed, MS SQL Server, SQL Server Reporting, Misc. Reading
Tags:
Post Data:2014-08-13 11:22:16

Shop Online: https://www.ShopForSoul.com/
(Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com
In Bengali: http://Bangla.SaLearningSchool.com
http://SitesTree.com
8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning)
Shop Online: https://www.ShopForSoul.com/
Medium: https://medium.com/@SayedAhmedCanada