Crochet 54 : Christmas ornaments

Base is a plastic hoop for curtains 🙂
May be hung on a wall, and looks quite decorative.

I added some green glass pearls, and a crocheted ribbon.
Pattern is from a Christmas showflake.

and there are two orange themed ones.
With orange glass beads crocheted in the pattern :

And with a thicker yarn :

Posted in Relaxation | Tagged , | Leave a comment

Waldorf salad

Recipe for this salad I found on coolinarika site, and this here is mine version :

Ingredients :
1 medium celery
3 medium apples, peeled and grated
juice from one lemon
salt per taste
black pepper per taste
finely chopped walnuts (two handfuls)
one (small) 20%mm sour cream
mayonnaise per taste
I added finely chopped dill, celery leaf and parsley

Mix well, and put in a fridge to cool.

Posted in Uncategorized | Leave a comment

Marble cake

Mljac!
Dough :
4 whole eggs
sugar per taste
1 backing powder
This mix so that it is frothz, and slowlz add :
about 120gr of melted margarine
flour
grated lemon peel
juice from that one lemon
Mix all.
Divide dough into two same parts, and :
1. part : add vanilla sugar and a few drops of Dr Oetker vanilla extract
2. part : add cocoa powder (2 soup spoons) and chocolate crumbs
Pur first one part, than the other, in a kuglof mold which has previously been oiled and sprinkled with flour.
Bake in a preheated oven at about 180C.

Posted in Kitchen | Tagged , | Leave a comment

SQL query to another server

How to send a query to another server, while being attached to the first server?
There are two ways, from MSSQLSMS (Microsoft SQL Server Management Studio) :
1) Servers are linked :
sql-upit3
2) Under MSSQLSMS all the servers we wish to query are defined in one group :
a) Make agroup :
sql-upit4
b) Register a server :
sql-upit7
c) Move servers to the new group :
sql-upit5
d) Make a query over the whole group :
sql-upit6

Posted in WIN | Tagged , , | Leave a comment

SQL query : computer name

1) How to get computer name using SQL query :
select ServerProperty(‘ComputerNamePhysicalNetBIOS’);

2) And some additional info concerning SQL :
select ServerProperty(‘ComputerNamePhysicalNetBIOS’),ServerProperty(‘Edition’);

3) Product version :
select ServerProperty(‘ComputerNamePhysicalNetBIOS’),ServerProperty(‘MachineName’),ServerProperty(‘Edition’),ServerProperty(‘ProductLevel’);
Nore : first two items usually give the same output, so I prefer “MachineName”.
ProductLevel returns Level of the version of SQL Server instance :
‘RTM’ = Original release version
‘SPn’ = Service pack version
‘CTP’, = Community Technology Preview version

4) And at the end, to have a column name for data :
select ServerProperty(‘MachineName’) AS ‘Machine Name’,
ServerProperty(‘Edition’) AS ‘Product Edition’,
ServerProperty(‘ProductVersion’) AS ‘Product Version’,
ServerProperty(‘ProductLevel’) AS ‘Product Level’;

Good link with a list of some basic values that are gained from ServerProperty.
Link with a complete list of data that can be gained from ServerProperty.

5) And when I gather all the data about SQL and server :
select
cpu_count,
hyperthread_ratio,
[physical_memory_in_bytes]/1024/1024 AS [physical memory MB],
[virtual_memory_in_bytes]/1024/1024 AS [virtyal memory MB],
[bpool_committed]*8/1024 AS [bpool commited MB],
[bpool_commit_target]*8/1024 AS [bpool commited target MB],
ServerProperty(‘MachineName’) AS ‘Machine Name’,
ServerProperty(‘Edition’) AS ‘Product Edition’,
ServerProperty(‘ProductVersion’) AS ‘Product Version’,
ServerProperty(‘ProductLevel’) AS ‘Product Level’
from sys.dm_os_sys_info;

Posted in WIN | Tagged , , | Leave a comment

SQL query : CPU and RAM that DB uses

Query depends on the SWL server version that is being queried.
Query should always be done on “master” DB, soa s to gain data for the whole server :
sql-cpu1
sql-cpu2
The data gained from sys.dm_os_sys_infodepend on the SQL server version (link) :
SQL 2005 :
2289_columns_2005
SQL 2008 (link) :
2289_columns_2008
What data means can be gotten from here.
Some values, important for me, are :
cpu_count – Specifies the number of logical CPUs on the system.
hyperthread_ratio – Specifies the ratio of the number of logical or physical cores that are exposed by one physical processor package.
physical_memory_in_bytes – Specifies the total amount of physical memory on the machine.
virtual_memory_in_bytes – Specifies the total amount of virtual address space available to the process in user mode.
bpool_commited – Represents the committed memory in the memory manager. Does not include reserved memory in the memory manager.
bpool_commit_target – Represents the amount of memory, that can be consumed by SQL Server memory manager.

