Tutorial by Examples: ed

Information about the database connections SELECT a.mon$attachment_id as Attachment_ID, a.mon$server_pid as Server_PID, case a.mon$state when 1 then 'active' when 0 then 'idle' end as State, a.mon$attachment_name as Database_Name, ...

Get-SPFeature -Site https://mysharepointsite/sites/test Get-SPFeature can also be run on web scope (-Web <WebUrl>), farm scope (-Farm) and web application scope (-WebApplication <WebAppUrl>). Get all orphaned features on a site collection Another usage of Get-SPFeature can be to find ...

If we have a Model as following, from django.db import models from django.contrib.auth.models import User class UserModuleProfile(models.Model): user = models.OneToOneField(User) expired = models.DateTimeField() admin = models.BooleanField(default=False) employee_id = models...

Less allows the usage of the parent selector (&) anywhere in a complex selector and thus allows changing styles when the current element is within another element which gives it a different context: For example, in the below code the parent selector is placed at the end and thus it actually be...

You want to add a signature to a PDF in a way that a standard conform PDF viewer (e.g. Adobe Reader) will recognize, display, and validate as an integrated PDF signature. In that case you cannot simply externally create a signature covering the original PDF as is and expect to now have to merely so...

Copy and Paste following class in your package: public class MLRoundedImageView extends ImageView { public MLRoundedImageView(Context context) { super(context); } public MLRoundedImageView(Context context, AttributeSet attrs) { super(context, attrs); } ...

To open an app with defined URL scheme todolist://: Objective-C NSURL *myURL = [NSURL URLWithString:@"todolist://there/is/something/to/do"]; [[UIApplication sharedApplication] openURL:myURL]; Swift let stringURL = "todolist://there/is/something/to/do" if let url = NSURL(s...

Set up some constants for the server and authentication information. Assuming LDAPv3, but it's easy enough to change that. // Authentication, and the name of the server. private const string LDAPUser = "cn=example:app:mygroup:accts,ou=Applications,dc=example,dc=com"; private readonly ch...

GC (Garbage Collector) is responsible for cleaning our garbage. While GC cleans our garbage, he removes the unused objects from the managed heap which cause heap fragmentation. When GC is done with the removal, it performs a heap compression (defragmintation) which involves moving objects on the he...

Exec sp_configure 'show advanced options' ,1 RECONFIGURE GO -- Show all configure sp_configure

A "Connection Refused" error will occur if your client sends a connection request to a remote server host, and the remote host responds to say that it refuses to accept the request. The "Connection Refused" error essentially means that the computer is not accepting connections to...

A "Connection timed out" error occurs when the remote system does not respond to the client's attempt to open a TCP/IP connection. The most common causes include: A firewall is blocking the connection attempt on the port that you are using: The firewall could be on the client-side, ...

A grouped VIEW is based on a query with a GROUP BY clause. Since each of the groups may have more than one row in the base from which it was built, these are necessarily read-only VIEWs. Such VIEWs usually have one or more aggregate functions and they are used for reporting purposes. They are also h...

VIEWs based on a UNION or UNION ALL operation are read-only because there is no single way to map a change onto just one row in one of the base tables. The UNION operator will remove duplicate rows from the results. Both the UNION and UNION ALL operators hide which table the rows came from. Such VIE...

$ bg [8]+ sleep 600 &

SELECT SERVERPROPERTY('ProductVersion') AS ProductVersion, SERVERPROPERTY('ProductLevel') AS ProductLevel, SERVERPROPERTY('Edition') AS Edition, SERVERPROPERTY('EngineEdition') AS EngineEdition;

If you are running a command that returns hundreds of lines, but your interest is just on the lines that contains the word <word>, you should definitely use grep! For example try running: ifconfig -a Check the output, that could be only a few lines or quite long, if you have a server with ...

See discussions in "GRANT" and "Recovering root password".

Modifying the strings returned by the standard functions getenv(), strerror() and setlocale() is undefined. So, implementations may use static storage for these strings. The getenv() function, C11, §7.22.4.7, 4, says: The getenv function returns a pointer to a string associated with the matched...

To Retrieve URL path in STATIC BLOCK Or CMS pages To get SKIN URL {{skin url=’images/sampleimage.jpg’}} To get Media URL {{media url=’/sampleimage.jpg’}} To get Store URL {{store url=’mypage.html’}} To get Base URL {{base url=”}} TO Retrieve URL path in PHTML Not secure Skin URL &...