Collecting EventLogs with Powershell

Hi all,   I often have to go onsite and go through a customers’ eventlogs looking for errors. While the eventvwr does provide for nice filtering it doesn’t allow me to sort. I like to use Excel for sorting and making a nice table format. In order to do this however I need to be…

0

Powershell & Extended Events

I have been doing a lot of work with SQL Server lately. Over on www.sqlskills.com Jonathan Kehayias has written a series of very good blog posts regarding working with Extended Events. I could not however find very much information around Powershell and Extended Events. After some searching on MSDN and TechNet I was able to…

0

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

Writing to the EventLog from an Orchestration

Please be very careful with how you do this. This can be a disaster in a production environment (Imagine writing millions of messages to an eventlog)! I once saw an environment that was writing customer information in the EventLog (there is a very bad idea as anyone with rights to read the log can get…

0

Running BizTalk Documentor on a 64bit machine

The BizTalk Documentor is a great tool for auto-generating documentation for your environment. The tool can be downloaded here: http://biztalkdocumenter.codeplex.com/ If you have a 64bit environment then it will most likely not work for you. You can get around this by running with 32bit Coreflags on. You will need to have either the Win 2k?…

0