Did you recently¬†installed Windows 7 on your Mac Book Pro and experience problems while watching movies or YouTube videos? This problem is comming from your audio drivers. It seems that whenever you play something on your laptop and because the microphone is always open your sound card is trying to eliminate noise and this causes… Read Article →

Ever wanted to get the current time and date from the SQL Server to avoid different times between yous server and the clients (for example having a centralized application running on many countries) ? Using LINQ to SQL there is no way to get the time from the database build in the class. What you… Read Article →

About a month ago in Greece most of the TV Channels changed their broadcast type to Digital (DVB-T). I was waiting for this change for quite some time now since i have my Media Center PC connected at a Projector (720p). On the date of the change i turned my Antenna and started to search… Read Article →

If you upgrade your project to .NET Framework 4 or for any reason you get a mysterious error like the one below: “Could not load file or assembly ‘file:///C:\Program Files\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\dotnet1\crdb_adoplus.dll’ or one of its dependencies. The system cannot find the file specified.” Try inserting the code below at your app.config… Read Article →

The day of the week can be retrieved in SQL Server by using the DatePart function. The value returned by function is between 1 (Sunday) and 7 (Saturday). To convert this to a string representing the day of the week, use a CASE statement. Method 1: Create function running following script: CREATE FUNCTION dbo.udf_DayOfWeek(@dtDate DATETIME)… Read Article →

This is a SQL Script that Cleans your Database Records & resets Identity Columns, and it is all in 6 lines! /*Disable Constraints & Triggers*/ exec sp_MSforeachtable ‘ALTER TABLE ? NOCHECK CONSTRAINT ALL’ exec sp_MSforeachtable ‘ALTER TABLE ? DISABLE TRIGGER ALL’ /*Perform delete operation on all table for cleanup*/ exec sp_MSforeachtable ‘DELETE ?’ /*Enable Constraints… Read Article →

Today I lost about 2 hours trying to find a way to run the latest Messenger version on my Windows XP 64bit installation since the old version i had (8.5) stopped working for no apparent reason. It seems that Microsoft stopped the support for 8.5 clients (I was prompt to update and could not log… Read Article →

Simply start a new query window for the database and use the statement below: SELECT object_name(i.object_id) as objectName, i.[name] as indexName, sum(a.total_pages) as totalPages, sum(a.used_pages) as usedPages, sum(a.data_pages) as dataPages, (sum(a.total_pages) * 8 ) / 1024 as totalSpaceMB, (sum(a.used_pages) * 8 ) / 1024 as usedSpaceMB, (sum(a.data_pages) * 8 ) / 1024 as dataSpaceMB FROM… Read Article →

Scroll To Top