In this article, Marcin Policht looks at migrating existing SQL Server databases to Windows Azure, starting with identifying obstacles associated with such migrations.
2013-10-22
3,910 reads
SQL Server databases move around as an organisation’s data grows, applications are enhanced or new versions of the database software are released. If not anything else, servers become old and unreliable and databases eventually need to find a new home. Here's what to do when migrating your databases.
2013-06-12
4,842 reads
Continuing from Part 1 , our Migration Checklist continues: Step 5: Update statistics It is always a good idea to update the statistics of the database that you have just installed or migrated
2011-07-25
2,586 reads
It is a fact of life: SQL Server databases change homes. They move from one instance to another, from one version to the next, from old servers to new ones. They move around as an organisation’s data grows, applications are enhanced or new versions of the database software are released.
2011-07-18
3,616 reads
2010-08-27 (first published: 2010-08-25)
3,639 reads
We soon learn, in SQL Server, that heaps are a bad thing, without necessarily understanding how or why. Jonathan Lewis is an Oracle expert who doesn't like to take such strictures for granted, especially when they don't apply to Oracle. Jonathan discovers much about how SQL Server places data, and concludes from his experiments that heaps perform badly in SQL Server because you cannot specify a fill factor for them.
2010-07-23
3,312 reads
The final part of the series will examine full text catalogs and indexing, database collation, service broker considerations, encryption and high availability.
2009-10-02
3,303 reads
Part 2 of the database migration series examines setting database options, mapping database users to logins, recovery models, backups, and changing the code associated with configurations.
2009-09-22
2,503 reads
Migrating a database is often a task fraught with complications, this series examines the key issues in a simple checklist.
2009-09-16
3,369 reads
large Analysis Database migration (hundreds of gigabytes, hundreds of users and thousands of user MDX queries)
2009-04-14 (first published: 2009-04-13)
3,173 reads
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
I am getting the below error when I execute a SQL command in SQL...
I am getting the below error when I execute a SQL command in SQL...
Hi everyone. I have this table and this information. (left side of the image)...