a) General query that gives all the data from sys.dm_os_sys_info table (for server SQL 2008) :
select * from sys.dm_os_sys_info;
b) And my query :
select
cpu_count,
hyperthread_ratio,
physical_memory_in_bytes,
virtual_memory_in_bytes,
bpool_committed,
bpool_commit_target
from sys.dm_os_sys_info;
c) And since data in bytes is not very useful :
select
cpu_count,
hyperthread_ratio,
[physical_memory_in_bytes]/1024/1024 AS [physical memory MB],
[virtual_memory_in_bytes]/1024/1024 AS [virtyal memory MB],
[bpool_committed]*8/1024 AS [bpool commited MB],
[bpool_commit_target]*8/1024 AS [bpool commited target MB]
from sys.dm_os_sys_info;

SQL 2012 (link) :
Column Name in 2008 -> Column Name in 2012
physical_memory_in_bytes -> physical_memory_kb
bpool_commit_target -> committed_target_kb
bpool_visible -> visible_target_kb
virtual_memory_in_bytes -> virtual_memory_kb
bpool_commited -> committed_kb

d) How to get all the data about version and similat things :
select @@version;
This is for (as far as I know) all SQL versions.

Posted in WIN | Tagged , , , | Leave a comment

Crochet 55 : head band

I had a bit of a grey wool handy, so….. 🙂
siva-traka
And the pattern I worked to :
sema-heklanja-traka-za-glavu1

Posted in Relaxation | Tagged , , | Leave a comment

WIN 2008 and a “Disc Cleanup” option which does not exist here

There is no option “Disc Cleanup” on WIN 2008.
To activate it, the following must be done :
1. Activate option “Desktop Experience” (link), which necessitates server restart before it activates
OR
2. Copying of two already existent files (link) :
Windows Server 2008 R2 – 64-bit – C:\Windows\winsxs\amd64_microsoft-windows-cleanmgr_31bf3856ad364e35_6.1.7600.16385_none_c9392808773cd7da\cleanmgr.exe
Windows Server 2008 R2 64-bit C:\Windows\winsxs\amd64_microsoft-windows-cleanmgr.resources_31bf3856ad364e35_6.1.7600.16385_en-us_b9cb6194b257cc63\cleanmgr.exe.mui
Windows Server 2008 – 64-bit – C:\Windows\winsxs\amd64_microsoft-windows-cleanmgr.resources_31bf3856ad364e35_6.0.6001.18000_en-us_b9f50b71510436f2\cleanmgr.exe.mui
Windows Server 2008 – 64-bit – C:\Windows\winsxs\amd64_microsoft-windows-cleanmgr_31bf3856ad364e35_6.0.6001.18000_none_c962d1e515e94269\cleanmgr.exe.mui
Windows Server 2008 – 32-bit – C:\Windows\winsxs\x86_microsoft-windows-cleanmgr.resources_31bf3856ad364e35_6.0.6001.18000_en-us_5dd66fed98a6c5bc\cleanmgr.exe.mui
Windows Server 2008 – 32-bit – C:\Windows\winsxs\x86_microsoft-windows-cleanmgr_31bf3856ad364e35_6.0.6001.18000_none_6d4436615d8bd133\cleanmgr.exe
*****
Once you’ve located the files move them to the following locations:
Cleanmgr.exe should go in %systemroot%\System32.
Cleanmgr.exe.mui should go in %systemroot%\System32\en-US.
*****
Note : %systemroot% is usually in c:/windows/
*****
You can now launch the Disk cleanup tool by running Cleanmgr.exe from the command prompt, or by clicking Start and typing Cleanmgr into the Search bar.

Posted in WIN | Tagged , , | Leave a comment

Web browser and a unwanted “startfenster.de” (browser hijacker)

My start conditions : WIN 7, IE 11, Chrome 54.0
If you have “caught” a unwanted addition in your web browser, of type : ” http://www.startfenster.de/suche/ as the homepage”, here is what is to be done :
WIN OS
From “Control Panel” uninstall “Startfenster.de” program, as well as anything else which you have not installed (and what looks suspicious). It can mask itself as a VLC-Updater.
Go through the whole of your PC with a couple of different antivirus/addware/malware softwares, just in case.
I have tried the following :
–+Symantec – except for a few cookies, did not find anything
+++AdwCleaner (link) – found and got rid of my malware, but is specifically for this
–+PlumBytes Anti-malware (link found some additional badies, but sadly must be payed for.
SpyHunter (link) – could not install it.
–+Malwarebytes (link) – must be started as administrator, and you must set your proxy (if you have it). When it starts its phase of “check for updates” takes a looong time. It found some baddies, and full version must be payed for. And free version did not want to delete tha bad things.
Ad-Aware (link) – I have tried with (of course) a free version, but it can not install
+++EmsisoftAntiMalware (link) – can be freely tested for 30 days, must have a proxy defined before it does a update. It detected a backdoor which no other AV saw.
+++HerdProtect (link) – free and in a Cloud, so it is very portable, scans for a very long time. He found a couple of PUPs, and one other startfenster bit!!!
-++IObit Malware Fighter (link) – it will try to set you up with a DashLane SW for passwords, so take care ;-), has a free and Pro version (BitDefender goes only with the Pro version). It scanned for a long time (over night) and found two more Trojans.

