|
|
Πρόσφατες Δημοσιεύσεις
-
|
In this post I would like to talk about the new system data type HierarchyID which was introduced in SQL Server 2008. I know there are samples of how to use HierarchyID in BOL,MSDN and elsewhere but I thought that it would be a good idea to give it a try with hands-on examples.It is used for storing hierarchical data. ( read more )...
|
-
|
In this post I would like to talk about exceptions in SQL Server. I know there are samples of how to handle exception in SQL Server in BOL,MSDN and elsewhere but I thought that it would be a good idea to give it a try with hands-on examples. Well, let me make a general statement. All humans make mistakes.That includes application developers,database developers e.t.c. ( read more )...
|
-
|
In this post I would like to look into transactions in SQL Server. A transaction is a group of tasks that perform as a single unit of work.In database terms all parts of the transaction must be saved in the database or must be abandoned.It is a great feature in the relational world since through transactions we make sure the database is never in an inconsistent state. ( read more )...
|
-
|
In this post I would like to talk about a new feature in SQL Server 2008, Resource Governor and what this new feature offers us in terms of performance and good use of resources. I know there are samples of how to use Resource Governor in BOL,MSDN and elsewhere but I thought that it would be a good idea to give it a try with hands-on examples. ( read more )...
|
-
|
In this post I would like to look into Transparent Data Encryption (TDE) works in SQL Server 2008.I would like to stress that this is an SQL Server 2008/R2 Entreprise/Developer edition feature only. I know there are samples of how to use Transparent Data Encryption in BOL,MSDN and elsewhere but I thought that it would be a good idea to give it a try with hands-on examples. read more...
|
-
|
The other day I submitted my 1st Windows Phone 7 application via http://create.msdn.com Having registered for free as a student developer (being a PhD student on Robotics) via http://dreamspark.com I could only try my 1st app on WP7 emulator – when it gets accepted I will be able to have my WP7 phone unlocked to [...]...
|
-
|
Όσοι ασχολούμαστε καθημερινά με τον SQL Server και το πρώτο πράγμα που κάνουμε το πρωί πριν ακόμα πιούμε την πρώτη τζούρα καφές είναι σχεδόν σίγουρο ότι όταν θα χρειαστεί να κάνουμε κάποιο restore σε μια database γνωρίζουμε εξ αρχής σε ποιο χρονικό σημείο θα γυρίσουμε. Παρόλα αυτά όμως κάνουμε επιβεβαίωση χρησιμοποιώντας διάφορες τεχνικές κυρίως με T-SQL commands. Στο SQL Server 2012 όταν πάμε να κάνουμε restore μια βάση μέσα από το GUI θα δούμε πλέον όπως φαίνεται στην παρακάτω εικόνα ένα button με τίτλο Timeline [ View article ]...
|
-
|
I needed a query at Sitecore to select the descendants belonging to a template, of the ancestor belonging to another template query:./ancestor::*[@@templatekey='templ 1']//*[@@templatekey='templ 2']...
|
-
|
Πριν μερικές μέρες ανακοινώθηκαν από την Microsoft οι πρώτες αλλαγές που αφορούν τις εκδόσεις και τις άδειες χρήσης του προϊόντος. Οφείλω να ομολογήσω ότι ποτέ δεν ήμουν από αυτούς που ασχολούνταν με το θέμα των αδειών, θα μπορούσα να πω ότι ήμουν και είμαι αλλεργικός με το θέμα αυτό. Όμως είδα ότι κάτι πάει να αλλάξει στο θέμα αυτό και μάλιστα προς το καλύτερο. Επίσης επειδή είχα την τύχη να παρακολουθήσω ένα live meeting σχετικά με αυτά πήρα την απόφαση να προσθέσω και εγώ το λιθαράκι μου με το post αυτό. Είναι αλήθεια πάντως ότι μου πήρε μερικές μέρες για να καταλάβω πως έχει το θέμα με τις άδειες και είχα αρκετές ερωτήσεις. Αυτό πάντως που δεν μου ήταν δύσκολο να καταλάβω με την πρώτη ήταν το ποιες θα είναι οι εκδόσεις του SQL Server 2012. [ read more ]...
|
-
|
Σήμερα μου ανέφερε ένας γνωστός ότι η ελληνική του εφαρμογή “κόπηκε” λόγω γλώσσας κατά τη διαδικασία του ελέγχου από την ομάδα του Windows Phone marketplace, παρότι είχε επιλέξει να γίνει publish μόνο στο ελληνικό marketplace, είχε βάλει ελληνική περιγραφή, ελληνικό user interface κ.λ.π. Τι συνέβη; Ο λόγος που κόπηκε είναι γιατί το default language της εφαρμογής του ήταν Αγγλικά. Για να το αλλάξετε αυτό, θα πρέπει να κάνετε δεξί κλικ στο project, properties, assembly information στην καρτέλα application και από εκεί να αλλάξετε το neutral language της εφαρμογής σας, θέτωντας το σε ελληνικά. Με αυτό τον τρόπο, η ελληνική εφαρμογή σας θα φαίνεται ότι υποστηρίζει την ελληνική γλώσσα και θα γίνει δεκτή στο marketplace! Διαβάστε περισσότερα »...
|
-
|
Αρκετές φορές έχω ερωτηθεί αν μπορεί να γίνει μετατροπή των υφιστάμενων report που είναι φτιαγμένα με Crystal Reports (.rtp) σε SQL Server Reporting Services (.rdl). Αυτό και άλλα πολλά ήταν και είναι εφικτό να γίνουν αρκεί να βουτούσες για τα καλά μέσα στο SQL Server 2008 R2 Reporting Services Migration Guide . Πρόσφατα στο Microsoft | Business Intelligence site , η Microsoft μας ενημερώνει ότι μια εταιρεία... [ read more ]...
|
-
|
Tagged: AI, Brain, Inspiration, Neuroscience, Robotics, Talks, TED, Wolpert...
|
-
|
Well, this subject always excited me! The fact that you can provide at your executable, a programming language (script) that the user can use to interact with your application is something amazing. In this post, we see how this is possible by using the Dynamic Language Runtime (DLR) and IronPython, and then see whether the services provided by the Roslyn project can help as achieve the same result with C#. The whole idea behind providing a scripting language at runtime may find the following three applications: You implement a DSL (Domain Specific Language) meaning that you want to provide to your end use an expressive tool to specify his behavior in a specific application domain. In this case you expose some parts of the information held in your application in the form of methods that the user can use in his scripts to achieve the desired result. You want to be able to change a specific behavior without having to recompile the whole application or in the case where you use the same executable in multi-tenant...
|
-
|
Ένας από τους λόγους που διστάζω να συστήσω το Hotmail σε άπειρους χρήστες ή σε παιδιά είναι οι απαράδεκτες παραπλανητικές διαφημίσεις τρίτων που φιλοξενεί. Στην παρακάτω εικόνα βλέπουμε πως ενώ λέει “Είσαι ο σημερινός ΝΙΚΗΤΗΣ ενός iPad 2!”, αναφέρει αμέσως παρακάτω “…για να προσπαθήσετε να κερδίσετε” (δηλαδή ψευδώς σου λέει πως είσαι νικητής στην αρχή [...]...
|
-
|
http://sqlschoolgr.wordpress.com/2011/10/23/tod-you-are-not-going-to-say-f-i-ran-the-test-script-in-the-production-server-again/...
|
-
|
In this post I would like to talk about Security in SQL Server. This is a very big topic and you should embrace yourselves for a very long post. I know there are samples of how to use secure data in BOL,MSDN and elsewhere but I thought that it would be a good idea to give it a try with hands-on examples. Many people have found useful my style of posting. They feel they can follow the steps and master the technology/topic. At the beginning I will give a short introduction about the various security threats that our systems face and then look into aspects of Security in SQL Server .Then I will provide many examples on how to secure data in SQL Server. ( read more )...
|
-
|
That is, our class implements the INotifyPropertyChanged interface and also raises the notification for the “Description” property whenever the Id or the Name properties are changed in order for the Listbox contents (databound to Description) to be refreshed. Our ViewModel for the application is as follows: public class MainWindowViewModel : INotifyPropertyChanged { private List<Client> _clients; public List<Client> Clients { get { return _clients; } set { _clients = value ; if (PropertyChanged != null ) PropertyChanged( this , new PropertyChangedEventArgs( "Clients" )); } } private Client _selectedClient; public Client SelectedClient { get { return _selectedClient; } set { _selectedClient = value ; if (PropertyChanged != null ) PropertyChanged( this , new PropertyChangedEventArgs( "SelectedClient" )); } } public MainWindowViewModel() {} public void Validate() { if (SelectedClient != null ) { if (String.IsNullOrWhiteSpace(SelectedClient.Name)) MessageBox.Show( "Name cannot be empty for...
|
-
|
http://sqlschoolgr.wordpress.com/2011/10/17/sql-server-developers-tools-code-named-juneau-becomes-sql-server-data-tools-ssdt/...
|
-
|
In this post, we are going to show hot to create a small Angry Birds clone for Windows Phone 7 in 5 minutes using Expression Blend and zero (yes, zero) lines of code. Of course, the game that we will create is far from finished but it can serve as a start for your new awesome game. Check the video explaining the tutorial (Please visit the site to view this video) We will use Windows Phone developer tools (they include Expression Blend for Windows Phone) which you can download from http://create.msdn.com and the free/open source Physics Helper library (download here: http://physicshelper.codeplex.com ). Physics Helper is a helper library for the popular physics engine Farseer ( http://farseerphysics.codeplex.com/ ). Basically, it adds some Behaviors inside Expression Blend in order to use the engine without writing any code at all! First of all, you download the Physics Helper library, extract the dlls. Then you open Expression Blend and create a new Windows Phone Application. Pay attention so that the version...
|
-
|
In this post I would like to look into Views in SQL Server. As always I will demonstrate all the various concepts with hands-on examples. I know that all these concepts are well documented elsewhere. I will try to look into views with step by step instructions and many screenshots. Many people have found useful my style of posting. They feel they can follow the steps and master the technology.( Read more )...
|
-
|
In this post I would like to show a few examples of built in T-SQL functions and global functions. I teach T-SQL to people from all walks of life and many of them have asked me to write a simple post with examples of the most commonly used T-SQL functions and global functions.( Read more )...
|
-
|
In this post I would like to show a few examples of how to use triggers in SQL Server. I would like to talk about the uses of triggers, the type of triggers and some misconceptions about the triggers. I know there are samples of how to use triggers in BOL,MSDN and elsewhere but I thought that it would be a good idea to give it a try with hands-on examples.( Read more )...
|
-
|
In this post I would like to talk about data compression/backup compression features available to us in SQL Server 2008 and R2 editions. I will talk about Data Compression and Backup Compression. Data Compression is only available in Enterprise (SQL Server 2008 & SQL Server 2008 R2) edition or higher, not in the Standard edition for SQL Server 2008/ R2.( read more )...
|
-
|
In this post I would like to talk about SQL Server Audit. This new way of auditing was introduced with SQL Server 2008.This feature is supported in SQL Server 2008 Enterprise edition.Auditing is simply the process of monitoring and tracking changes to the SQL Server system.All the DBAs need to implement auditing at some point to satisfy business requirements. There is something called “SQL Server Extended Events” engine.The extended events engine allows any process to define and raise events and consumers to receive events.This engine is in the heart of SQL Server Audits. ( read more )...
|
-
|
Being professional coder is harder than you think... I have again three books that I am hoping to finish this month, I will start here with one I just finished. It's the Clean Coder from the famous Uncle Bob . I add it on the Software Engineering Books and in my Highly Recommended l ist. It is a brilliant read. It is not the technical book one might be looking for. For a more technical approach on how to write clean code please read Clean Code (Robert C. Martin) for which I also have a review. This books is about what a professional coder is about. What behaviors should he follow on his everyday life as a coder on a big or a small firm. A lot of the content sounds obvious when you read it, but it's put together extremely well and will almost certainly relate to issues that you've had to deal with in your career, be it difficult colleagues or untrusting managers. It's easy to read and will probably open your eyes to becoming a more professional software developer who is better able to take responsibility for their...
|
|
|
|