The following T-SQL statements will print the logical name and physical location of system database files:
USE master;
GO
SELECT name, physical_name AS CurrentLocation, state_desc
FROM sys.master_files
WHERE database_id = DB_ID(N'master')
SELECT name, physical_name AS CurrentLocation, state_desc
FROM sys.master_files
WHERE database_id = DB_ID(N'tempdb')
SELECT name, physical_name AS CurrentLocation, state_desc
FROM sys.master_files
WHERE database_id = DB_ID(N'model')
SELECT name, physical_name AS CurrentLocation, state_desc
FROM sys.master_files
WHERE database_id = DB_ID(N'msdb')
Result:

This will get the list of all languages supported by the SQL Server 2008 Full-Text Search:
Code Snippet
- – to determine run_value corresponding to locale [LCID - LoCale IDentifier]
- SELECT lcid, name FROM sys.fulltext_languages
Result:
lcid name
———– ———————————————–
5124 Chinese (Macau SAR)
4100 Chinese (Singapore)
3098 Serbian (Cyrillic)
3082 Spanish
3076 Chinese (Hong Kong SAR, PRC)
2074 Serbian (Latin)
2070 Portuguese
…………….
1036 French
1033 English
1031 German
1028 Traditional Chinese
1027 Catalan
1026 Bulgarian
1025 Arabic
76 76
69 69
25 25
13 13
1 1
0 Neutral
(53 row(s) affected)
The following query will bring the list of system stopwords corresponding to the English locale:
Code Snippet
- – list all stopwords corresponding to 1033 locale [English]
- SELECT * FROM sys.fulltext_system_stopwords
- WHERE language_id = 1033
When this query is run 154 records containing system stopwords will be returned.
Here’s a documentation available from Microsoft:
http://www.microsoft.com/downloads/details.aspx?FamilyId=A3C9C3E3-11FC-446A-AC12-F6AD0749CB50&displaylang=en
Also, you can download it here:
Business Notification Installation Guide
Describes how to install the Business Notification Client and the Business Notification Server.
Microsoft Dynamics NAV 5.0 Security Hardening Guide
Recommends best practices for managing security with a Microsoft Dynamics NAV installation.
Application Designer’s Guide (w1w1adg.pdf)
Provides information about the C/SIDE development environment for Microsoft Dynamics NAV.
Installation & System Management: Application Server for Microsoft Dynamics NAV (w1w1atas.pdf)
Read more…
This example demonstrates the quick and simple way to match correct IP address.
MatchesDemo.zip


