pstaev.blogspot.com

pratchev.blogspot.com

Zen of SQL: Refactoring Entity-Attribute-Value Design

http://pratchev.blogspot.com/2010/07/refactoring-entity-attribute-value.html

Tuesday, July 27, 2010. Ntity-Attribute-Value (often referenced as EAV) table design is one of the “wonderful” things that newcomers to the SQL land discover very quickly! 160;   Example is storing all employee information in 3 columns: key column to identify employee ( entity. Attribute key column ( attribute. To identify the attribute stored (name, birth date, SSN, date of hire, etc.), and value column ( value. To store the actual value. Normally the value column has to be of some large length characte...

pratchev.blogspot.com

Zen of SQL: Defensive Database Programming

http://pratchev.blogspot.com/2011/01/defensive-database-programming.html

Friday, January 28, 2011. Efensive programming is a much avoided topic by developers. Rushing to deliver features is almost always prioritized higher than spending time to defensively program code for robustness. Especially in the database world where this concept is much misunderstood. This is why it was real pleasure to read Alex Kuznetsov's book Defensive Database Programming with SQL Server. Posted by Plamen Ratchev. February 7, 2011 at 9:41 AM. I dont think this guy needs an extra buck a month.

pratchev.blogspot.com

Zen of SQL: Import XML File to SQL Table

http://pratchev.blogspot.com/2008/11/import-xml-file-to-sql-table.html

Friday, November 14, 2008. Import XML File to SQL Table. Here is a brief example of importing an XML file into SQL Server table. This is accomplished by using the BULK option of OPENROWSET to load the file, and then utilizing the XQuery capabilities of SQL Server to parse the XML to normalized table format. This example requires SQL server 2005 or SQL Server 2008. First, the following XML is saved to XML file C: Products.xml. Next, a table named Products is created to store the XML data. Sku, product desc.

pratchev.blogspot.com

Zen of SQL: The Power of Simplicity

http://pratchev.blogspot.com/2010/08/power-of-simplicity.html

Friday, August 13, 2010. The Power of Simplicity. Olving a problem very often results in unnecessary complex solutions. One of the first lessons I learned from my math teacher was to scrap any solution that exceeds a page. She would urge me to start all over and look for simpler way to resolve it. In her world there was always a short and simple solution, it was only a matter of seeing it. What are the rules to simplicity? There are no rules! I like to use the following quotes as guidelines:. 160; &...

pratchev.blogspot.com

Zen of SQL: Refactoring Ranges

http://pratchev.blogspot.com/2010/02/refactoring-ranges.html

Monday, February 15, 2010. Refactoring is misunderstood so many times, mostly by developers living by the motto. If it's not broken don't fix it". But in most cases this is invalid argument and leads to keeping inefficient and difficult to maintain solutions around. With tools and languages evolving, as well as knowledge about specific technology, there are so many opportunities to improve existing code in a way that will make a huge difference in many aspects. As Sir Winston Churchill said. Ranges by tr...

pratchev.blogspot.com

Zen of SQL: Column Aggregates

http://pratchev.blogspot.com/2009/08/column-aggregates.html

Friday, August 21, 2009. We all know how to use the aggregate functions MIN, MAX, COUNT, etc. to calculate aggregates across rows. For example, using MAX we can determine the maximum value for group of rows. But what if we want to see the maximum value for each row across columns? There is no aggregate function that accepts list of columns…. Let's look at example to illustrate this. Here is sample table with four data columns:. Max across columns with XQuery. Keycol max col max val. Keycol cnt non zero.

j-bag-of-tricks.ilchev.com

Jordy's Bag of Tricks on Mobile,JavaScript,XAML,WPF,SQL: Parse SQL Connection String in C#

http://j-bag-of-tricks.ilchev.com/2009/04/parse-sql-connection-string-in-c.html

Jordy's Bag of Tricks on Mobile,JavaScript,XAML,WPF,SQL. Wednesday, April 29, 2009. Parse SQL Connection String in C#. It is actually very easy, but not very popular. SqlConnectionStringBuilder scsb = new SqlConnectionStringBuilder(connectionString);. Then you can alter different properties for example modify timeout to 5 min from default. ScsbConnectTimeout = 300;. Finally to use it simply execute. Subscribe to: Post Comments (Atom). View my complete profile. P Staev Tip and Tricks. SQL Studio Team Blog.

j-bag-of-tricks.ilchev.com

Jordy's Bag of Tricks on Mobile,JavaScript,XAML,WPF,SQL: How to make simple (Free!) Grid in WPF with XAML from DataSet or DataTable

http://j-bag-of-tricks.ilchev.com/2007/01/how-to-make-grid-in-wpf-with-xaml-from.html

Jordy's Bag of Tricks on Mobile,JavaScript,XAML,WPF,SQL. Wednesday, January 10, 2007. How to make simple (Free! Grid in WPF with XAML from DataSet or DataTable. This is just a concept you can start with to make your own Grid in XAML. TextBlock Width="100" Text="{Binding}" /. XAML Style for Horizontal List for columns:. Style x:Key="HorizontalList" TargetType="{x:Type ListBox}". StackPanel Orientation="Horizontal" Panel.IsItemsHost= "True"/. Code Behind (VB.Net):. Dim customers As DataSet = New DataSet.

j-bag-of-tricks.ilchev.com

Jordy's Bag of Tricks on Mobile,JavaScript,XAML,WPF,SQL: January 2013

http://j-bag-of-tricks.ilchev.com/2013_01_01_archive.html

Jordy's Bag of Tricks on Mobile,JavaScript,XAML,WPF,SQL. Wednesday, January 16, 2013. JSON ISO 8601 date formatting, Kendo MVVM using Kendo templates. Here is a quick tip how to bind to JSON ISO 8601 date. Parsing and formatting to local date is done using Kendo framework. 09; div data-bind=source: expirationDate data-template=format-date-template /div script id=format-date-template type=text/x-kendo-template span #: kendo.toString(kendo.parseDate(data),d) # /span /script. Subscribe to: Posts (Atom).