In one of my previous articles, I talked about Index Fragmentation in SQL Server in terms of how to track it and how to resolve it. In this post, we are going to see how to rebuild all the indexes of a database in SQL Server. The techniques explained in that post provided ways of … Read more…
Welcome to another screencast dedicated to SQL Server 2008 Programmability! This screencast again features the ADO .NET Entity Framework. The screencast demonstrates how the developer can create an entity data model in Visual Studio 2008, and goes one step further, thus demonstrating a simple way of using inheritance in the entity data model. Watch … Read more…
In this article, we will be discussing about how to rename logins in SQL Server. A Scenario Where You Might Need to Rename a Login in SQL Server When a Database Administrator creates Windows Logins in SQL Server, the format of these logins is: [Domain or Server Name]\[Windows Username] [Domain] can also be the … Read more…
Welcome to my first screencast dedicate to SQL Server 2008 Programmability! This screencast features the ADO .NET Entity Framework; a new feature of Microsoft .NET Framework 3.5 providing the developer with fast, robust and scalable data access. SQL Server 2008 fully supports the ADO .NET Entity Framework, allowing developers to effortlessly create entity data models … Read more…
We all know the saying: “A picture is worth a thousand words”. Well, what about a video? A screencast maybe? 🙂 Today I am initiating a series of screencasts dedicated to SQL Server Development and Administration – mainly for SQL Server 2008. Blogging is great of course and I will sure continue doing it as … Read more…
Is it possible to install 32-bit SQL Server 2005 Reporting Services on a 64-bit Computer/Windows OS while keeping the 64-bit version of the rest of SQL Server features? The answer is yes! The Scenario about Installing 32-bit SQL Server 2005 Reporting Services on a 64-bit machine/Windows OS Well, here’s the story: I recently installed … Read more…
As promised on my previous Entity Framework-related post I will try through a series of posts which will contain examples, to talk about the ADO. NET Entity Framework and all the cool features it provides the developer with. This post discusses Inheritance in ADO .NET Entity Framework. Inheritance allows creating entities having as base type … Read more…
DBAs and Database Developers always need to test new database-related work before migrating it to Production Environments. To this end, Test/Development Environments are usually set up in order to allow for testing new administration and programmability features of DBMSs (in our case SQL Server 🙂 Though, by only having such an environment set up is … Read more…
At Cyprus .NET User Group (CDNUG), we focus on Microsoft .NET and SQL Server technologies (for more information please read about CDNUG). We organize regular monthly events on the above technologies which, of course, are free to the public.This month’s event (May, 2009) is dedicated to Microsoft SharePoint Technologies.See below for event-specific details:——————————————————————–Topic: Microsoft SharePoint … Read more…
As its names implies, the tempdb database contains temporary data that is created during SQL Server operations, therefore, the tempdb growth is one significant issue that needs to be properly managed in SQL Server. Temporary data stored in tempdb system database Temporary data stored in temdb may include: temporary user objects (i.e. temporary tables, cursors), … Read more…
INETA Europe is now on Twitter! For keeping yourself up-to-date with all the latest activities of INETA Europe you can start following INETA Europe on Twitter! http://twitter.com/INETA_EU By following INETA Europe on Twitter you have the chance to directly get information about the latest events and contests supported by INETA Europe and much more!
Many people ask: “Where are temporary tables stored in SQL Server?” and that’s a very good question. There are many cases where we need to create temporary tables in SQL Server and for various reasons. Such reasons may include: Breaking the logic of a large and complex SQL Statement in smaller portions of code. Increase the … Read more…
TechNet and MSDN contain tons of information regarding Microsoft Technologies like: Books Online, Webcasts, Podcasts, White papers, Virtual Labs, Forums and much more! These resources help IT professionals and developers to efficiently use Microsoft Products. This post provides a list of free TechNet Resources. ———-Best Bets———- 1. TechNet Flash newsletter The biweekly TechNet Flash IT … Read more…
In this article, we will be discussing about index fragmentation in SQL Server and how you can manage it. SQL Server automatically maintains indexes whenever insert, delete, or update operations are performed on the underlying data. 1. The Two Types of Index Fragmentation in SQL Server Though, in the cases where the underlying data … Read more…
In this article, we will be discussing about a very useful built-in SQL Server Management Studio tool, that is the SQL Server Copy Database Wizard. About the Copy Database Wizard in SQL Server Management Studio There is many times where we might need to copy or move a database with the least amount of … Read more…