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,669 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,185 reads
By Steve Jones
I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece...
By Steve Jones
I’m in the UK today, having arrived this morning in London. Hopefully, by this...
I’m not trying to start up a debate whether you should use tabs or...
Hi there, Has anyone else had any trouble with Database Mail in Cumulative Update...
I have a script task that tries to execute a HTTP request, which seems...
Comments posted to this topic are about the item SQL Server 2025 Standard Developer...
If I use BASE4_ENCODE() in SQL Server 2025, is the output URL Safe by default?
See possible answers