user – SiliconSpots

Unix Administration

Check Apache web server version

yum list | grep -i http

1	yum list \| grep -i http

Check SSL version

yum list | grep -i ssl

1	yum list \| grep -i ssl

ASP.NET Report Viewer

Check for NULL values

=IIf(Fields!YourColumn.Value, Fields!YourColumn.Value, "Unknown")
=IIf(Fields!YourColumn.Value > 0, Fields!YourColumn.Value, "Unknown")

1 2	=IIf(Fields!YourColumn.Value, Fields!YourColumn.Value, "Unknown") =IIf(Fields!YourColumn.Value > 0, Fields!YourColumn.Value, "Unknown")

Check string contains substring

=IIf(Fields!Notes.Value.IndexOf("sample") >= 0,"Black","White")
=IIf(Fields!Notes.Value.ToLowerInvariant().Contains("sample"),"Black","White")

1 2	=IIf(Fields!Notes.Value.IndexOf("sample") >= 0,"Black","White") =IIf(Fields!Notes.Value.ToLowerInvariant().Contains("sample"),"Black","White")

SQL Server Database Development

Data Table Fundamentals Create table and insert data Add column to existing table

-- modify the Books table to include year published
ALTER TABLE Books
    ADD PublicationYear char(4);
GO
 
-- add publication years for the books in the table
UPDATE Books Set PublicationYear = '1877' WHERE Title = 'Anna Karenina';
UPDATE Books Set PublicationYear = '1869' WHERE Title = 'War and Peace';
UPDATE Books Set PublicationYear = '1922' WHERE Title = 'Ulysses';
UPDATE Books Set PublicationYear = '1815' WHERE Title = 'Emma';
UPDATE Books Set PublicationYear = '1813' WHERE Title = 'Pride and Prejudice';
UPDATE Books Set PublicationYear = '1931' WHERE Title = 'Brave New World';
GO
 
SELECT * FROM Books;
GO

-- modify the Books table to include year published

ALTER TABLE Books

ADD PublicationYear char(4);

-- add publication years for the books in the table

UPDATE Books Set PublicationYear = '1877' WHERE Title = 'Anna Karenina';

UPDATE Books Set PublicationYear = '1869' WHERE Title = 'War and Peace';

UPDATE Books Set PublicationYear = '1922' WHERE Title = 'Ulysses';

UPDATE Books Set PublicationYear = '1815' WHERE Title = 'Emma';

UPDATE Books Set PublicationYear = '1813' WHERE Title = 'Pride and Prejudice';

UPDATE Books Set PublicationYear = '1931' WHERE Title = 'Brave New World';

SELECT * FROM Books;

…