How to disable SQL 2005/2008/2008 R2 Splash Screen for SQL Server Management Studio.

Are you tired of waiting for the Splash Screen to go away when launching SQL Server Management Studio. Well here is how you can get rid of it.

Go to the Properties of the SQL Server Management Studio Shortcut.

add a space to the end of the "Target:" and type -nosplash

Congratulations you have now disabled the Splash Screen.

SSRS - UAC Error on "First" login.

User ‘Domain\User’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

After you login the first time to SSRS you probably get the error message above. Well to fix this you can do the following.

1) Right click on Internet Explorer and run in Adminstrator mode
2) Type in the address localhost/reports
3) You will now be able to add the user to Site Settings and Folder Options.

Here is a reference link with screen captures.


http://www.soheib.com/technical-knowledge/sql-server-2012-reporting-services-uac-user-access-control/

Fifa 2012 - Playing online w/Guests vs. Online Friend

The person with the Guests - Start a head to head match.

The Online person - Wait on the Xbox Live screen with the friend. When the friend creates the game "Join Session in progress" as fast as possible.

Blank Page in SSRS 2008

I have been working on this report at work for hours and couldn't figure out my extra page. I made sure that I did not pass the borders and margin lines. I found this site that solved my issue.

http://www.bidn.com/blogs/dustinryan/ssis/492/blank-page-at-end-of-ssrs-2008-report

How to SELECT NON DISTINCT COLUMNS FROM A TABLE.

SELECT [COLUMN]
FROM [TABLE] T1
WHERE (SELECT COUNT(*) FROM [TABLE2] T2 WHERE T1.[COLUMN] = T2.[COLUMN]) > 1

This returns all of the non distinct (opposite of distinct) rows.


SELECT [COLUMN], Count(*)
FROM [TABLE]
GROUP BY [COLUMN]
HAVING COUNT(*) > 1

This returns what is distinct and how many rows there are that has the value.

Diablo 3 Nvidia Surround (3 Monitors) Taskbar Hide.

I was playing Diablo 3 with 3 monitors using Nvidia Surround. I encountered an issue with the windows taskbar being in the way so this is what I did to fix the issue.

1) Go to Nvidia Control Panel.
2) On the Top toolbar next to "Edit" choose "Desktop" then Surround Displays and make sure that "Confine Taskbar to Center Display" is not checked.
3) Go to the normal Windows Task bar right click on it and go to Properties.
4) In the properties check "Auto-Hide Taskbar"
5) Now Launch Diablo 3 with Surround turned on.
6) Make sure Diablo 3 is being ran on Full Windowed Mode.

Enjoy

BACKUP Your Systems/Databases!! - Pixar Story

http://www.myextralife.com/sitenews/backup-your-file-systems-by-pixar/