(Grant Fritchey) Have you heard this statement or others like it? This is usually delivered early in a development cycle when someone, probably not the person spewing these words of “wisdom,” suggests that performance should be taken into account when designing and building the database, or laying o
Author: SSWUG Research
Real Time SQL Monitoring in Oracle Database 11g
(Karen Reliford) Quickly identifying real time SQL performance issues has been one of the biggest headaches for Oracle DBAs. Often DBAs are asked, why has the system slowed down? Why is my query taking so long to run? Along with other performance related questions.
SQL SERVER – Interesting Observation of CONCAT_NULL_YIELDS_NULL and CONCAT in SQL Server 2012 onwards
(Pinal Dave) Have you ever worked with CONCAT_NULL_YIELDS_NULL earlier in your career? If yes, you will find this post very interesting. If you have not worked with this function before I think this post will teach you something very interesting.
Revolution in IBM DB2 Performance: IBM DB2 Analytics Accelerator
(Ruiping Li) Business analytics plays a crucial role in today’s workplace. The performance and cost of the DB2 Analytics Accelerator opens up unprecedented opportunities for enterprises to make use of the data on the IBM System z platform.
DBCC FreeSessionCache
(Steve Stedman) DBCC FreeSessionCache is only available on SQL Server 2005 and newer it removes all queries from the distributed query cache. This however does not impact anything in the standard procedure cache, to clear the standard procedure cache use DBCC FreeProcCache instead.
Clustering Factor Calculation Improvement Part II (Blocks On Blocks)
(Richard Foote) My previous post on the new TABLE_CACHED_BLOCKS statistics gathering preference certainly generated some interest My blog hits for the week have gone off the charts !!
Automatic schema generation for forms you create in Form Builder
(Alessandro Vernet) When you create a form with Form Builder, behind the scene, data entered by users in the form is collected in an XML document. That same XML document is sent to the persistence API, and if you are using one of the built-in implementations of the persistence API, that XML document
Generating XML using SQL script in MS SQL Server 2005/2008/2012
(Amjad Khan) For providing solution for complete offline data entry application. The data will require to synch with the server via mail. On brainstorming on multiple option we came across solution of desktop .net application, which would be using Master XML files for populating data.
Using Policy Based Management for checking SQL Server database file extensions
(Svetlana Golovko) We need to exclude SQL Server database files from Antivirus and Third Party Backup Software (to make sure that files are not accessed directly). How can we be sure that all of our SQL Server file extensions are using the standard file extensions for database files?
Creating a Reusable UI in WPF: Part 1
(Saiyed Alam) When we work in WPF we have the option of creating reusable UI control. In this article we will see what is reusable UI and how can we use them or create them. And also some of the advantages we get from this.