One of the many privileges of being a Friend of Red Gate, is that you have the chance to evaluate the company’s products and provide feedback and suggestions. In this post, I provide my review for one of Red Gate’s latest tools; SQL Object Level Recovery Native. What Does SQL Object Level Recovery Native … Read more…
Another great CDNUG event took place last Tuesday, October 27, 2009 at Microsoft-Cyprus. This event was “celebratory” as it was the first offline event after summer holidays. Of course summer was not an idle time. It was rather a great period of online events, and more specifically Live Webcasts! Among other, in July 29, I … Read more…
Time for another Cyprus .NET User Group (CDNUG) offline event! This is the first offline event right after the summer holidays and we decided to make it special; it features two great speakers and two great topics! To this end we have the pleasure to host two hourly sessions on two very interesting technologies. In … Read more…
If you encounter the error message “Saving maintenance plan failed” when trying to save a maintenance plan you created using the the wizard in SQL Server 2005 Management Studio (SSMS), the first (obvious) thing you should try, is to check if the latest service pack is installed and if it is not then install it! … Read more…
On September 19, 2009, I delivered a session with topic the Microsoft Sync Framework, during the Mysore SQL Server Community Series. The exact topic was: “Flexible data synchronization with Microsoft Sync Framework”. Further below I provide a short review for my session and I also provide the PowerPoint presentation along with the source code (C#) … Read more…
On September 2, 2009, I had the pleasure to deliver a session on ADO .NET Data Services, during that great SQL Server Marathon; 24 Hours of PASS! This great event was a series of 24 non-stop live, free webcasts dedicated to pure SQL Server knowledge. The exact topic of my session was: “Building Flexible Data … Read more…
Hi friends, in this article, we will be discussing about computed columns in SQL Server and see some relevant T-SQL examples. What are Computed and Persisted Columns in SQL Server? When it comes to database design in SQL Server, it is always recommended to create the database as flexible as possible. SQL Server provides … Read more…
Red Gate is a software company based in the university town of Cambridge, UK, specializing in MS SQL Server, .NET and email archiving tools. Red Gate is one of the strong supporters of the SQL Server, .NET and Exchange communities. A great example of this, are Red Gate’s well-known community web sites www.simple-talk.com and www.sqlservercentral.com. … Read more…
Newsflash: More free SQL Server training is on the way! The Mysore/Mandya Technology Group (MY-TG) organizes a series of SQL Server Webcasts which started on Saturday, September 12th, 2009 and will be taking place every Saturday for the next few weeks. To this end, every Saturday, two sessions are presented. Topics include SQL Server 2008 … Read more…
In my first post on SQL Azure (SQL Azure: A First Contact) I talked about how you can access SQL Azure using SQL Server 2008 Management Studio (SSMS). In this post, the journey continues with “walking” on the cloud using ADO .NET 🙂 Here’s the recipe! Ingredients: A valid SQL Azure account Visual Studio … Read more…
SQL Azure… Yep, that is SQL Server on the Cloud! A few days ago I received my SQL Azure (CTP) invitation code. The first thing I naturally did right after this was to create and access a database on the Cloud! I was very curious to see how I could interact with a database hosted … Read more…
I often think if the above two roles can be completely separated. From my point of view I would say that this is not 100% possible. Of course, DBAs are not developers and developers are not DBAs. The Role of the DBA The DBA is responsible for the environmental aspects of a DBMS like … Read more…
This article, discusses the usage of the “GO” command in SQL Server. But before proceeding with explaining GO, it is first necessary to understand what a “Batch” is. What is a “Batch” in SQL Server? As described in MSDN BOL, a Batch is a group of one or more Transact-SQL statements sent at the … Read more…
I got asked to present a one-hour SQL Server development session during the “24 Hours of PASS” event which starts on September 2, 2009, 00:00 GMT. The “24 Hours of PASS” is a series of live one-hour webcasts broadcast over a 24 hour period that focus on various SQL Server topics. The event is free … Read more…
SQL Server 2008 introduces among other new features and enhancements for accurately tracking Object Dependencies. This is very useful especially in cases where the user wishes to programmatically modify database objects having dependencies and therefore, he/she needs to resolve these dependencies before being able to proceed with the database object modification. For efficiently tracking dependencies … Read more…