Author: slimpy01
-
Visual Studio error while building solution
A modification in an SSIS packages results in an HRESULT:0x80041001 error message. What are the steps to solve this problem? Restart Visual Studio Open the solution once again from your workspace and rebuild the solution. Still getting the exception.? Get the latest code by selecting the Solution/SourceExplorer and Get Latest. This might result in this:…
-
SQL SERVER – How to Connect Using a computer name
It happens that you want to connect to an SQL Server using a System account. When you provision an Azure Sqlserver environment, the Sqlserver service accounts will be default NT AUTHORITY SYSTEM Account. To communicate with other Sqlservers, for instance, to support SSIS dataflow connections, you can then use the NT AUTHORITY SYSTEM Account to…
-
SQLSERVER does not start anymore on Azure because tempdb filepath is incorrect.
On Azure be very carefull where you put your tempdb-files. Always put them on the C-drive. When you change you VM-choice to another model you might no be able to start SQLserver anymore. This is because the only thing that will be the same when you switch the Azure VM will be the presence of…
-
Rollback is stuck
Sometimes your developers are overeager and are killing multiple database processes at once on your Sqlserver instance. Several hours later they approach you with the question of what to do. To decide if you should wait it out or restart the service is a decision that can be based on the following query in a…
-
TSQL Updating in batches
When you perform a SQL bulk update, you can just press go and wait. Most humans, though, get an increasing feeling of impending doom when the clock ticks up towards several hours with no visible progress. If you are running a transaction and have other things competing for the table, you’ll start hearing about slow downs as…
-
Session Validation for the alter operation failed , The value specified for the event attribute or predicate source duration is invalid.
Check my other post about creating an extended event in Sqlserver Management studio Using Extended events to find Long-running queries and
-
Using Extended events to find Long-running queries and
Sometimes you are encountered with mysteries on your database server. You have a beautiful alerting system that sends you emails about the Azure node when there are critical events so yo are well informed when some anomaly is going on on your Azure VM-machine. I received recently an email with a critical event. It was…
-
Sqlserver CPU 100% because of wrong memory estimates
Problem: I had a query ( query available down under) that was filtering the dbo.bla based on a @begindate and @enddate variable. The query took ages and eventually would timeout. When I use a hard value instead of a variable the query would run in 50 seconds. I have tested the query using hard date…
-
PHP trouble
Programming in PHP can be really depressing. Most trouble is due to version conflicts You just set up a new web-application for a client and everything is running just dandy. Suddenly the PHP version is being updated by the provider. You experience that your application crashes. This is the moment that you realize that PHP…