Invoke or BeginInvoke cannot be called on a control until the window handle has been created..

If you installing new instance of SQL Server 2008 or adding new features to an existing one and got this error

SQL Server Setup has encountered the following error:
Invoke or BeginInvoke cannot be called on a control until the window handle has been created..

I won’t recommend you to go to
http://support.microsoft.com/kb/975055
 and waste your time installing SQL Server 2008 SP 1 because it won’t solve the problem.

Solution
Close IE\Explorer windows or anything you can open after doing your installation process yes that’s it… weird..

SQL Server 2005/2008 errors during installation

2 days to install SQL Server 2008\2005 each time I try; It fails with this error

The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, “How to: View SQL Server 2005 Setup Log Files” and “Starting SQL Server Manually.”

For help, click:
http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29503&EvtType=sqlsetuplib%5cservice.cpp%40Do_sqlScript%40sqls%3a%3aService%3a%3aStart%40x41d

To solve the problem I had to disable the antivirus (BitDefender -what I’ve-) seems it prevents the windows installer to start any services! to over come this prevention stop your antivirus.

Another error message may appear after you install\uninstall SQL Server due to errors in installations…

SQL Server Setup has encountered the following error: The given key was not present in the dictionary..

although I’ve valid\legal SQL Server serial number I don’t know from where this error comes! what I had to is to install “Windows Install Clean Up” to clean any SQL Server installation. download it from
http://support.microsoft.com/kb/290301

After installing SSRS! You can’t manage Reports site

It’s just a quick tip after you’ve successfully installed SQL Server Reporting Services on Windows Vista or Windows 7, you go to http://{Server-Name}/reports which redirects you to http://{Server-Name}/reports/Pages/Folder.aspx you find out that you can’t control anything and the site looks like this

Don’t worry what you should do is to, right click on Internet Explorer or your favorite browser then run as administrator and retype your SSRS Reports site URL http://{Server-Name}/reports you’ll find you can manage everything as you see

To not open your browser as administrator everytime you manage your Reports you should add your current user as Content Manager or as you wish. From Properties-> New Role Assignment -> Type the username of current user -> Select role -> OK

Open it without run as administrator it will look like as you want.

Replication Error “SQL Server is unable to connect to server..”

If you’re working in SQL Server Replication, you may get this message
SQL Server is unable to connect to server ‘Your server name‘.

SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, ‘Another server name‘. (Replication.Utilities)

It always appears as you change the instance name manually or network administrators change the computer name.

Actually your server name still as it’s and not changed with above changes so to avoid getting this message you should write these couple of T-SQL scripts every time you do one or all changes on the instance name

SELECT @@SERVERNAME – you’ll get a strange name, you may didn’t see it before…

GO

sp_dropserver ‘Old server name’ – you got it from pervious select.

GO

sp_addserver ‘SQL server instance name’,'local’ – the name of current instance.

GO

Then, restart the service, and go on you replication work…

SSIS insert bulk of data into remote table with trigger

hmmm, nice we have SSIS it makes life easier but it usually comes with non-understood problems like

“SQL Server Destination” (2185) failed with error code 0xC0202071 it means when you insert data into table in remote SQL Server don’t use SQL Server Destination component however use OLE DB Destination component, thank you SQL Server Central

Anyway I used OLE DB Destination component and everything went well but I found the trigger which updates something doesn’t fire simply because I do bulk insert and I should tell the BIDS please fire it.

So, right click on OLE DB Destination component then Show Advanced Editor… Component properties FastLoadOptions write FIRE_TRIGGERS

Thank you Piotr Rodak

SQLCLR or T-SQL? A Brief Survey of Performance Options

Session #19: SQLCLR or T-SQL? A Brief Survey of Performance Options

Event: 24 Hours of PASS

Presenter: Adam Machanic

Download

Delivering Good Performance Consistently with SSIS

Session #1:

Event: 24 hours of PASS

Presenters:

Session #4: Delivering Good Performance Consistently with SSIS

Event: 24 Hours of PASS

Presenter: John Welch

Download

Tips and Tricks for Writing SET Based Queries

Session #8: Tips and Tricks for Writing SET Based Queries

Event: 24 Hours of PASS

Presenter: Jacob Sebastian

Download or
http://beyondrelational.com/blogs/jacob/archive/2009/09/04/24-hours-pass-session-tips-and-tricks-for-writing-set-based-queries-scripts-download.aspx

10 Big Ideas in Database Design

Session #1: 10 Big Ideas in Database Design

Event: 24 Hours of PASS

Presenters: Paul Nielsen / Louis Davidson

1- Normalize your database.
2- Use keys (Primary, Foreign, Surrogate)
3- Generalize
4- Class not a table
5- Data Dives Design
6- Sets good, Cursors bad
7- Good datatype
8- Abstract\Encapsulate -> Extensibility
9- Don’t make your T-SQL code spaghetti
10- No lock no consistency

Resources: www.nycsqlusergroup.com