Supported Collations of MS SQL Server

Supported Collations of MS SQL Server

The following T-SQL code will generate a list of supported collations on MS SQL Server:

SELECT name, description FROM ::fn_helpcollations();

- - - - - - - - - - - - - - - - -

Applies To: SQL Server 2016, SQL Server 2014 and SQL Server 2008

Is 443 TCP Port Listening?

Is 443 TCP Port Listening?

To get answer for this question in the CMD window write:

   netstat -ano | findstr "443"

ApplicationPoolIdentity

ApplicationPoolIdentity

ApplicationPoolIdentity is actually the best practice to use in IIS7. It is a dynamically created, unprivelaged account. To add file system security for a particular application pool see IIS.net's "Application Pool Identities". The quick version:
If you application pool is named "DefaultAppPool" (just replace this text below if it is named differently)

1. Open Windows Explorer
2. Select a file or directory.
3. Right click the file and select "Properties"
4. Select the "Security" tab
5. Click the "Edit" and then "Add" button
6. Click the "Locations" button and make sure you select the local machine. (Not the Windows domain if the server belongs to one.)
7. Enter "IIS AppPool\DefaultAppPool" in the "Enter the object names to select:" text box. (Don't forget to change "DefaultAppPool" here to whatever you named your application pool.)
8. Click the "Check Names" button and click "OK".

Open Ports to Use iOS and Android Push Notification Services

Open Ports to Use iOS and Android Push Notification Services
 
In order to use iOS and Android Push Notification services, one need to open the following ports required by Apple and Google:

1) TCP ports: 5228, 5229, 5230, 5223, 2195, 2196, 443.

 

2) Allowing the firewall to accept outgoing connections to all IPs. 

3) Addresses contained in the IP blocks listed in Google's ASN of 15169.   

 

4) Allowing the firewall to accept connections for the entire 17.0.0.0/8 address block.

 

 

 

Oculus Rift

Oculus Rift

The Rift is a virtual reality head-mounted display developed by Oculus VR. It was initially proposed in a Kickstarter campaign, during which Oculus VR (at the time an independent company) raised US$2.5 million for the development of the product.^[5]
The Rift is scheduled for release in the first quarter of 2016, making it one of the first consumer-targeted virtual reality headsets. Oculus has described it as "the first really professional PC-based VR headset".^[4] It has a resolution of 1080×1200 per eye, a 90 Hz refresh rate, and a wide field of view.^[3] It has integrated headphones which provide spatialised audio. The Rift has rotational and positional tracking. The positional tracking is performed by a USB stationary IR sensor, which normally sits on the user's desk, allowing for using the Rift while sitting, standing, or walking around the same room.^[6] .... read more here:https://en.wikipedia.org/wiki/Oculus_Rift

New iOS Bug Crashing iPhones Simply by Receiving a Text Message

New iOS Bug Crashing iPhones Simply by Receiving a Text Message

Share

Tweet

----------------------------------------------

لُلُصّبُلُلصّبُررً ॣ ॣh ॣ ॣ
冗


----------------------------------------------

This Phrase is in red copied above. If you want to copy and try this text, you can use the following text box:

لُلُصّبُلُلصّبُررً ॣ ॣh ॣ ॣ 冗

JIRA Keyboard Shortcuts

JIRA Keyboard Shortcuts
What is JIRA? It is a proprietary issue tracking product, developed by Atlassian. It provides bug tracking, issue tracking, and project management functions.

JIRA Keyboard Shortcuts

Share

Tweet

  Global Shortcuts

• Go to Dashboard:

  g then d

• Next Item:

  j

• Browse to a Project:

  g then p

• Find Issues:

  g then i

• Previous Item:

  k

• Administration Quick Search:

  g then g

• Go to Tempo:

  g then t

• Log work with Tempo:

  w

• Quick Search:

  /

• Create an Issue:

  c

• Quick Operations:

  .

• Open shortcut help:

  ?

• Form Submit:

  Alt + Shift + s

Navigating Issues

• View selected Issue:

  o or Enter

• Next Issue:

  j

• Previous Issue:

  k

• Dock/Undock the Filters Panel:

  [

• Next Activity:

  n

• Previous Activity:

  p

• Focus search field:

  f

• Search for issues:

  u

• Switch filter view:

  t

• Detail View Order by:

  z

• Log work on issue:

  w

Issue Actions

• Edit Issue:

  e

• Assign Issue:

  a

• Comment on Issue:

  m

• Edit Issue Labels:

  l

• Jump to fields for editing:

  ,

• Log work on issue:

  w

• Assign To Me:

  i

Board Shortcuts

• Log work on issue:

  w