Only when you scan with all the above, will you see what baddies you got 🙂
After the whole rigmarole, restart is a must.

How to clean up your browsers :
IE 11
1. Go to “Internet options”
2. Go to “Options”
3. Click on “Manage Add-ons”
4. Put your provider as default.
If your provider is not on the list, go to link and add it.
5. Delete ALL from browser history : history/cache/cookies/etc.
Link1 and link2 for the lists I followed.
Google Chrome
Remove unwanted search engines.
Delete all from browser history/cache/cookies/etc.
Put about:blank as your start page.
FireFox
Remove unwanted add-ons

Good link about startfenster. But do not click on YAC for its removal, it is not a good one (link).
Some more good sites : link1 and link2.

PUP – potentially unwanted program

Posted in WIN | Tagged , , | Leave a comment

SQL queries

I am starting to work a bit with MS SQL.
Up until now all I have done were some small MySQL queries.
Good link for beginners, like me.
*****
A few things to begin with :
SQL stands for Structured Query Language
SQL lets you access and manipulate databases
SQL is an ANSI (American National Standards Institute) standard
SQL keywords are NOT case sensitive
*****
Some of The Most Important SQL Commands :
SELECT – extracts data from a database
UPDATE – updates data in a database
DELETE – deletes data from a database
INSERT INTO – inserts new data into a database
CREATE DATABASE – creates a new database
ALTER DATABASE – modifies a database
CREATE TABLE – creates a new table
ALTER TABLE – modifies a table
DROP TABLE – deletes a table
CREATE INDEX – creates an index (search key)
DROP INDEX – deletes an index
*****
A regular form for a SQL query :
SELECT column_name1,column_name2 FROM table_name;
SELECT DISTINCT column_name,column_name FROM table_name;
In this case we are seeking a unique combination of both columns.
SELECT column_name,column_name FROM table_name WHERE column_name operator value;
And “WHERE” clause may be for any of the values from named columns :
select distinct Name,Surname,FatherName from dbo.EMPLOYEES where Name=’VESNA’;
*****
Operators and their descriptions :
= Equal
<> Not equal. Note: In some versions of SQL this operator may be written as !=
> Greater than
< Less than >= Greater than or equal
<= Less than or equal
BETWEEN Between an inclusive range
LIKE Search for a pattern
IN To specify multiple possible values for a column
The AND operator displays a record if both the first condition AND the second condition are true.
The OR operator displays a record if either the first condition OR the second condition is true.
*****
SELECT column_name, column_name FROM table_name ORDER BY column_name ASC|DESC, column_name ASC|DESC;
*****
How to connect two tables from the same database, and show values from both, all in one query :
Tables are : Orders i Customers, and columns Orders.CustomerID i Customers.CustomerID are the same in both tables, and they are used to tie the tables together.
Query :
SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate
FROM Orders
INNER JOIN Customers
ON Orders.CustomerID=Customers.CustomerID;
SQL joins are used to combine rows from two or more tables.
*****
WildCards :
% A substitute for zero or more characters – used only with LIKE, not with =!!!!
_ A substitute for a single character – used only with LIKE, not with =!!!!
[charlist] Sets and ranges of characters to match
[^charlist] or [!charlist] Matches only a character NOT specified within the brackets
*****
Connecting data from tables
An SQL JOIN clause is used to combine rows from two or more tables, based on a common field between them.
The most common type of join is: SQL INNER JOIN (simple join). An SQL INNER JOIN returns all rows from multiple tables where the join condition is met (link).
The INNER JOIN keyword selects all rows from both tables as long as there is a match between the columns in both tables.
The LEFT JOIN keyword returns all rows from the left table (table1), with the matching rows in the right table (table2). The result is NULL in the right side when there is no match.
The RIGHT JOIN keyword returns all rows from the right table (table2), with the matching rows in the left table (table1). The result is NULL in the left side when there is no match.
The FULL OUTER JOIN keyword returns all rows from the left table (table1) and from the right table (table2).
The FULL OUTER JOIN keyword combines the result of both LEFT and RIGHT joins.
Visually (taken from odavde) :
visual_sql_joins_orig

Posted in WIN | Tagged , | Leave a comment