archive-gr.com » GR » D » DOTNETZONE.GR

Total: 987

Choose link from "Titles, links and description words view":

Or switch to "Titles and links view".
  • Rocking with Knowledge for .NET programming : FILESTREAM Best Practices from usage and experience
    Visual Studio 2010 Windows 7 Windows Server 2008 Πλοήγηση Αρχική σελίδα Εκδηλώσεις Ιστολόγια Συζητήσεις Εκθέσεις Φωτογραφιών Αρχειοθήκες My Other Blogs for SQL Server and databases Διάφορα Links European Mediterranean Seismological Centre Ιστορικό Δημοσιεύσεων Ιούνιος 2015 1 Σεπτέμβριος 2014 1 Ιούνιος 2014 2 Μάρτιος 2014 2 Φεβρουάριος 2014 4 Ιανουάριος 2014 5 Δεκέμβριος 2013 1 Σεπτέμβριος 2013 2 Αύγουστος 2013 5 Ιούλιος 2013 1 Ιούνιος 2013 1 Μάιος 2013 3 Απρίλιος 2013 4 Μάρτιος 2013 3 Φεβρουάριος 2013 3 Ιανουάριος 2013 7 Νοέμβριος 2012 2 Οκτώβριος 2012 6 Σεπτέμβριος 2012 7 Αύγουστος 2012 7 Ιούλιος 2012 7 Ιούνιος 2012 2 Μάιος 2012 1 Ιανουάριος 2012 1 Νοέμβριος 2011 5 Οκτώβριος 2011 4 Σεπτέμβριος 2011 5 Μάρτιος 2011 1 Ιανουάριος 2011 1 Μάρτιος 2010 1 Φεβρουάριος 2010 1 Ιανουάριος 2010 1 Δεκέμβριος 2009 1 Νοέμβριος 2009 5 Οκτώβριος 2009 1 Αύγουστος 2009 2 Ιούλιος 2009 1 Ιούνιος 2009 3 Σεπτέμβριος 2008 1 Αύγουστος 2008 1 Ιούλιος 2008 1 Φεβρουάριος 2008 2 Ιανουάριος 2008 5 Δεκέμβριος 2007 4 Ιούλιος 2007 1 Μάιος 2007 1 Δεκέμβριος 2006 1 Οκτώβριος 2006 1 FILESTREAM Best Practices from usage and experience Από τον SQL Server 2008 υπάρχει ένα feature που είναι ιδανικό για BOL fields μέσα στην

    Original URL path: http://www.dotnetzone.gr/cs/blogs/antonch/archive/2013/08/13/filestream-best-practices-from-usage-and-experience.aspx (2015-07-15)
    Open archived version from archive


  • Rocking with Knowledge for .NET programming : How to configure report pagination based on data groups for excel exporting
    Studio 2010 Windows 7 Windows Server 2008 Πλοήγηση Αρχική σελίδα Εκδηλώσεις Ιστολόγια Συζητήσεις Εκθέσεις Φωτογραφιών Αρχειοθήκες My Other Blogs for SQL Server and databases Διάφορα Links European Mediterranean Seismological Centre Ιστορικό Δημοσιεύσεων Ιούνιος 2015 1 Σεπτέμβριος 2014 1 Ιούνιος 2014 2 Μάρτιος 2014 2 Φεβρουάριος 2014 4 Ιανουάριος 2014 5 Δεκέμβριος 2013 1 Σεπτέμβριος 2013 2 Αύγουστος 2013 5 Ιούλιος 2013 1 Ιούνιος 2013 1 Μάιος 2013 3 Απρίλιος 2013 4 Μάρτιος 2013 3 Φεβρουάριος 2013 3 Ιανουάριος 2013 7 Νοέμβριος 2012 2 Οκτώβριος 2012 6 Σεπτέμβριος 2012 7 Αύγουστος 2012 7 Ιούλιος 2012 7 Ιούνιος 2012 2 Μάιος 2012 1 Ιανουάριος 2012 1 Νοέμβριος 2011 5 Οκτώβριος 2011 4 Σεπτέμβριος 2011 5 Μάρτιος 2011 1 Ιανουάριος 2011 1 Μάρτιος 2010 1 Φεβρουάριος 2010 1 Ιανουάριος 2010 1 Δεκέμβριος 2009 1 Νοέμβριος 2009 5 Οκτώβριος 2009 1 Αύγουστος 2009 2 Ιούλιος 2009 1 Ιούνιος 2009 3 Σεπτέμβριος 2008 1 Αύγουστος 2008 1 Ιούλιος 2008 1 Φεβρουάριος 2008 2 Ιανουάριος 2008 5 Δεκέμβριος 2007 4 Ιούλιος 2007 1 Μάιος 2007 1 Δεκέμβριος 2006 1 Οκτώβριος 2006 1 How to configure report pagination based on data groups for excel exporting Ένα report μπορούμε να το δούμε online ή να το κάνουμε export

    Original URL path: http://www.dotnetzone.gr/cs/blogs/antonch/archive/2013/08/11/how-to-configure-report-pagination-based-on-data-groups-for-excel-exporting.aspx (2015-07-15)
    Open archived version from archive

  • Rocking with Knowledge for .NET programming : Using Power Query add-in for Excel to get data from web and facebook
    Studio 2005 Visual Studio 2008 Visual Studio 2010 Windows 7 Windows Server 2008 Πλοήγηση Αρχική σελίδα Εκδηλώσεις Ιστολόγια Συζητήσεις Εκθέσεις Φωτογραφιών Αρχειοθήκες My Other Blogs for SQL Server and databases Διάφορα Links European Mediterranean Seismological Centre Ιστορικό Δημοσιεύσεων Ιούνιος 2015 1 Σεπτέμβριος 2014 1 Ιούνιος 2014 2 Μάρτιος 2014 2 Φεβρουάριος 2014 4 Ιανουάριος 2014 5 Δεκέμβριος 2013 1 Σεπτέμβριος 2013 2 Αύγουστος 2013 5 Ιούλιος 2013 1 Ιούνιος 2013 1 Μάιος 2013 3 Απρίλιος 2013 4 Μάρτιος 2013 3 Φεβρουάριος 2013 3 Ιανουάριος 2013 7 Νοέμβριος 2012 2 Οκτώβριος 2012 6 Σεπτέμβριος 2012 7 Αύγουστος 2012 7 Ιούλιος 2012 7 Ιούνιος 2012 2 Μάιος 2012 1 Ιανουάριος 2012 1 Νοέμβριος 2011 5 Οκτώβριος 2011 4 Σεπτέμβριος 2011 5 Μάρτιος 2011 1 Ιανουάριος 2011 1 Μάρτιος 2010 1 Φεβρουάριος 2010 1 Ιανουάριος 2010 1 Δεκέμβριος 2009 1 Νοέμβριος 2009 5 Οκτώβριος 2009 1 Αύγουστος 2009 2 Ιούλιος 2009 1 Ιούνιος 2009 3 Σεπτέμβριος 2008 1 Αύγουστος 2008 1 Ιούλιος 2008 1 Φεβρουάριος 2008 2 Ιανουάριος 2008 5 Δεκέμβριος 2007 4 Ιούλιος 2007 1 Μάιος 2007 1 Δεκέμβριος 2006 1 Οκτώβριος 2006 1 Using Power Query add in for Excel to get data from web and facebook Σε αυτό το web

    Original URL path: http://www.dotnetzone.gr/cs/blogs/antonch/archive/2013/08/04/using-power-query-add-in-for-excel-to-get-data-from-web-and-facebook.aspx (2015-07-15)
    Open archived version from archive

  • Rocking with Knowledge for .NET programming : How to determine if a database can run on a lower SKU (edition) of SQL Server
    Certifications Cloud Computing ebook IE8 msdn MVP Program Spec Explorer Vedea Visual Studio 2005 Visual Studio 2008 Visual Studio 2010 Windows 7 Windows Server 2008 Πλοήγηση Αρχική σελίδα Εκδηλώσεις Ιστολόγια Συζητήσεις Εκθέσεις Φωτογραφιών Αρχειοθήκες My Other Blogs for SQL Server and databases Διάφορα Links European Mediterranean Seismological Centre Ιστορικό Δημοσιεύσεων Ιούνιος 2015 1 Σεπτέμβριος 2014 1 Ιούνιος 2014 2 Μάρτιος 2014 2 Φεβρουάριος 2014 4 Ιανουάριος 2014 5 Δεκέμβριος 2013 1 Σεπτέμβριος 2013 2 Αύγουστος 2013 5 Ιούλιος 2013 1 Ιούνιος 2013 1 Μάιος 2013 3 Απρίλιος 2013 4 Μάρτιος 2013 3 Φεβρουάριος 2013 3 Ιανουάριος 2013 7 Νοέμβριος 2012 2 Οκτώβριος 2012 6 Σεπτέμβριος 2012 7 Αύγουστος 2012 7 Ιούλιος 2012 7 Ιούνιος 2012 2 Μάιος 2012 1 Ιανουάριος 2012 1 Νοέμβριος 2011 5 Οκτώβριος 2011 4 Σεπτέμβριος 2011 5 Μάρτιος 2011 1 Ιανουάριος 2011 1 Μάρτιος 2010 1 Φεβρουάριος 2010 1 Ιανουάριος 2010 1 Δεκέμβριος 2009 1 Νοέμβριος 2009 5 Οκτώβριος 2009 1 Αύγουστος 2009 2 Ιούλιος 2009 1 Ιούνιος 2009 3 Σεπτέμβριος 2008 1 Αύγουστος 2008 1 Ιούλιος 2008 1 Φεβρουάριος 2008 2 Ιανουάριος 2008 5 Δεκέμβριος 2007 4 Ιούλιος 2007 1 Μάιος 2007 1 Δεκέμβριος 2006 1 Οκτώβριος 2006 1 How to determine if a database

    Original URL path: http://www.dotnetzone.gr/cs/blogs/antonch/archive/2013/07/29/how-to-determine-if-a-database-can-run-on-a-lower-sku-edition-of-sql-server.aspx (2015-07-15)
    Open archived version from archive

  • Rocking with Knowledge for .NET programming : SQL Server 2014 ante portas
    2 0 Azure BCM 2007 Certifications Cloud Computing ebook IE8 msdn MVP Program Spec Explorer Vedea Visual Studio 2005 Visual Studio 2008 Visual Studio 2010 Windows 7 Windows Server 2008 Πλοήγηση Αρχική σελίδα Εκδηλώσεις Ιστολόγια Συζητήσεις Εκθέσεις Φωτογραφιών Αρχειοθήκες My Other Blogs for SQL Server and databases Διάφορα Links European Mediterranean Seismological Centre Ιστορικό Δημοσιεύσεων Ιούνιος 2015 1 Σεπτέμβριος 2014 1 Ιούνιος 2014 2 Μάρτιος 2014 2 Φεβρουάριος 2014 4 Ιανουάριος 2014 5 Δεκέμβριος 2013 1 Σεπτέμβριος 2013 2 Αύγουστος 2013 5 Ιούλιος 2013 1 Ιούνιος 2013 1 Μάιος 2013 3 Απρίλιος 2013 4 Μάρτιος 2013 3 Φεβρουάριος 2013 3 Ιανουάριος 2013 7 Νοέμβριος 2012 2 Οκτώβριος 2012 6 Σεπτέμβριος 2012 7 Αύγουστος 2012 7 Ιούλιος 2012 7 Ιούνιος 2012 2 Μάιος 2012 1 Ιανουάριος 2012 1 Νοέμβριος 2011 5 Οκτώβριος 2011 4 Σεπτέμβριος 2011 5 Μάρτιος 2011 1 Ιανουάριος 2011 1 Μάρτιος 2010 1 Φεβρουάριος 2010 1 Ιανουάριος 2010 1 Δεκέμβριος 2009 1 Νοέμβριος 2009 5 Οκτώβριος 2009 1 Αύγουστος 2009 2 Ιούλιος 2009 1 Ιούνιος 2009 3 Σεπτέμβριος 2008 1 Αύγουστος 2008 1 Ιούλιος 2008 1 Φεβρουάριος 2008 2 Ιανουάριος 2008 5 Δεκέμβριος 2007 4 Ιούλιος 2007 1 Μάιος 2007 1 Δεκέμβριος 2006 1 Οκτώβριος 2006 1 SQL

    Original URL path: http://www.dotnetzone.gr/cs/blogs/antonch/archive/2013/06/05/sql-server-2014-ante-portas.aspx (2015-07-15)
    Open archived version from archive

  • Rocking with Knowledge for .NET programming
    Επειδή όμως δεν ήθελα απλά να το περιγράψω σε ένα ίσως μακροσκελές κείμενο αποφάσισα να το κάνω ένα web cast που ζωντανά δείχνω όλο το θέμα χωρίς slides αλλά με παραδείγματα Enjoy it http www sqlschool gr blog parameter sniffing what is and how to deal with it 921 aspx Posted Δευτέρα 11 Μαρτίου 2013 12 53 πμ από το μέλος Antonios Chatzipavlis 0 σχόλια Installing and Using the Microsoft SQL Server 2012 Performance Dashboard Reports Σαν DBA στην καθημερινότητα μου θέλω να μπορώ εύκολα να βλέπω τι γίνεται με τους SQL Servers που έχω υπό την επίβλεψη μου Για αυτό το λόγο έχω φτιάξει κάποια σειρά από scripts και reports που τα χρησιμοποιώ για να κάνω την ζωή μου ευκολότερη Αυτό βέβαια σημαίνει ότι γνωρίζω το πως θα κατασκευάσω αυτά Τι γίνεται όμως στις περιπτώσεις που κάποιος είτε είναι αυτό που λέμε accidentally DBA είτε είναι νέος στο ρόλο αυτό με τον SQL Server είτε ακόμα ακόμα δεν έχει το χρόνο να κάνει κάτι αντίστοιχο Για αυτούς το product group έχει κατασκευάσει κάποια έτοιμα reports που εύκολα ο καθένας μπορεί να εκτελέσει και να πάρει άμεσα πληροφορίες Αυτά είναι τα reports που είναι build in με την εγκατάσταση του προϊόντος Ακόμα όμως και από αυτά θέλουμε περισσότερες και ποιο ουσιώδης πληροφορίες και για αυτό το product group έχει φτιάξει μια σειρά από reports τα οποία ονομάζει SQL Server 2012 Performance Dashboard Reports το οποία μπορεί ο κάθε ενδιαφερόμενος να τα κατεβάσει από το link more Posted Κυριακή 3 Μαρτίου 2013 9 54 μμ από το μέλος Antonios Chatzipavlis 0 σχόλια Nested CTE A Simple Sample Ένα απλό παράδειγμα για το πως μπορώ να έχω nested CTEs http www sqlschool gr blog nested cte a simple sample 919 aspx Posted Παρασκευή 1 Μαρτίου 2013 2 20 πμ από το μέλος Antonios Chatzipavlis 0 σχόλια DBCC OPTIMIZE WHATIF Apocalypse UPDATE Πριν από μερικούς μήνες σας είχα αναφέρει την DBCC OPTIMIZER WHATIF ένα undocumented dbcc statement Στο post εκείνο είχα προσπαθήσει να βρω πολλά πράγματα για την συγκεκριμένη αλλά όπως συμβαίνει πάντα όταν κάτι είναι undocumented δεν μπορείς να βρεις πολλά τουλάχιστον στην αρχή Σε αυτό όμως κάνω την αποκάλυψη της more Posted Σάββατο 9 Φεβρουαρίου 2013 1 08 πμ από το μέλος Antonios Chatzipavlis 0 σχόλια Database Lifecycle Management DLM Για όλους εμάς που είμαστε data geeks και οι databases είναι τρόπος έκφρασης και ζωής αλλά και κάτι που όλοι χρησιμοποιούν είτε τους αρέσει είτε όχι έχουμε βασανιστεί πάμπολες φορές για το πώς να μεταφέρουμε αλλαγές από το development στο production αλλά και γενικότερα να έχουμε ένα db lifecycle management more Posted Παρασκευή 8 Φεβρουαρίου 2013 2 59 πμ από το μέλος Antonios Chatzipavlis 0 σχόλια New SQL SysPrep support in SQL Server 2012 with SP1 CU2 To Cumulative Update 2 του Service Pack 1 του SQL Server 2012 περιέχει αρκετές ευχάριστες εκπλήξεις Ήδη σας έχω αναφέρει κάποιες και θα συνεχίσω και σε αυτό το post με ακόμα μία που έχει πιστεύω μεγάλη αξία ειδικά σε αυτούς που είναι φίλοι του

    Original URL path: http://www.dotnetzone.gr/cs/blogs/antonch/default.aspx?p=2 (2015-07-15)
    Open archived version from archive

  • The PK blog
    PartitionKey athgr 7 RowKey string Format 0 10 1 DateTime MaxValue Ticks DateTime Now Ticks Guid NewGuid 8 9 public DateTime TimeOfCapture get set 10 public string Temperature get set 11 There is nothing special at this class I use two custom properties TimeOfCapture and Temperature and I m going to make small change and I ll add SchemaVersion which is needed to achieve the functionality I want When I want to create a new entry all I do now is instantiate a WeatherEntry set the values and use a helper method called AddEntry to persist my changes 1 public void AddEntry string temperature DateTime timeofc 2 3 this AddObject WeatherData new WeatherEntry TimeOfCapture timeofc Temperature temperature SchemaVersion 1 0 4 this SaveChanges 5 I m using TableServiceContext from the newly released StorageClient and methods like UpdateObject DeleteObject AddObject etc exist in my data service context where AddEntry helper method relies At the moment my Table schema looks like this It s pretty obvious there is no special handling during saving of my entities but this is about to change in my hybrid version The hybrid I did some changes at my base class and I ve added a new property It s holding the temperature sample area in my case Spata where Athens International Airport is My class looks like this now 1 DataServiceKey PartitionKey RowKey 2 public class WeatherEntry TableServiceEntity 3 4 public WeatherEntry 5 6 PartitionKey athgr 7 RowKey string Format 0 10 1 DateTime MaxValue Ticks DateTime Now Ticks Guid NewGuid 8 9 public DateTime TimeOfCapture get set 10 public string Temperature get set 11 public string SampleArea get set 12 public string SchemaVersion get set 13 So this hybrid client has somehow to handle entities from version 1 and entities from version 2 because my schema is already on version 2 How do you do that The main idea is that you retrieve an entity from table storage and you check if SampleArea and SchemaVersion have a value If they don t put a default value and save them In my case my schema version number has to be 1 5 as this is the default schema number for this hybrid solution One key point to this procedure is before you upgrade your client to this hybrid you roll out an update enabling IgnoreMissingProperties flag on your TableServiceContext If IgnoreMissingProperties is true when a version 1 client is trying to access your entities which are on version 2 and have those new properties it WON T raise an exception and it will just ignore them 1 var account CloudStorageAccount FromConfigurationSetting DataConnectionString 2 var context new WeatherServiceContext account TableEndpoint ToString account Credentials 3 4 Ignore missing properties on my entities 5 context IgnoreMissingProperties true Remember you have to roll out an update BEFORE you upgrade to this hybrid Whenever I m updating an entity to Table Storage I m checking its version Schema and if it s not 1 5 I update it and put a default value on SampleArea 1 public void UpdateEntry WeatherEntry wEntry 2 3 if wEntry SchemaVersion Equals 1 0 4 5 If schema version is 1 0 update it to 1 5 6 and set a default value on SampleArea 7 wEntry SchemaVersion 1 5 8 wEntry SampleArea Spata 9 10 Put some try catch here to 11 catch concurrency exceptions 12 this UpdateObject wEntry 13 this SaveChanges 14 My schema now looks like this Notice that both versions of my entities co exist and are handled just fine by my application Upgrading to version 2 0 Upgrading to version 2 0 is now easy All you have to do is change the default schema number when you create a new entity to version 2 0 and of course update your UpdateEntry helper method to check if version is 1 5 and update the value to 2 0 1 this AddObject WeatherData new WeatherEntry TimeOfCapture timeofc Temperature temperature SchemaVersion 2 0 and 1 public void UpdateEntry WeatherEntry wEntry 2 3 if wEntry SchemaVersion Equals 1 5 4 5 If schema is version 1 5 it already has a default 6 value all we have to do is update schema version so 7 our system won t ignore the default value 8 wEntry SchemaVersion 2 0 9 10 Put some try catch here to 11 catch concurrency exceptions 12 this UpdateObject wEntry 13 this SaveChanges 14 Whenever you retrieve a value from Table Storage you have to check if it s on version 2 0 If it is you can safely use its SampleArea value which is not the default any more That s because schema version is changed when you actually call UpdateEntry which means you had the chance to change SampleArea to a non default value But if it s on version 1 5 you have to ignore it or update it to a new correct value If you do want to use the default value anyway you can create a temporary worker role which will scan the whole table and update all of your schema version numbers to 2 0 How about when you remove properties That s a really easy modification If you remove a property you can use a SaveChangesOption called ReplaceOnUpdate during SaveChanges which will override your entity with the new schema Don t forget to update your schema version number to something unique and put some checks into your application to avoid failures when trying to read non existent properties due to newer schema version 1 this SaveChanges SaveChangesOptions ReplaceOnUpdate That s all for today P K 0 σχόλια Δημοσίευση στην κατηγορία Cloud Azure Architecture Patterns Windows Azure ndash In Place upgrades Δημοσιεύτηκε στις Σάββατο 28 Νοεμβρίου 2009 9 52 μμ από Panagiotis Kefalidis In a previous post I ve described what a VIP Swap is and how you can use it as an updating method to avoid service disruption This particular method doesn t apply to all possible scenarios and if not always most

    Original URL path: http://www.dotnetzone.gr/cs/blogs/pkefal/archive/tags/Architecture/default.aspx (2015-07-15)
    Open archived version from archive

  • The PK blog
    in this and helped me sort things out so quickly PK 0 σχόλια Δημοσίευση στην κατηγορία Cloud Azure General Windows Azure ndash Is Thread spawning from Worker Roles the paspartu Δημοσιεύτηκε στις Τρίτη 18 Μαΐου 2010 1 53 πμ από Panagiotis Kefalidis Paspartu is French for one size fits all Recently I ve been coming across posts explaining and promoting the idea of spawning threads inside a worker role each one of them with a unique work to be done All are sharing the same idea and all of them are describing the same thing The idea You have some work to do but you want to do it with the most efficient way without having underutilized resources which is one of the benefits of cloud computing anyway The implementation You have a worker process Worker Role on Windows Azure which processes some data Certainly that s a good implementation but it s not a best practice Most of the time your instance will be underutilized unless your doing some CPU and memory intensive work and you have a continuous flow of data to be processed In another implementation we created a Master Slave pattern A master distributes work to other slave worker roles roles are picking up their work do their stuff return result and start over again Still in some cases that s not the best idea either Same cons as before Underutilized resources high risk of failure If the master dies unless properly designed your system dies You can t process any data So another one appeared Inside a worker role spawn multiple threads running their own processes or methods doing their work and return result Underutilization is minimized Thread Pool is doing all the hard work for us and as soon as NET 4 0 is supported on Windows Azure parallelization is easy and allow me to say mandatory But what happens if the worker instance dies Or restarts Yes your guess is correct You lose all threads and all the processing done by that moment is lost unless you persist it somehow If you had multiple instances of your worker role to imitate that behavior that wouldn t happen You ll only lose data from the instance that died As Eugenio Pace says You have to be prepared to fail and he s right Every single moment your instance can die without a single notice and you have to be prepared to deal with it Oh boy So really there is no single solution or best practice For me it s best guidance Depending on your scenario one of the solutions above or even a new one can fit better for you than for others Every project is unique and has to be treated as such Try to think out of the box and remember that this is deep water for everyone It is just some of us swim better PK 0 σχόλια Δημοσίευση στην κατηγορία Cloud Azure Architecture Windows Azure Table Storage ndash Is backup necessary Δημοσιεύτηκε στις Κυριακή 16 Μαΐου 2010 11 31 μμ από Panagiotis Kefalidis Yes it is Table storage has multiple replicas and guarantees uptime and availability but for business continuity reasons you have to be protected from possible failures on your application Business logic errors can harm the integrity of your data and all Windows Azure Storage replicas will be harmed too You have to be protected from those scenarios and having a backup plan is necessary There is a really nice project available on Codeplex for this purpose http tablestoragebackup codeplex com PK 0 σχόλια Δημοσίευση στην κατηγορία Cloud Azure SQL Azure ndash Service Update 1 Δημοσιεύτηκε στις Κυριακή 21 Φεβρουαρίου 2010 8 48 μμ από Panagiotis Kefalidis Just three days ago on Feb 13th SQL Azure got an update Long requested features like downgrade and upgrade between Web and Enterprise Edition is finally implemented It s easy just with a single command to switch between versions Also some DMVs were introduced to match on premise SQL Server Idle session timeout was also increased In details Troubleshooting and Supportability DMVs Dynamic Management Views DMVs return state information that can be used to monitor the health of a database diagnose problems and tune performance These views are similar to the ones that already exist in the on premises edition of SQL Server The DMVs we have added are as follows sys dm exec connections This view returns information about the connections established to your database sys dm exec requests This view returns information about each request that executes within your database sys dm exec sessions This view shows information about all active user connections and internal tasks sys dm tran database transactions This view returns information about transactions at the database level sys dm tran active transactions This view returns information about transactions for your current logical database sys dm db partition stats This view returns page and row count information for every partition in the current database Ability to move between editions One of the most requested features was the ability to move up and down between a Web or Business edition database This provides you greater flexibility and if you approach the upper limits of the Web edition database you can easily upgrade with a single command You can also downgrade if your database is below the allowed size limit You can now do that using the following syntax ALTER DATABASE database name MODIFY MAXSIZE 1 10 GB Idle session timeouts We have increased the idle connection timeout from 5 to 30 minutes This will improve your experience while using connection pooling and other interactive tools Long running transactions Based on customer feedback we have improved our algorithm for terminating long running transactions These changes will substantially increase the quality of service and allow you to import and export much larger amounts of data without having to resort to breaking your data down into chunks Source MSDN Forums announcement Provide your feedback on http www mygreatsqlazureidea com There are some great features requested like the ability to automatically store a backup on BLOB storage PK 0 σχόλια Δημοσίευση στην κατηγορία SQL Azure Cloud Azure Windows Azure ndash Did you know that you can set your OS Version Δημοσιεύτηκε στις Τρίτη 12 Ιανουαρίου 2010 11 14 μμ από Panagiotis Kefalidis Windows Azure configuration files support an osVersion attribute where you can set which version of the Windows Azure OS should run your service This feature doesn t make much sense at the moment as there is only one version WA GUEST OS 1 0 200912 01 but in the future it s going to be very handy You can learn more about it here PK 0 σχόλια Δημοσίευση στην κατηγορία Azure Azure Did you know Windows Azure ndash How to detect if you rsquo re running on the cloud or locally Δημοσιεύτηκε στις Τρίτη 5 Ιανουαρίου 2010 7 31 μμ από Panagiotis Kefalidis Recently at MSDN Forums there were people asking how they can detect if their web application is running on the cloud or locally Dev Storage Well besides the obvious part if you have code inside a Web Role or a Worker Role Start method this only exists on a cloud template but what if you want to make that check somewhere else for example inside a Page Load method or inside a library dll If you re trying to detect it on the UI level let s say Page Load you can simply check your headers Request Headers Host will do the trick If it s localhost or whatever you like it to be to can be used to determine if it s running local But how about a Library Are there any alternatives Well it s not the most bullet proof method but it served me well until now and I don t think it s going to stop working as it s a fundamental architecture element of Windows Azure There are specific Environment properties that are raising a SecurityException as you re not allowed to read them One of them is MachineName So if Environment MachineName is raising an exception then you re probably running on the cloud As I said it s not bullet proof because if an IT administrator applies a CAS that restricts specific properties it can still raise an exception but you get my point A combination of tricks can give you the desired result PK 0 σχόλια Δημοσίευση στην κατηγορία Cloud Azure General Windows Azure Queues ndash Getting 400 Bad Request when creating a queue Δημοσιεύτηκε στις Σάββατο 2 Ιανουαρίου 2010 1 49 μμ από Panagiotis Kefalidis You re trying to create a queue on Windows Azure and you re getting a 400 Bad Request as an inner exception Well there are two possible scenarios 1 The name of the queue is not valid It has to be a valid DNS Name to be accepted by the service 2 The service is down or something went wrong and you just have to re try so implementing a re try logic in your service when initializing is not a bad idea I might say it s mandatory The naming rules A queue name must start with a letter or number and may contain only letters numbers and the dash character The first and last letters in the queue name must be alphanumeric The dash character may not be the first or last letter All letters in a queue name must be lowercase A queue name must be from 3 through 63 characters long More on that here Thank you PK 0 σχόλια Δημοσίευση στην κατηγορία Cloud Azure Windows Azure Training Kit ndash December update is out Δημοσιεύτηκε στις Σάββατο 2 Ιανουαρίου 2010 11 39 πμ από Panagiotis Kefalidis Windows Azure training kit it the best starting point if you want to get involved in Azure development It helps you understand the basics of Windows Azure its components and the whereabouts of the service December s release includes some updates and samples from PDC 09 so don t miss it You can download the kit from here http www microsoft com downloads details aspx FamilyID 413E88F8 5966 4A83 B309 53B7B77EDF78 displaylang en PK 0 σχόλια Δημοσίευση στην κατηγορία Azure SQL Azure ndash Programmatically set your firewall settings Δημοσιεύτηκε στις Τετάρτη 9 Δεκεμβρίου 2009 11 03 πμ από Panagiotis Kefalidis One of the latest features introduced on SQL Azure is the abillity to apply firewall settings on your database and allow only specific IP ranges to connect to it This can be done through SQL Azure Portal or through code using stored procedures If you want to take a look at which rules are active on your SQL Azure database you can use select from sys firewall rules That will give you a view of your firewall rules If you want to add a new firewall rule you can use the sp set firewall rule The syntax is sp set firewall rule firewall rule name ip range start ip range end For example exec sp set firewall rule N My setting 192 168 0 15 192 168 0 30 If you want to delete that rule you can use exec sp delete firewall rule N My setting PK 0 σχόλια Δημοσίευση στην κατηγορία SQL Azure Cloud Azure Windows Azure ndash Dynamically scaling your application Δημοσιεύτηκε στις Κυριακή 6 Δεκεμβρίου 2009 8 52 μμ από Panagiotis Kefalidis When you have your service running on Windows Azure the least thing you want is monitoring every now and then and decide if there is a necessity for specific actions based on your monitoring data You want the service to be in some degree self manageable and decide on its own what the necessary actions should take place to satisfy a monitoring alert In this post I m not going to use Service Management API to increase or decrease the number of instances instead I m going to log a warning but in a future post I m going to use it in combination with this logging message so consider this as a series of posts with this being the first one The most common scenario is dynamically increase or decrease VM instances to be able to process more messages as our Queues are getting filled up You have to create your own logic a decision mechanism if you like which will execute some steps and bring the service to a state that satisfies your condition because there is no out of the box solution from Windows Azure A number of companies have announced that their monitoring health software is going to support Windows Azure You can find more information about that if you search the internet or visit the Windows Azure Portal under Partners section In the code below I m monitoring the messages inside a Queue at every role cycle 1 CloudQueue cloudQueue cloudQueueClient GetQueueReference calculateP 2 3 cloudQueue CreateIfNotExist 4 cloudQueue FetchAttributes 5 6 Call this method to calculate your WorkLoad 7 CalculateWorkLoad cloudQueue ApproximateMessageCount and this is the code inside CalculateWorkLoad 1 public void CalculateWorkLoad int messages 2 3 If there are messages find the average of messages 4 available every X seconds 5 X the ThreadSleep time in my case every 5 seconds 6 if messages null 7 average messages Value threadsleep 1000 8 9 DecideIncDecOfInstances average 10 Note that if you want to get accurate values on queue s properties you have to call FetchAttributes There is nothing fancy in my code I m just finding an average workload number of messages in my Queue every 5 seconds and I m passing this value at DecideIncDecOfInstances Here is the code 1 public void DecideIncDecOfInstances int average 2 3 int instances 2 4 5 If my average is above 1000 6 if average 1000 7 OneForEveryThousand average ref instances 8 WarnWeNeedMoreVM instances 9 OneForEveryThousand count is actually increasing the default number of instances which is two 2 by one 1 for every thousand 1000 messages in Queue s average count This is the final part of my code WarnWeNeedMoreVM which logs our need for more or less VM s 1 public void WarnWeNeedMoreVM int instances 2 3 if instances 2 return 4 5 Trace WriteLine String Format WARNING Instances Count should be 0 on this 1 Role 6 instances RoleEnvironment CurrentRoleInstance Role Name Information 7 In my next post for this series I m going to use the newly released Service Management API to upload a new configuration file which increases or decreases the number of VM instances in my role s dynamically Stay tunned PK 0 σχόλια Δημοσίευση στην κατηγορία Cloud Azure Architecture Patterns Windows Azure ndash Upgrading your table storage schema without disrupting your service Δημοσιεύτηκε στις Δευτέρα 30 Νοεμβρίου 2009 11 37 μμ από Panagiotis Kefalidis In general there are two kind of updates you ll mainly perform on Windows Azure One of them is changing your application s logic or so called business logic e g the way you handle read queues or how you process data or even protocol updates etc and the other is schema updates changes I m not referring to SQL Azure schema changes which is a different scenario and approach but in Table storage schema changes and to be more precise only on specific entity types because as you already now Table storage is schema less As in In Place upgrades the same logic applies here too Introduce a hybrid version which handles both the new and the old version of your entity newly introduced properties and then proceed to your final version which handles the new version of your entities and properties only It s a very easy technique and I m explaining how to add new properties and of course remove although it s a less likely scenario During my presentation at Microsoft DevDays Make Web not War I ve created an example using a Weather service and an entity called WeatherEntry so let s use it My class looks like this 1 DataServiceKey PartitionKey RowKey 2 public class WeatherEntry TableServiceEntity 3 4 public WeatherEntry 5 6 PartitionKey athgr 7 RowKey string Format 0 10 1 DateTime MaxValue Ticks DateTime Now Ticks Guid NewGuid 8 9 public DateTime TimeOfCapture get set 10 public string Temperature get set 11 There is nothing special at this class I use two custom properties TimeOfCapture and Temperature and I m going to make small change and I ll add SchemaVersion which is needed to achieve the functionality I want When I want to create a new entry all I do now is instantiate a WeatherEntry set the values and use a helper method called AddEntry to persist my changes 1 public void AddEntry string temperature DateTime timeofc 2 3 this AddObject WeatherData new WeatherEntry TimeOfCapture timeofc Temperature temperature SchemaVersion 1 0 4 this SaveChanges 5 I m using TableServiceContext from the newly released StorageClient and methods like UpdateObject DeleteObject AddObject etc exist in my data service context where AddEntry helper method relies At the moment my Table schema looks like this It s pretty obvious there is no special handling during saving of my entities but this is about to change in my hybrid version The hybrid I did some changes at my base class and I ve added a new property It s holding the temperature sample area in my case Spata where Athens International Airport is My class looks like this now 1 DataServiceKey PartitionKey RowKey 2 public class WeatherEntry TableServiceEntity 3 4 public WeatherEntry 5 6 PartitionKey athgr 7 RowKey string Format 0 10 1 DateTime MaxValue Ticks DateTime Now Ticks Guid NewGuid 8 9 public DateTime TimeOfCapture get set 10 public string Temperature get set 11 public string SampleArea get set 12 public string SchemaVersion get set 13 So this hybrid client has somehow to handle entities from version 1 and entities from version 2 because my schema is already on version 2 How do you do that The

    Original URL path: http://www.dotnetzone.gr/cs/blogs/pkefal/archive/tags/Azure/default.aspx (2015-07-15)
    Open archived version from archive



  •