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".
  • Dot Net Rules
    HTML 5 html5 IE8 interface Javascript jquery Lambdas lazy loading LINQ LINQ to Entities LINQ to objects Linq to Sql LocalDB Localisation performance POCOS Polymorphism routing scaffolding ScriptManager SEO session state silverlight Sql Server Sql Server 2005 SQL Server 2008 sql server 2012 sqlcommand SQLDataReader stored procedures tables tips and tricks Tracing transaction log transactions UpdatePanel validation VB 2005 VB 2008 VB 9 0 ViewState Visual Basic 10 0 Visual Studio Visual Studio 2005 Visual Studio 2008 Visual Studio 2010 Visual Studio 2012 VS 2010 VS 2012 WCF wcf data service web server controls web service web config window forms windows forms WPF XAML XHTML XML XML Literals Πλοήγηση Αρχική σελίδα Εκδηλώσεις Ιστολόγια Συζητήσεις Εκθέσεις Φωτογραφιών Αρχειοθήκες Ιστορικό Δημοσιεύσεων Ιούνιος 2015 4 Μάρτιος 2015 2 Ιούνιος 2014 1 Δεκέμβριος 2013 2 Νοέμβριος 2013 14 Οκτώβριος 2013 2 Σεπτέμβριος 2013 5 Ιούλιος 2013 1 Ιανουάριος 2013 8 Δεκέμβριος 2012 11 Νοέμβριος 2012 3 Οκτώβριος 2012 12 Σεπτέμβριος 2012 16 Αύγουστος 2012 6 Ιούλιος 2012 13 Ιούνιος 2012 3 Μάιος 2012 4 Απρίλιος 2012 15 Μάρτιος 2012 8 Ιανουάριος 2012 3 Δεκέμβριος 2011 7 Νοέμβριος 2011 13 Οκτώβριος 2011 6 Σεπτέμβριος 2011 8 Αύγουστος 2011 6 Ιούλιος 2011 2 Μάιος 2011 1 Μάρτιος 2011 9 Φεβρουάριος 2011 15 Ιανουάριος 2011 14 Δεκέμβριος 2010 9 Νοέμβριος 2010 2 Οκτώβριος 2010 11 Σεπτέμβριος 2010 1 Αύγουστος 2010 3 Απρίλιος 2010 2 Μάρτιος 2010 5 Ιανουάριος 2010 1 Οκτώβριος 2009 2 Σεπτέμβριος 2009 4 Ιούνιος 2009 5 Απρίλιος 2009 1 Μάρτιος 2009 3 Φεβρουάριος 2009 2 Δεκέμβριος 2008 3 Νοέμβριος 2008 10 Σεπτέμβριος 2008 1 Αύγουστος 2008 1 Ιούλιος 2008 9 Ιούνιος 2008 10 Παρουσίαση με Ετικέτες Όλες οι Ετικέτε objectdatasource RSS Ajax asp net C Linq to Sql UpdatePanel UpdateProgress Visual Studio 2008 Visual Studio 2010 web server controls Ajax Enabling an existing ASP

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


  • Dot Net Rules
    2015 2 Ιούνιος 2014 1 Δεκέμβριος 2013 2 Νοέμβριος 2013 14 Οκτώβριος 2013 2 Σεπτέμβριος 2013 5 Ιούλιος 2013 1 Ιανουάριος 2013 8 Δεκέμβριος 2012 11 Νοέμβριος 2012 3 Οκτώβριος 2012 12 Σεπτέμβριος 2012 16 Αύγουστος 2012 6 Ιούλιος 2012 13 Ιούνιος 2012 3 Μάιος 2012 4 Απρίλιος 2012 15 Μάρτιος 2012 8 Ιανουάριος 2012 3 Δεκέμβριος 2011 7 Νοέμβριος 2011 13 Οκτώβριος 2011 6 Σεπτέμβριος 2011 8 Αύγουστος 2011 6 Ιούλιος 2011 2 Μάιος 2011 1 Μάρτιος 2011 9 Φεβρουάριος 2011 15 Ιανουάριος 2011 14 Δεκέμβριος 2010 9 Νοέμβριος 2010 2 Οκτώβριος 2010 11 Σεπτέμβριος 2010 1 Αύγουστος 2010 3 Απρίλιος 2010 2 Μάρτιος 2010 5 Ιανουάριος 2010 1 Οκτώβριος 2009 2 Σεπτέμβριος 2009 4 Ιούνιος 2009 5 Απρίλιος 2009 1 Μάρτιος 2009 3 Φεβρουάριος 2009 2 Δεκέμβριος 2008 3 Νοέμβριος 2008 10 Σεπτέμβριος 2008 1 Αύγουστος 2008 1 Ιούλιος 2008 9 Ιούνιος 2008 10 Παρουσίαση με Ετικέτες Όλες οι Ετικέτε Profiling RSS Entity framework Entity Framework 6 0 LINQ to Entities Database Command Logging Profiling in Entity Framework 6 0 In this post I am going to provide you with a hands on example on how to log commands queries sent to the database by Entity Framework 6 0 You can use the fantastic Entity Framework third party profiler by Hibernating Rhinos if you want You can find a similar post here Entity Framework is an object relational mapping ORM framework for the NET Framework EF addresses the problem of Object relational impedance mismatch I will not be talking about that mismatch because it is well documented in many sites on the Internet Through that framework we can program against a conceptual application model instead of programming directly against a relational schema model By doing so we can decrease the amount of code we do write to access

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

  • Dot Net Rules : Looking into the JQuery Roundabout Plugin
    2009 4 Ιούνιος 2009 5 Απρίλιος 2009 1 Μάρτιος 2009 3 Φεβρουάριος 2009 2 Δεκέμβριος 2008 3 Νοέμβριος 2008 10 Σεπτέμβριος 2008 1 Αύγουστος 2008 1 Ιούλιος 2008 9 Ιούνιος 2008 10 Looking into the JQuery Roundabout Plugin I have been using JQuery for a couple of years now and it has helped me to solve many problems on the client side of web development You can find all my posts about JQuery in this link In this post I will be providing you with a hands on example on the JQuery Roundabout Plugin This is a plugin that supports circular rotating display for content It supports autoplay In this hands on example I will be using Expression Web 4 0 This application is not a free application You can use any HTML editor you like You can use Visual Studio 2013 Express edition You can download it here You can download this plugin from this link I launch Expression Web 4 0 and then I type the following HTML markup I am using HTML 5 DOCTYPE html html head title JQuery Roundabout Plugin title style ul margin 1em auto width 700px height 300px list style none li text align center height 300px width 700px background color eee color 565748 style script src jquery 2 0 2 min js script script src jquery roundabout min js script script type text javascript function ul roundabout minOpacity 1 minScale 1 script head body div ul li h2 Manchester Utd h2 p Manchester United Football Club is an English professional football club based in Old Trafford Greater Manchester that plays in the Premier League Founded as Newton Heath LYR Football Club in 1878 the club changed its name to Manchester United in 1902 and moved to Old Trafford in 1910 and is one of the most successful clubs in English football Manchester United have won the most League titles 20 of any English club 3 a joint record 11 FA Cups four League Cups and a record twenty FA Community Shields The club has also won three European Cups one UEFA Cup Winners Cup one UEFA Super Cup one Intercontinental Cup and one FIFA Club World Cup In 1998 99 the club won a continental treble of the Premier League the FA Cup and the UEFA Champions League p p Sed urna ligula tristique ut accumsan in condimentum quis quam Nam pharetra erat at lacus sagittis sagittis p a href http www manutd com Man Utd a li li h2 Liverpool FC h2 p Liverpool Football Club ˈlɪvərpuːl is an English Premier League football club based in Liverpool Liverpool F C is one of the most successful clubs in England and has won more European trophies than any other English team with five European Cups three UEFA Cups and three UEFA Super Cups The club has also won eighteen League titles seven FA Cups and a record eight League Cups Liverpool was founded in 1892 and joined the Football League the following year

    Original URL path: http://www.dotnetzone.gr/cs/blogs/dotnetrules/archive/2014/06/03/looking-into-the-jquery-roundabout-plugin.aspx (2015-07-15)
    Open archived version from archive

  • Dot Net Rules : Looking into temporary tables in SQL Server
    shirt no tinyint NOT NULL position played varchar 30 NOT NULL GO SET IDENTITY INSERT dbo footballer ON GO INSERT footballer FootballerID lastname firstname shirt no position played VALUES 1 N Oliver N Regina 4 N goalkeeper INSERT footballer FootballerID lastname firstname shirt no position played VALUES 2 N Alexander N Roy 8 N goalkeeper INSERT footballer FootballerID lastname firstname shirt no position played VALUES 3 N Mueller N Dewayne 10 N defender INSERT footballer FootballerID lastname firstname shirt no position played VALUES 4 N Buckley N Beth 3 N midfielder INSERT footballer FootballerID lastname firstname shirt no position played VALUES 5 N Koch N Jolene 7 N striker GO SELECT FROM footballer As you can see there is a prefix in front of the table This table will be saved in the tempdb Finally I select everything from the temporary table If I open a new query window and try to select everything see the query below from the footballer table USE tempdb GO SELECT FROM footballer You will not receive any results You will receive an error Invalid object name footballer This is a local temporary table and it is in scope only in the current connection session We can also create global temporary tables In a new query window execute the following script USE tempdb GO IF OBJECT ID tempdb footballernew IS NOT NULL DROP TABLE footballernew GO CREATE TABLE footballernew FootballerID INT IDENTITY NOT NULL PRIMARY KEY lastname varchar 15 NOT NULL firstname varchar 15 NOT NULL shirt no tinyint NOT NULL position played varchar 30 NOT NULL GO SET IDENTITY INSERT dbo footballernew ON GO INSERT footballernew FootballerID lastname firstname shirt no position played VALUES 1 N Oliver N Regina 4 N goalkeeper INSERT footballernew FootballerID lastname firstname shirt no position played VALUES 2 N Alexander N Roy 8 N goalkeeper INSERT footballernew FootballerID lastname firstname shirt no position played VALUES 3 N Mueller N Dewayne 10 N defender INSERT footballernew FootballerID lastname firstname shirt no position played VALUES 4 N Buckley N Beth 3 N midfielder INSERT footballernew FootballerID lastname firstname shirt no position played VALUES 5 N Koch N Jolene 7 N striker GO SELECT FROM footballernew We denote the global temporary table with footballernew The global temporary table is deleted when all users referencing the table disconnect Both global and local temporary tables should be deleted in code rather than depending on automatic drop A temporary table created in a stored procedure is visible to other stored procedures executed from within the first procedure In a new query window type the following USE tempdb GO SELECT FROM footballernew In this case there will be no error Global temporary tables persist across sessions connections You can also add columns to temporary tables and alter the definition of existing columns In this script I add another column and then alter the definition of an existing column USE tempdb GO IF OBJECT ID tempdb footballer IS NOT NULL DROP TABLE footballer GO CREATE TABLE footballer

    Original URL path: http://www.dotnetzone.gr/cs/blogs/dotnetrules/archive/2013/12/04/looking-into-temporary-tables-in-sql-server.aspx (2015-07-15)
    Open archived version from archive

  • Dot Net Rules : Looking into Temp database usage in SQL Server
    light on this particular issue Temporary tables and table variables make use of the system tempdb database There is only one tempdb system database per SQL Server instance so if there is a huge usage of temporary objects in this database it can be the point of contention When you create an entry in database it needs to allocate space This is also valid for the tempdb database There are three types of pages involved in the allocation process in the tempdb data file Page Free Space PFS Shared Global Allocation Map SGAM Global Allocation Map GAM When there is a great page allocation contention in tempdb the whole allocation process can suffer and we can experience with PAGELATCH waits In order to address the issue above you can have a number of tempdb data files that are equal to the number of cores For example if you have a system with less than 8 cores e g 6 you should add set up 6 data files for the tempdb If you have a system with more than 8 cores you should add 8 data files for the tempdb and then if the contention is still big you can add 4 more data files By saying cores in this post I mean logical cores and not physical cores So if you have 8 physical cores then you have 16 logical cores and 32 logical cores if hyper threading is enabled I will provide some demos in order to show you what tempdb contention might look like and what are the main wait latches that occur I have installed SQL Server 2012 Enterprise edition in my machine but you can use the SQL Server 2012 2008 Express edition as well I am connecting to my local instance through Windows Authentication and in a new query window I type you can copy paste In this snippet I create a new database and then create a new table with some constraints CREATE DATABASE mytempdbcontention GO USE mytempdbcontention GO CREATE TABLE dbo footballer FootballerID INT IDENTITY NOT NULL PRIMARY KEY lastname varchar 15 NOT NULL firstname varchar 15 NOT NULL shirt no tinyint NOT NULL position played varchar 30 NOT NULL GO ALTER TABLE dbo footballer ADD CONSTRAINT CK Footballer Shirt No CHECK shirt no 1 AND shirt no 11 GO ALTER TABLE dbo footballer ADD CONSTRAINT CK Footballer Position CHECK position played IN goalkeeper defender midfielder striker GO Now I need to populate the table with 50 000 rows This is the script you need to execute in order to make this happen You can download it here Rename the insert footballer doc to insert footballer sql and execute the script in a new query window Now I need to create a script that will create tempdb contention This is the script that creates a temporary object footballer populates the footballer from the footballer table and then selects from it Finally it drops the temporary object USE mytempdbcontention GO SET NOCOUNT ON GO

    Original URL path: http://www.dotnetzone.gr/cs/blogs/dotnetrules/archive/2013/12/04/looking-into-temp-database-usage-in-sql-server.aspx (2015-07-15)
    Open archived version from archive

  • Dot Net Rules : Ownership chain in SQL Server
    2011 8 Αύγουστος 2011 6 Ιούλιος 2011 2 Μάιος 2011 1 Μάρτιος 2011 9 Φεβρουάριος 2011 15 Ιανουάριος 2011 14 Δεκέμβριος 2010 9 Νοέμβριος 2010 2 Οκτώβριος 2010 11 Σεπτέμβριος 2010 1 Αύγουστος 2010 3 Απρίλιος 2010 2 Μάρτιος 2010 5 Ιανουάριος 2010 1 Οκτώβριος 2009 2 Σεπτέμβριος 2009 4 Ιούνιος 2009 5 Απρίλιος 2009 1 Μάρτιος 2009 3 Φεβρουάριος 2009 2 Δεκέμβριος 2008 3 Νοέμβριος 2008 10 Σεπτέμβριος 2008 1 Αύγουστος 2008 1 Ιούλιος 2008 9 Ιούνιος 2008 10 Ownership chain in SQL Server I have been delivering a certified course in MS SQL Server 2012 recently and I was asked a very interesting question about SQL Server stored procedures and ownership chain Security is a big thing in SQL Server and can be implemented in various levels Before we move on we should define some basic terms that are very important when we talk about security in SQL Server The principal access data It should be authenticated by SQL Server which basically means that the principal should prove that it is whom it claims to be Principal is a user a group or an application granted permission to access securables So what is a securable Securable is an object to which access privileges are granted Privilege is an action that a principal is allowed to perform an a securable I want to show you an example where we want to deny a user to the actual table data but grant him access through a view or a stored procedure UserA is the owner of tableA and creates StoredProcA that gets data from tableA Then if the UserB is granted permission to execute the StoredProcA even though he does not have direct access to tableA he will be able to get access indirectly to the table This is the concept of ownership chaining I have installed SQL Server 2012 Enterprise edition in my machine but you can use the SQL Server 2012 2008 Express edition as well I am connecting to my local instance through Windows Authentication and in a new query window I type you can copy paste USE master GO Create a sample database CREATE DATABASE mysampledb GO create a login CREATE LOGIN login1 WITH PASSWORD login1 CHECK POLICY OFF USE mysampledb go Create a User for that login CREATE USER thelogin1 FOR LOGIN login1 see the user that you are now dbo SELECT user create table and populate it with sample data CREATE TABLE dbo person id INT IDENTITY 1 1 firstname varchar 40 lastname VARCHAR 50 go INSERT dbo person VALUES nick kenteris maria negri apostolis kaperis kostas gekas CREATE PROCEDURE dbo getpersons AS SELECT id firstname lastname FROM dbo person go give permissions to execute the procedure to the thelogin1 user GRANT EXECUTE ON dbo getpersons TO thelogin1 change the current user as thelogin1 EXECUTE AS USER thelogin1 check if we are indeed thelogin1 user SELECT USER fails SELECT FROM dbo person works EXECUTE dbo getpersons get back to the dbo user REVERT see

    Original URL path: http://www.dotnetzone.gr/cs/blogs/dotnetrules/archive/2013/11/28/ownership-chain-in-sql-server.aspx (2015-07-15)
    Open archived version from archive

  • Dot Net Rules : Tables with no clustered indexes or no indexes at all in SQL Server databases
    2008 Visual Studio 2010 Visual Studio 2012 VS 2010 VS 2012 WCF web server controls web service web config window forms windows forms WPF XAML XHTML XML XML Literals Πλοήγηση Αρχική σελίδα Εκδηλώσεις Ιστολόγια Συζητήσεις Εκθέσεις Φωτογραφιών Αρχειοθήκες Ιστορικό Δημοσιεύσεων Ιούνιος 2015 4 Μάρτιος 2015 2 Ιούνιος 2014 1 Δεκέμβριος 2013 2 Νοέμβριος 2013 14 Οκτώβριος 2013 2 Σεπτέμβριος 2013 5 Ιούλιος 2013 1 Ιανουάριος 2013 8 Δεκέμβριος 2012 11 Νοέμβριος 2012 3 Οκτώβριος 2012 12 Σεπτέμβριος 2012 16 Αύγουστος 2012 6 Ιούλιος 2012 13 Ιούνιος 2012 3 Μάιος 2012 4 Απρίλιος 2012 15 Μάρτιος 2012 8 Ιανουάριος 2012 3 Δεκέμβριος 2011 7 Νοέμβριος 2011 13 Οκτώβριος 2011 6 Σεπτέμβριος 2011 8 Αύγουστος 2011 6 Ιούλιος 2011 2 Μάιος 2011 1 Μάρτιος 2011 9 Φεβρουάριος 2011 15 Ιανουάριος 2011 14 Δεκέμβριος 2010 9 Νοέμβριος 2010 2 Οκτώβριος 2010 11 Σεπτέμβριος 2010 1 Αύγουστος 2010 3 Απρίλιος 2010 2 Μάρτιος 2010 5 Ιανουάριος 2010 1 Οκτώβριος 2009 2 Σεπτέμβριος 2009 4 Ιούνιος 2009 5 Απρίλιος 2009 1 Μάρτιος 2009 3 Φεβρουάριος 2009 2 Δεκέμβριος 2008 3 Νοέμβριος 2008 10 Σεπτέμβριος 2008 1 Αύγουστος 2008 1 Ιούλιος 2008 9 Ιούνιος 2008 10 Tables with no clustered indexes or no indexes at all in SQL Server databases I have been delivering a certified course in MS SQL Server 2012 recently and I was asked a very interesting question If there is a way to find using T SQL tables in a database that have no clustered indexes or no indexes at all I have answered that this is possible and I provided with some scripts There a lot of tasks that we cannot perform through the GUI of SSMS So we have to search through the object metadata to get our answers We can query the catalog views and get all the information

    Original URL path: http://www.dotnetzone.gr/cs/blogs/dotnetrules/archive/2013/11/18/tables-with-no-clustered-indexes-or-no-indexes-at-all-in-sql-server-databases.aspx (2015-07-15)
    Open archived version from archive

  • Dot Net Rules : Looking into SQL Server page types
    XAML XHTML XML XML Literals Πλοήγηση Αρχική σελίδα Εκδηλώσεις Ιστολόγια Συζητήσεις Εκθέσεις Φωτογραφιών Αρχειοθήκες Ιστορικό Δημοσιεύσεων Ιούνιος 2015 4 Μάρτιος 2015 2 Ιούνιος 2014 1 Δεκέμβριος 2013 2 Νοέμβριος 2013 14 Οκτώβριος 2013 2 Σεπτέμβριος 2013 5 Ιούλιος 2013 1 Ιανουάριος 2013 8 Δεκέμβριος 2012 11 Νοέμβριος 2012 3 Οκτώβριος 2012 12 Σεπτέμβριος 2012 16 Αύγουστος 2012 6 Ιούλιος 2012 13 Ιούνιος 2012 3 Μάιος 2012 4 Απρίλιος 2012 15 Μάρτιος 2012 8 Ιανουάριος 2012 3 Δεκέμβριος 2011 7 Νοέμβριος 2011 13 Οκτώβριος 2011 6 Σεπτέμβριος 2011 8 Αύγουστος 2011 6 Ιούλιος 2011 2 Μάιος 2011 1 Μάρτιος 2011 9 Φεβρουάριος 2011 15 Ιανουάριος 2011 14 Δεκέμβριος 2010 9 Νοέμβριος 2010 2 Οκτώβριος 2010 11 Σεπτέμβριος 2010 1 Αύγουστος 2010 3 Απρίλιος 2010 2 Μάρτιος 2010 5 Ιανουάριος 2010 1 Οκτώβριος 2009 2 Σεπτέμβριος 2009 4 Ιούνιος 2009 5 Απρίλιος 2009 1 Μάρτιος 2009 3 Φεβρουάριος 2009 2 Δεκέμβριος 2008 3 Νοέμβριος 2008 10 Σεπτέμβριος 2008 1 Αύγουστος 2008 1 Ιούλιος 2008 9 Ιούνιος 2008 10 Looking into SQL Server page types I have been delivering a certified course in MS SQL Server 2012 recently and I was asked a very interesting question about SQL Server pages and what types of pages exist I had to explain to them about SQL Server architecture first Each data file is divided internally into pages Each page has a size of 8 kbytes In each of these pages data metadata indexes are stored 8 continuous pages of 8kbytes make up one extent which is 64kbytes If you make the calculations 16 extents make up 1 mbyte Extents are divided into 2 categories Uniform 8 pages belong to the same object e g table Mixed 8 pages do not belong to the same object The first 96 bytes of the page are also reserved for the page header Page header includes information like Page number Page type Free space per page The greatest size in bytes I can have in a page is 8060 bytes So the maximum record length I can have in a table is 8060 bytes If I have a table that its record length is 100 bytes that means I can have 80 records per page If I have 200 records I need 3 pages Each record belongs to only one page You cannot have half record in one page and another half in another Ι was asked to provide an example where we will see the various SQL Server page types and what happens when the row size is larger than 8060 bytes I have installed SQL Server 2012 Enterprise edition in my machine but you can use the SQL Server 2012 2008 Express edition as well I am connecting to my local instance through Windows Authentication and in a new query window I type you can copy paste USE tempdb GO CREATE TABLE largetable col1 VARCHAR 2000 col2 VARCHAR 8000 col3 VARCHAR max INSERT INTO largetable VALUES REPLICATE SQL Server 2012 will provide Mission Critical Confidence with greater

    Original URL path: http://www.dotnetzone.gr/cs/blogs/dotnetrules/archive/2013/11/18/looking-into-sql-server-page-types.aspx (2015-07-15)
    Open archived version from archive



  •