using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Text.RegularExpressions;
using System.Windows.Forms;
namespace MatchesDemo
{
public partial class IPValidate : Form
{
public IPValidate()
{
InitializeComponent();
}
private void btnValidate_Click(object sender, EventArgs e)
{
// MessageBox.Show(mtxtIPAddress.Text);
// create a regex object
Regex checkIP = new Regex (@"\b(?:(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.){3}(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\b");
// create match
Match matchIP = checkIP.Match(mtxtIPAddress.Text);
if (checkIP.IsMatch(mtxtIPAddress.Text))
{
mtxtIPAddress.ForeColor = Color.Green;
}
else
mtxtIPAddress.ForeColor = Color.Red;
}
}
}
This sample demonstrates use of default constructor, overloaded constructor, method and overloaded method in C#
Create new console C# console application.
Add the following code to Program.cs
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Text;
-
- namespace Classes_002
- {
- class Program
- {
- static void Main(string[] args)
- {
- // create new instance of the Calculate class
- Calculate calc1 = new Calculate();
-
- // call doCalculation method with the default Constructor
- Console.WriteLine(“default constructor: “ + calc1.doCalculation()+“\r”);
-
- // create another instance of the Calculate class
- Calculate calc2 = new Calculate(100);
- // call doCalculation method with the user variable passed to Constructor
- Console.WriteLine(“constructor that accepted user value: “ + calc2.doCalculation() + “\r”);
-
- // create another instance of the Calculate class
- Calculate calc3 = new Calculate();
- // call doCalculation method and pass to variables directly to method0
- Console.WriteLine(“method that accepts two double values: “ + calc2.doCalculation(25.35,10.12) + “\r”);
-
- Console.ReadKey();
- }
- }
- }
Add new class Calculate.cs with the following code
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Text;
-
- namespace Classes_002
- {
- class Calculate
- {
- // declare private variable for the class
- private int constantA;
-
-
- // declare initial value for default Constructor
- public Calculate()
- {
- constantA = 10;
- }
-
-
- // declare Constructor for input of user variable
- public Calculate(int a)
- {
- constantA = a;
- }
-
-
- // method that actually does the calculation
- public int doCalculation()
- {
- return constantA / 2;
- }
-
- public double doCalculation(double val1, double val2)
- {
- return val1*val2;
- }
-
- }
-
-
-
- }
This is a very simple example just to demonstrate how default and overloaded constructors work in C#.
Вот и появилась русская версия версия “Калькулятора желаний”. Для того, чтобы ваше желание исполнилось, необходимо ввести ваше имя, или имя человека, для которого кодируется желание, а затем само желание. Использовать необходимо лишь клавиатуру самой программы! Оба кода необходимо записать на какой-либо части человека, для которого кодируется желание. Этот метод на основе расчетов по СИМОРОНУ уже многих убедил в своей достоверности. Желания действительно сбываются! Попробуйте и напишите, сбылось ли Ваше желание!
Скачать
Personal Numbers Calculator is a small utility that makes calculations basing on your name and last name and suggests your number. Such calculation is based on numerology. Each alphabetical letter is assigned to a number, then all numbers are added until only one digit remains.
This utility is not going to be useful for those who do not believe in numerology and related beliefs. I’ve seen on some web forums people discuss calculations of the “personal number” or “lucky number” and this utility just expedites this calculation.
To use the Personal Numbers Calculator you will need mouse to input your name and last name from the virtual keyboard.
System requirements:
Windows 2000/XP/Vista
Dot Net Framework 2.0
Download
Please, leave your comments, opinions and ideas so I can keep on adding features!
Problem: After installing Internet Explorer 7 or 8 the web management interface of HP LaserJet 2600n printer is no more accessible.
Solution: Install latest firmware. Firmware download.
See the entire thread on HP support:
http://forums13.itrc.hp.com/service/forums/bizsupport/questionanswer.do?threadId=1212128&admit=109447627+1252318317348+28353475
This is a beta version of my Feng Shui Kua number calculator.
Just input your year, month and day of birth and Feng Shui Kua Number Calculator will calculate your Kua number, auspicious and inauspicious directions, your zodiac sign and year.
Years can be selected in the range from 1930 to 2039. These years are based on Chinese lunar calendar, so for example, if a person was born in the beginning-middle of January 1977 his year of birth according to Chinese lunar calendar is 1976 instead of 1977.
This application is very simple but useful for those who want to have a handy desktop tool to determine horoscope signs, Kua number and auspicious directions.
System requirements:
Windows 2000 / XP / Vista 32/64 bit
Dot Net Framework 2.0
Download
Please, leave your comments, opinions and ideas so I can keep on adding features!
I’ve developed this app for personal needs and I would like to share it with anybody who might need it, that’s why your comments are most welcome!
Here’s a PowerShell script that produces the list of desired file types (jpg, bmp, exe, dll, etc.)
Change $path=”C:\” to desired directory.
Change ‘.bmp’ to desired file extension.
If you need to find more that one file type, then add “-or ($file.Extension -eq ‘.some_extension’)” in the if statement, e.g.:
if (($file.Extension -eq ‘.bmp’) -or ($file.Extension -eq ‘.jpg’))
if (($file.Extension -eq ‘.bmp’)-or ($file.Extension -eq ‘.jpg’) -or ($file.Extension -eq ‘.gif’))
$path="c:\"
function showdir {
param (
$path
)
$files=Get-ChildItem $path
foreach ($file in $files) {
if ($file.PSIsContainer) {
showdir -path $file.FullName
}
else {
if (($file.Extension -eq '.bmp')) {
$f=gwmi -Class CIM_DataFile -Filter "Name='$(add_slhs($file.FullName))'"
Write-Host $file.FullName,$f.Version
}
}
}
}
function add_slhs($src) {
$dst=""
for ($i=0;$i -lt $src.length;$i++) {
if ($src[$i] -ne "\") {
$dst=$dst+$src[$i]
}
else {
$dst=$dst+$src[$i]+"\"
}
}
return $dst
}
showdir -path $path
Enjoy!