Shawn Weisfeld

I find when I talk to myself nobody listens. - Shawn Weisfeld
posts - 364, comments - 174, trackbacks - 34

My Links

News


Shawn Weisfeld's Facebook profile

The views expressed in this blog are mine and mine alone, not that of my employer, Microsoft, or anyone else’s. No warrantee is given for the quality of any material on this site.

Archives

Post Categories

October 2007 Entries

SQL Server 2005 Bulk Inserts

Need to dump a large amount of data into sql server? Have I got some tools for you! Recently I needed to, from a stored procedure, copy a large amount of data from a text file on the disk into my sql server. This is nice an easy with SQL Server 2005. You can write a simple INSERT INTO statement that will copy the data out of the flat file into your table. Instead of providing a table name in the from part of your insert just use the OPENROWSET option with the BULK keyword and poof your data is...

posted @ Friday, October 26, 2007 7:14 PM | Feedback (1) | Filed Under [ Microsoft SQL ]

Applying Computer Settings SLOOOOOW

Whenever I boot up my Windows XP SP 2 machine it hangs on the “Applying Computer Settings” screen for about 5 minutes. I found out that this might be due to the “Network Location Awareness (NLA)” service. After disabling this service in the Computer Management console everything went back to normal. Instructions: Right click on “My Computer” and select “Manage”. Open up the “Services and Applications” node then the “Services” node. Find “Network Location Awareness (NLA)” in the list and right click and select properties. Change the startup type to “Disabled” and then press ok. Reboot your computer and see...

posted @ Monday, October 22, 2007 12:10 PM | Feedback (0) | Filed Under [ Windows ]

Creating a Green-Bar (Zebra Stripe) Report on Groups in Reporting Services

Question: How do you create a green-bar (zebra stripe) report using groups in reporting services? Answer: I have seen many examples of creating green-bar reports where each record alternated colors. All one has to do is add a row_number field to their query and use the following expression in the Background color property of the Table Row. =iif(Fields!row.Value Mod 2 = 0,"Green","White") But when doing groups and you want each group to alternate colors it is a little more complex, but the trick is still the same. Following the same principal I needed a way to get row numbers for each Group...

posted @ Tuesday, October 16, 2007 10:34 AM | Feedback (0) | Filed Under [ Reporting Services SQL ]

.NET Cheat Sheet

A great article by Don XML on the differences between .NET 1.1, 2.0, 3.0, and 3.5 Great to explain to your boss what each version of the .NET framework can do! http://reddevnews.com/techbriefs/article.aspx?editorialsid=832  

posted @ Tuesday, October 9, 2007 8:08 PM | Feedback (0) | Filed Under [ .NET Microsoft ]

Central Florida Tech Fair

Here you can download my presentations from the CFL Tech Fair. http://onetug.net/Documents/CFL_Presentations.zip

posted @ Sunday, October 7, 2007 12:59 PM | Feedback (0) | Filed Under [ .NET ASP.NET C# Microsoft Robotics ]

Powered by: