Video Series: SQL Server 2005 Express Edition for Beginners(msdn.microsoft.com)

submitted by sotirisf(315) 5 years, 4 months ago

This video series is designed specifically for SQL Server beginners—individuals who are interested in learning the basics of how to create, manage, and connect to SQL Server Express databases. Whether you’re just a beginner or somewhat familiar with databases, these video lessons will help you get better acquainted with SQL Server 2005 Express. read more...

add a comment |category: Database |Views: 26

tags: SQLExpress Beginners SQL2005 SQL Videos another

Creating a simple, reusable Windows Service (template code) - Part II(dotnetzone.gr)

submitted by sotirisf(315) 5 years, 4 months ago

In part I, we examined how we can extend the Service Control methods by adding methods for all states of the Windows service in addition to the two methods provided by the designer. As you may remember, each of those methods called our own private Service Control method. Our private Service Control methods are implemented below: read more...

add a comment |category: VB.NET |Views: 38

tags: template threads Service another

Creating a simple, reusable Windows Service (template code) - Part I(dotnetzone.gr)

submitted by sotirisf(315) 5 years, 4 months ago

In this article, we'll see a way to create a simple Windows Service that can be reusable in that it can be used as the basis for any repeated operation that we would like to transform to a Windows Service.In other words, we can create our own assembly and then have the Windows Service call its entry point repeatedly over a period of time. By extending the code provided, you can even have multiple threads running at the same time. read more...

add a comment |category: VB.NET |Views: 358

tags: template threads Service another

Debugging ... With a fishbone(dotnetzone.gr)

submitted by sotirisf(315) 5 years, 4 months ago

Sounds familiar? The customer reports a problem that can't be reproduced. No errors were logged and no error messages generated. No-one can go to the customer's site for at least a day. All we have to work with are the symptoms reported by the customer and the source code. How do we find the bug with so little information ? read more...

add a comment |category: Other |Views: 1

tags: fishbone Debugging another

http://www.dotnetzone.gr/cs/blogs/pkefal/archive/2006/12/15/22322.aspx(dotnetzone.gr)

submitted by sotirisf(315) 5 years, 4 months ago

Today, i downloaded and tried to install Visual Studio Service Pack 1 (SP1) RTM but it refused to work properly on my PC. I was always getting an error that the file is not matching the version i have etc, so i tried to figure out what is wrong with my Visual Studio installation. read more...

add a comment |category: Visual Studio |Views: 1

tags: Pack sp1 Service Visual Studio another

Using a trigger to perform mass-update-safe, specific-field calculatio(dotnetzone.gr)

submitted by sotirisf(315) 5 years, 4 months ago

You’ve got a table which contains some information and you want to perform calculations based on this information and store them in the same table or in another table. The calculations must always be up-to-date. The calculations are performed via a complex User Defined Function which accepts the other fields’ values as parameters. The table has got thousands of rows and thus you do not want to use a view because it’ll degrade the overall performance. For the same reason, you do not want to use a calculated field. read more...

add a comment |category: Database |Views: 4

tags: Server mass calculation SQL trigger another

Conditional WHERE clauses in T-SQL using comparison operators(dotnetzone.gr)

submitted by sotirisf(315) 5 years, 4 months ago

Ever had a query where you wished you could be able to specify the operator (equal, not equal, greater than, etc.) for each column contained in your WHERE clause, without having to use ugly string concatenations and the infamous EXEC keyword? Here we'll see an example of how this can be achieved with the use of a plain SQL query together with some CASE statements. read more...

add a comment |category: Database |Views: 668

tags: comparison operator where SQL Server another