|
|
Πρόσφατες Δημοσιεύσεις
-
|
http://perlengkapanpernikahan.com/blog/gambar-pernikahan/ http://perlengkapanpernikahan.com/blog/kata-mutiara-pernikahan/ http://perlengkapanpernikahan.com/blog/ucapan-selamat-pernikahan/ http://perlengkapanpernikahan.com/blog/pernikahan-adat-palembang/ http://perlengkapanpernikahan.com/blog/kata-kata-undangan-pernikahan/ http://perlengkapanpernikahan.com/blog/dian-pelangi-wedding/ http://perlengkapanpernikahan.com/blog/paket-pernikahan-murah/ http://perlengkapanpernikahan.com/blog/mencetak-wedding-card/ http://perlengkapanpernikahan.com/blog/mahar-pernikahan/ http://perlengkapanpernikahan.com/blog/pengertian-pernikahan-dini/ http://perlengkapanpernikahan.com/blog/games-pernikahan-mendidik/ http://perlengkapanpernikahan.com/blog/wedding-invitation/ http://perlengkapanpernikahan.com/blog/kartu-ucapan-pernikahan/ http://perlengkapanpernikahan.com/blog/wedding-invitation-bahasa-inggris/ http://perlengkapanpernikahan.com/blog/hantaran-pernikahan/ http://perlengkapanpernikahan.com/blog/variasi-foto-wedding-yang-menarik/...
|
-
|
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...
|
-
|
I have been delivering a certified course in MS SQL Server 2012 recently and I was asked a very interesting question "Does the order of the column in an index matter?" Let's give some basic definitions first and make some analogies. A single column index is straightforward. Think of it as an index in the back of the book . Let’s say you want to learn about “ DBCC FREEPROCCACHE ” . You look for that command in the index of the book. The index does not have the information. It has a pointer to the page where the command is described.You turn to that page and read about it. This is a good analogy for a single column,non-clustered index In SQL Server you can also create an index that contains more than one column.This is known as the composite index . A good analogy for a composite index is the telephone book. A telephone book lists everyone who has publicly available a telephone number in an area.It is organised not by one column but by two:last name and first name.To look up someone in the telephone book , we first...
|
-
|
I have been delivering a certified course in MS SQL Server 2012 recently and I have found something that was really impressive regarding SET options in SQL Server and index creation. I will look into the SET QUOTED_IDENTIFIER and SET ANSI_NULLS options and how their values can affect index creation. 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) [sourcecode language="sql"] USE tempdb GO --create a sample table CREATE TABLE Customers ( Customer_ID INT NOT NULL IDENTITY(1,1), Last_Name VARCHAR(20) NOT NULL, First_Name VARCHAR(20) NOT NULL, Email_Address VARCHAR(50) NULL, Fullname AS first_name + '' + last_name ) SET QUOTED_IDENTIFIER OFF; SET ANSI_NULLS OFF; --create a clustered index on Customer_ID and --a non-clustered composite index on the fullname --index failed CREATE NONCLUSTERED INDEX ix_Customer_fName...
|
-
|
I have been delivering a certified course in MS SQL Server 2012 recently and I was asked to provide a demo about the MERGE statement. I will provide you with a demo in this post trying to explain more about the MERGE T-SQL statement and its use. This statement was introduced back to SQL Server 2008.We can use a MERGE statement to modify data in a target table based on data in a source table.The statement joins the target to the source by using a column common to both tables, such as a primary key. You can then insert, modify, or delete data from the target table—all in one statement—according to how the rows match up as a result of the join. You need to have SELECT permissions on the source and INSERT,UPDATE,DELETE permissions on the target. In this example I will create two tables, one source and one target table. I will use the WHEN MATCHED THEN clause to update rows in the target table that match rows in the source table. I have installed SQL Server 2012 Enterprise edition in my machine but you can use the...
|
-
|
With our next major release (13.2), we have simplified the manner in which you are able to add custom and computed fields to existing business models. The functionality is available to both developers and end-users. Once beta 1 is released, you can explore this new custom member functionality by exploring the FeatureCenter solution located in the C:\Users\Public\Documents\DXperience 13.2 Demos\eXpressApp Framework\FeatureCenter\CS folder. Design time As you know, XAF already offered the ability to create non-calculated persistent fields at design time using the Model Editor . In 13.2, we’ve extended the Application Model with an Expression attribute as illustrated in the image below. When the Expression attribute has a value, XAF will create a calculated member or it will default to the creation of a persistent member. Additionally, you can create a complex expression such as the Sum of another custom field as illustrated below. By design, XAF will not display these custom fields in any view since they were created...
|
-
|
In my last SQL Server 2012 administration seminar, I used Performance Monitor to analyse and troubleshoot issues regarding SQL Server. It is built into Windows and many administrators used it a lot in the old days when some of the tools we have now in our disposal did not exist. So this is a free tool that you do not need to download. Performance Monitor or PerfMon for short, can be used to monitor performance real-time, capture various metrics and you can select what you want to monitor and for how long.You can capture information about the hardware, the operating system, SQL Server and more.So it is not a tool for troubleshooting SQL Server only. The whole process is automated and so is the data collection. With PerfMon we can track nearly every type of system performance Disk Memory Cpu network The overhead of using PerfMon is minimal in most cases but you should be careful when selecting the sampling interval. One good advice is not to use too many counters and not sampling intervals less than one second....
|
-
|
In this post I will talk about SQL Server Traces, what they are and how we can use them. An SQL Trace is a low-level server-side event inside SQL Server that can be used to audit activity,troubleshoot performance debug T-SQL statements and stored procedures.With SQL Traces we can have a real-time or offline analysis of data.We can capture more than 150 events. It was introduced back in SQL Server 6.0. We can create a SQL Trace using the SQL Server Profiler . Alternatively you can use the sp_trace_create with the required parameters to create a new trace. Then you need to setup sp_trace_setevent with the required parameters to select the events and columns to trace. We can start traces manually or as a part of a scheduled job. Obviously as with all tools of such nature there is an overhead so you have to be careful. You should not add too many events in the same trace. I have installed SQL Server 2012 Enterprise edition in my machine but you can use any other version of SQL Server. I will connect to the local instance...
|
-
|
I have just finished a seminar in SQL Server 2012 and one of the topics I have explained thoroughly was Trace flags. In this post I will try to shed some light on what trace flags are and how we can use them. Trace flags are used to change the behavior of SQL Server . Please bear in mind that you should use them with caution. There are hundred of Trace flags that help us troubleshoot and optimise SQL Server installations. Before turning trace flags on, make sure you understand fully what they do. There are global trace flags ( server level ) that are enabled the entire time SQL Server is running. There are session trace flags . These trace flags are enabled and disabled at the client session level. Those flags influence only the current session. I will provide some hands-one demos. In the first one I will look into backups and trace flags. In the second demo I will look into deadlocks and trace flags. We use DBCC TRACEOFF/DBCC TRACEON flags to enable trace flags at both the global and session level. They do not...
|
-
|
I have just finished a seminar in SQL Server 2012 where the topic of "indexes" was again a very highly discussed topic. At one point I had to present a demo on covering indexes . In this post I will try to shed some light on covering indexes and their use. The right index on the right column is the basis on which query tuning begins. On the other hand a missing index or an index placed on the wrong column,or columns can be the basis for all performance problems starting with basic data access, continuing with joins and ending in filtering clauses. Placing the correct index(es) on table(s) is an art in itself. A covering index is simply an index that contains the value being queried. That means that the non-clustered index (covering index) will not use the clustered index to find the data asked from the query. The data is already in the clustered index.We avoid the lookup step. I have installed a SQL Server 2012 Enterprise edition in my machine. You can use SQL Server 2005/2008/2012 Express edition as well which...
|
-
|
I have just finished a seminar in SQL Server 2012 and some of the people attending it (from all walks of life) were asking me about dirty pages,what they are and if I can provide a demo. I will try to explain what dirty pages are and how they are flushed to finally to the disk. I will also provide a demo, where we can see the dirty pages of a database. SQL Server makes changes to the memory. So all our transactions take place in the memory. Pages are loaded to the memory (if they are not already there) and all the updates take place in memory. Dirty pages are the pages that have changed in memory since they were last loaded from disk. Those pages are written back to the disk through an SQL Server periodic scheduling functionality widely known as checkpoints. Checkpoints make sure that committed transactions are flushed to the disk. It also marks the transaction log so server knows where it has to recover from. I am going to use the Northwind database to make an update and then. You can use any database you want...
|
-
|
XAF includes the EasyTest functional test framework which as all DevExpress tools is an extensible beast. To learn more about EasyTest I suggest you go through our documentation. So, it was just about time to include a few projects in eXpandFramework to host custom commands and extensions contributed by our community. Starting from next eXpandFramework version 13.1.10 in the root of our repository you will find three extra projects which contain: The FillDataTimeValue command as described in How to: Implement a Custom EasyTest Command . The custom database operations to support Drop & Restore for SQLite , ASA, LocalDB contributed by Markus Dütting! The Drop and Restore Preprocessor Directives are already supported for Access, MSSql databases and to learn how to use them together with other commands look at EasyTest Script Reference . Following are some notes from Markus. SQLite : just deletes the file DBSourceLocation (DropDB) or copys the file (RestoreDB) specified by Backupfilename to DBSourceLocation. Tested...
|
-
|
Recently in one of my SQL Server seminars, I was asked to give a short introduction and a demo on SQL Server Extented events. In this post I will explain what Extended Events are and provide a hands on demo. SQL Server Profiler is (was) the main tool for DBA admins and developers to find out why there were performance issues with SQL Server queries and troubleshoot them. DBAs also use sql traces, DBCC commands and trace flags for performance related issues. Now we have an additional tool in our disposal. We have SQL Server Extended events which were firstly introduced in SQL Server 2008. SQL Server 2008 introduced Extended Events which is a system for collecting event-driven data about a SQL Server instance and its databases. In SQL Server 2008 we had no GUI (wizards) for the extended events, In that version of SQL Server 2008 we had to write complex T-SQL statements to gather the information we needed to analyse. The results from those SQL queries was returned in an XML format and sometimes it was difficult to...
|
-
|
It’s been a while since I blogged about anything. I’ve been quite busy with a very interesting project that I hope I can share more news soon. There have been a lot of changes in my life, fortunately all positive, leading to this moment where I can publicly share my next move. Q1 of 2014 I’ll […]...
|
-
|
http://www.desainhuniansederhana.com/gorden-rumah-minimalis/ http://www.desainhuniansederhana.com/rumah-modern-minimalis/ http://www.desainhuniansederhana.com/rumah-mewah-minimalis/ http://perlengkapanpernikahan.com/blog/barang-seserahan-pernikahan/ http://perlengkapanpernikahan.com/blog/syarat-pernikahan-dalam-islam/ http://perlengkapanpernikahan.com/blog/undangan-pernikahan-murah/ http://perlengkapanpernikahan.com/blog/jenis-souvenir-pernikahan-unik/ http://perlengkapanpernikahan.com/blog/desain-undangan-penikahan/ http://perlengkapanpernikahan.com/blog/jenis-kado-pernikahan-unik/ http://perlengkapanpernikahan.com/blog/foto-pernikahan-itu-salah-satu-hal-yang-penting/ http://perlengkapanpernikahan.com/blog/memilih-jasa-dekorasi-pernikahan-yang-tepat/ http://perlengkapanpernikahan.com/blog/hindari-pernikahan-dini/ http://perlengkapanpernikahan.com/blog/mempersiapkan-cincin-pernikahan-sejak-dini/ http://perlengkapanpernikahan.com/blog/jenis-kartu-undangan-penikahan/ http://perlengkapanpernikahan.com/blog/persiapan-pernikahan-bagi-calon-pengantin/...
|
-
|
In a recent seminar I gave regarding SQL Server 2012 I was asked to clear a few things regarding SQL Server 2012 editions and their license options/pricing. In this post i will shed some light on this issue. I will start by talking about the various license costs per SQL Server 2012 editions. Please note that there is no datacenter and workgroup edition in SQL Server 2012 version . Before I go on I would like you to note that there is not a socket licensing anymore. A physical socket is what sits on the motherboard.This is where the processor fits. Multi-core is a physical processor that has many cores in it . For example you can have one socket with one processor that has four cores. Some people are confused with the term logical core. The new licensing model that is based on physical cores not logical ones. Logical cores is a term that refers to hyper-threading,meaning we can have logical cores from each physical core. In SQL Server 2012 Enterprise Edition we have a core-based licensing system. The cost is $6874.00...
|
-
|
I had a seminar in SQL Server 2012 recently and one of the people in my class asked me what is the best way to restore a In this post I will like to shed some light on the issue. As we all know we must include in our backup strategy, the system databases backup. We must backup the master and msdb databases regularly. If for some reason the master database becomes corrupt or missing , the SQL Server instance cannot be started. Master and tempdb cannot be repaired. Repair requires single-user mode, since master and tempdb cannot be put into single-user mode. If your SQL Server master database becomes corrupt, some people suggest to rebuild the master database, then start SQL Server, then restore the backup of the master database. I do not suggest rebuilding the master database.That is really time-consuming and you need to do a lot of trial-and-error, especially if have a cluster disk subsystem.Some people recommend the full re-installation of the SQL Server. Well that does not sound ideal as well. Instead, you can...
|
-
|
With the upcoming release of the eXpressApp Framework (version 13.2), we’re introducing a new way in which to create reports for your XAF powered application. Simply said, you’ll now be able to create your report using XtraReports within Visual Studio and effortlessly integrate them into your XAF applications. This is an introductory post for the ReportsV2 module and I’ll describe it in more detail once we release. For now, please keep in mind that this will ship as a beta. We are looking forward to your feedback so we can continue to improve the module to meet your specific requirements. To start using ReportV2, I’ll select it from the toolbox… Because ReportsV2 integrates XtraReports at design time, you can use all the examples and documentation form our Reports Team. As you might imagine, when creating reports with this new module, you’ll be writing code and creating your own custom template within Visual Studio using your language of choice (C#, VB.Net). XAF will allow you to preview and print these new templates...
|
-
|
http://www.desainhuniansederhana.com/rumah-minimalis-tipe-45/ http://www.desainhuniansederhana.com/denah-rumah-minimalis-2-lantai/ http://www.desainhuniansederhana.com/gambar-rumah-minimalis-1-lantai/ http://www.desainhuniansederhana.com/sketsa-rumah-minimalis/ http://www.desainhuniansederhana.com/desain-rumah-minimalis-2-lantai/ http://www.desainhuniansederhana.com/desain-rumah-minimalis-modern/ http://www.desainhuniansederhana.com/foto-rumah-minimalis/ http://www.desainhuniansederhana.com/rumah-minimalis-2013/ http://www.desainhuniansederhana.com/rumah-minimalis-tipe-36/ http://www.desainhuniansederhana.com/taman-rumah-minimalis/ http://www.desainhuniansederhana.com/desain-interior-rumah-minimalis/ http://www.desainhuniansederhana.com/cat-rumah-minimalis/ http://jagohp.com/harga-blackberry-bold-touch-9930-dan-spesifikasi/ http://jagohp.com/harga-blackberry-9900-bold-dakota-dan-spesifikasi/ http://jagohp.com/harga-blackberry-torch-9860-dan-spesifikasi/ http://jagohp.com/harga-handphone-polytron-november-2013/...
|
-
|
In my top ten list of difficult bugs I had to solve in C# in my professionali carreer reside two that both had to do with compile time code changes that I was not aware of. In this post I will describe both of them in detail in the hope that it will help someone out there searching for a solution to his own issue. Difference between properties with public accessors and public fields. What is the difference between declaring a property with public default accessors: public string demo {get;set;} Compared to declaring the same variable as a field? public string demo; It seems that there is none and we can use any one of the two with not much difference. Actually, one may argue that the usage of a "field" may be a littler faster since it does not lead to the generation of a method call as the usage of a "property" does. In other words if we are to disassemble the generated code (using ildasm ) you will see that the "field" declaration produces just a field (Class2) while the "property" variable results in a field...
|
-
|
A few weeks ago, the eXpandFramework released registration support as discussed in How to manage users (register a new user, restore a password, etc.) from the logon form . While users could register, the implementation process was still incomplete it was missing email notification. Thus, this post will discuss the new EmailModule which was made available beginning version 13.1.8.2. The module was designed following the workflow discussed in Declarative data auditing . In this post I will demonstrate how to install the module along with the registration functionality discussed in How to manage users (register a new user, restore a password, etc.) from the logon form in order to create three mail rules ( 1) When new user is registered. 2) When the password is forgotten. 3) When a new customer is created. In addition I will discuss how to restrict the EmailModue to sending emails only when a specific user role is logged in. 1) Installation To complete installation, drag & drop the EmailModule from the toolbox...
|
-
|
I am happy to announce one more contribution from the known to you Stephen Manderson the creator of Dashboard module and not only! Installation The reminders can be found in eXpand Scheduler module in version 13.1.7.12 and currently is available only for the windows platform (Stephen is working on the Web version as well!). So you only need to drag & drop the XpandSchedulerWindowsFormsModule into the module designer. Usage To enable reminders decorate a business object that implements IEVent with the Xpand.ExpressApp.Scheduler.Reminders.SupportsReminderAttribute. For example in the snippet we enable reminders for the TestEvent and only when the criteria match. [ SupportsReminder ( Criteria = "Customer is not null" )] public class TestEvent : Event { public TestEvent ( Session session) : base (session) { } // Fields... Customer _customer ; [ Association ( "Customer-TestEvents" )]...
|
-
|
I will provide a short discussion on how to extend XAF StateMachine module as per subject. By design when creating a new State the it is possible to restrict the transition to that State using Criteria. For example in the below image we see that the transition to the Completed state is allowed only to Administrators. When you try to make the transition to the Completed state a handled exception will be raised however our goal is to hide all transitions that criteria do not fit. So given the above requirement we need to write a controller that will go though all data hosted in the ChangeStateAction expose an event that will provide the state from external sources. You can explore the controller that describes this requirement at https://github.com/expand/eXpand/blob/master/Xpand/Xpand.ExpressApp.Modules/StateMachine/Controllers/ChangeStateActionController.cs The next step is to subscribe to RequestActiveState event of the above ChangeStateActionController and provide the Active state logic. Below is illustrated...
|
-
|
Last week I had the privilege to join many of our customers at Oliver’s XAF Training Class in Germany. I wanted to take the time and share with you what happened at the event – as it was an amazing week and highly recommend it to all XAF users. The location The hotel is located high in the mountains and the above an amazing landscape…a simply beautiful location. The agenda Day 1: The organizers (Oliver and John) did a great job with course content. You can see all the XAF courseware below. Day 1 started with XPO and how it works independent of XAF. Oliver is an XPO legend so the introduction was amazing and even I learned some new stuff. Oliver then took the time to describe XAF Domain Components and other data layer related subjects. The day continued with a number of hands on labs so everyone can learn by actually doing. To help get relaxed after a busy day of learning, we spent some time on the golf course. Day 2: The day started with instruction on editing and maintaining the model as well as standard...
|
-
|
If you need to customize the default templates consider going through the instructions posted by Michael Lang in our Support center . The issue I am talking about can be found at B234907 . Just download the pdf and follow the very detailed instructions. Big thanks to Michael! for this sharing this, let us know your questions/feedback by replying on the same issue....
|
|
|
|