Windows 7 search returns nothing (again)

I have been stumped by this a few times and it drives me crazy. The new windows OS’s are supposed to have the speediest search capability so far and yet when I search for files that I know exist, they cannot be found. The other day I was trying to clean up my harddrive and…

0

Windows Azure – DSInit fails – solution

Hi all, I hit an interesting undocumented hidden feature when using DSInit to set up the storage emulator database for my VS2010 projects.The documentation assumes that you have installed SQLExpress and indeed if you have the setup of the emulator will work fine. What however if you have your own SQL Server instance running? What…

0

What startup stored procedures are we running?

For some environments certain actions must be taken when SQL Server starts up. For some customers temporary tables or other types of transient objects must be present in the Tempdb. Developers or DBAs will then create “start up stored procedures” to ensure that when SQL Server starts up these procedures will execute. What happens if the…

0

SQL Server: Move a Table from the Primary Partition to a Secondary Partition

I get often asked by customers how they can best move data from their primary partition to a secondary partion. Often databases are created with a simple MDF & LDF set up and the data is on the Primary Default partition. One of the easiest ways to accomplish this task is to use the Create Index…

0

SSRS CLR deployment fails – VS 2010 & SQL Server 2008 R2

Hi all, You can deploy a CLR project to SQL Server 2008 R2 with Visual Studio 2010 however do not forget to set the target .Net version to 3.5. The default for VS 2010 is .Net 4.0 and this will cause a deploy error, (fails to deploy). I lost a some time fiddling with this…

0

Back online!

I am back online after a bit of a hiatus. Microsoft made some changes to the logon process and accounts in general. I was unable to sign in to my account for some time now. According to Microsoft:On January 27th, we have deployed Profile Integration to the MSDN & TechNet Blogs (http://blogs.msdn.com/b/help/archive/2011/01/21/integration-of-msdn-blog-user-account-with-msdn-forums-profile.aspx ).  This is…

0