Articles by db_developer (Articles: 11, Tip/Tricks: 8)

Articles: 11, Tip/Tricks: 8

Articles
Technical Blogs
Tips and Tricks
Reference Articles
Projects

Average article rating: 3.94

All Topics
	Dialog Boxes Guidelines 20 Feb 2010 Updated: 20 Feb 2010 Rating: 4.29/5 Votes: 5 Popularity: 3.00 Licence: CPOL Views: 18,802 Bookmarked: 14 Downloaded: 0 Please Sign up or sign in to vote. Guidelines that must be kept in mind while you are designing and implementing dialog boxes
Database Development
SQL Server	Three Master-Details Related Grids on the Same Form 23 Sep 2009 Updated: 23 Sep 2009 Rating: 4.05/5 Votes: 7 Popularity: 3.42 Licence: CPOL Views: 53,633 Bookmarked: 40 Downloaded: 3,626 Please Sign up or sign in to vote. An approach to create a master-details grid and to show the parent column in the child table.
	Avoid single line comments in query to OLE DB Datasource 17 Mar 2011 Updated: 17 Mar 2011 Rating: 1.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 18,064 Bookmarked: 5 Downloaded: 0 Please Sign up or sign in to vote. OLE DB Provider pack all query to single line, thus all query text after comment clause will be truncated
	SyBASE ASE vs Microsoft SQL Server at Hierarchy Building Sample 30 Sep 2010 Updated: 30 Sep 2010 Rating: 4.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 30,521 Bookmarked: 7 Downloaded: 0 Please Sign up or sign in to vote. This article describes how modern industrial RDBMSs solve hierarchy building task, by the way SyBASE ASE and Microsoft SQL Server SQL are compared
	Regular Expressions in MS SQL Server 2005/2008 11 Oct 2009 Updated: 11 Oct 2009 Rating: 4.84/5 Votes: 22 Popularity: 6.29 Licence: CPOL Views: 335,457 Bookmarked: 123 Downloaded: 9,071 Please Sign up or sign in to vote. describes how to create SQL Wrapper for Regular Expressions using SQL Server CLR Integration
	Establishing an Existent Connection with a Sample: XML/A Script Execution Tracing 25 Dec 2009 Updated: 25 Dec 2009 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 12,940 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. Establishing of an existent connection to SQL Server with a sample: XML/A script execution tracing.
	MDX. More than TopSum(). 19 Nov 2009 Updated: 19 Nov 2009 Rating: 4.17/5 Votes: 3 Popularity: 1.99 Licence: CPOL Views: 21,480 Bookmarked: 8 Downloaded: 0 Please Sign up or sign in to vote. MDX. Threshold sum. Approach to order by one thing and accumulate another.
	Database table editor framework 23 Sep 2009 Updated: 23 Sep 2009 Rating: 4.43/5 Votes: 4 Popularity: 2.67 Licence: CPOL Views: 28,151 Bookmarked: 20 Downloaded: 696 Please Sign up or sign in to vote. This article consists of a data layer and forms for database tables editing.
Programming Languages
C#	Exceptions Handling - Some Advanced Detail 31 Jan 2010 Updated: 31 Jan 2010 Rating: 3.63/5 Votes: 9 Popularity: 3.46 Licence: CPOL Views: 17,781 Bookmarked: 14 Downloaded: 0 Please Sign up or sign in to vote. What is the difference between 'throw e' and just 'throw'
	VS SDK/VS Package Find Item in Solution Explorer Window 24 Dec 2009 Updated: 20 Jan 2010 Rating: 4.47/5 Votes: 7 Popularity: 3.77 Licence: CPOL Views: 43,671 Bookmarked: 13 Downloaded: 435 Please Sign up or sign in to vote. Visual Studio Integration Package Menu command. Find Item by using a Regular Expression in Solution Explorer window.
SQL	MDX. Slowly changing value with adjustment. ADOMD.Net. MDX usage in C# 13 Nov 2009 Updated: 1 Dec 2009 Rating: 4.50/5 Votes: 4 Popularity: 2.71 Licence: CPOL Views: 38,702 Bookmarked: 18 Downloaded: 1,383 Please Sign up or sign in to vote. MDX query for Get last valid value for measure before the date and then calculate all values that contribute to this value till given date. ADOMD.Net. MDX usage in C#.

Average blogs rating:

No blogs have been submitted.

Average tips rating: 4.27

Database Development
SQL Server	Useful DateTime Functions [Tip/Trick] 1 Sep 2011 Updated: 1 Sep 2011 Rating: 4.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 6,940 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. IF OBJECT_ID (N'dbo.GetIntervalStartDate', N'FN') IS NOT NULL DROP FUNCTION dbo.GetIntervalStartDate;GO--gets first day of interval date belongs toCREATE FUNCTION dbo.GetIntervalStartDate (@Date datetime,@IntervalType int = 0--0 - DAY, 1 - WEEK (Mon to Sun), 2 - MONTH, 3 -...
	Useful DateTime Functions [Tip/Trick] 5 Mar 2015 Updated: 5 Mar 2015 Rating: 4.59/5 Votes: 23 Popularity: 6.16 Licence: CPOL Views: 76,495 Bookmarked: 35 Downloaded: 0 Please Sign up or sign in to vote. Reminder.Sou...
	Hide Hierarchy levels under Granularity level in Role-Played Dimension [Tip/Trick] 11 May 2010 Updated: 11 May 2010 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 8,130 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. There is no way to show hierarchy level in one dimension of one cube and to hide that hierarchy level in the same dimension (role-played dimension) of the same or other cube. Solution is to add additional hierarchy without levels to hide to this dimension.For example,There is dimension...
	Split function [Tip/Trick] 5 Jun 2010 Updated: 5 Jun 2010 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 24,159 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. Split User Defined Function, MS SQL Server 2008
Programming Languages
C#	ISO Week Number by Date, Date by ISO Week Number [Tip/Trick] 17 Jan 2012 Updated: 17 Jan 2012 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 27,052 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. ISO Week
SQL	Set global profile for mailing in Microsoft SQL Server 2008 [Tip/Trick] 6 Nov 2010 Updated: 13 Nov 2010 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 35,200 Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. Allows to set default mailing global profile with aid of T-SQL
XML	The prefix '' cannot be redefined from '' to 'namespaceURI' within the same start element tag. [Tip/Trick] 27 Nov 2009 Updated: 27 Nov 2009 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 30,542 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. xmlns is special attribute. It determines namespace of current element and its children all as well. You do not have to add it to XmlDocument (XmlElement) explicitly. Use method of XmlDocument:public virtual XmlElement CreateElement( string prefix, string localName, string...
	XmlElement. Delete current node [Tip/Trick] 26 Nov 2009 Updated: 27 Nov 2009 Rating: 2.75/5 Votes: 3 Popularity: 1.31 Licence: CPOL Views: 26,920 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. I was thinking that it is a simple task "select nodes using XPath expression and then to delete them from XML Document", but after I spent a couple of hours ... My fault was I searched for something likes 'Remove current node', 'Delete active node', 'Detach node from tree', etc.Way to delete...

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.

db_developer

Database Developer Freelancer

Ukraine

MS SQL Server Database Developer with 7+ years experience

Technologies/languages: Business Intelligence, SQL, MDX, VBA, SQL Server, Analysis Services (SSAS), Reporting services (SSRS), Integration Services (SSIS), DataWarehouse.
Also: economic background.

Feel free to contact me for rates and details.