Search results

I figured it would be nice to have a list of tools, guides and white papers that might come in handy when one starts playing around with SQL Azure. I'll try and keep this thread up-to-date. Tools The SQL Azure Migration Wizard allows you to migrate data from your existing SQL Server 2005 and...

Please note that the free offer described in this article is valid until Septermber 2011, and after that will be charged at regular rates. Yesterday, I started checking out SQL Azure. I figured that I would also use the Introduction offer that is available to all MSDN subscribers, and hook...

While looking into learning more about Azure, I came across a video made by Microsoft's Ola Ekdahl. In it, he shows a slide with some differences between your typical local installation of SQL Server and SQL Azure security. Seeing the slide might be useful to see in a more static way, I...

There's also a bunch of Technet videos: SQL Azure Connectivity Managing Logins Security in SQL Azure Creating Objets in SQL Azure Migrating a Database Schema to SQL Azure

SQL Azure Pricing Explained SQL Azure: Creating Your First Database Interacting with a SQL Azure Database

I'm in sales, why would I care about SQL Azure? How Do I: Configure SQL Azure Security? How Do I: Manage SQL Azure Firewall rules? Using SQL Azure Data Sync Service to provide Geo-Replication of SQL Azure databases Extending SQL Server Data to the Cloud using SQL Azure Data Sync

Windows Azure: Introduction to Database Manager for SQL Azure Windows Azure Platform Security Essentials: Security Architecture Windows Azure Platform Security Essentials for Technical Decision Makers Microsoft SQL Azure Security Model

Microsoft also made it possible to run Sql Server Reporting Services (SSRS) in Azure. This will allow you to move repoerts that might pose strain on your server into the cloud, where more computing power is available. It allows you to utilize almost every option available to you when you run...

Creating a SQL Azure database couldn't be easier. If you have not already done so, follow our guide which details on how sign up for a Windows Azure account. Once that is done, you can continue to the Windows Azure Management portal. Alternatively, you can always head over to...

To uninstall SQL Server 2008, open up your control panel, and select "Programs and Features" (using Windows 2008. On earlier versions, you have to use "Add or remove programs". Double-click the Microsoft SQL Server 2008 installation (In my case, the one marked with (64-bit)). You will be...

This morning, when attempting to start SQL Server Agent from within SSMS, it refused to start. When trying to check the properties of the SQL Server Agent to determine which credentials it was supposed to run under, SSMS prompted me with the following error: This is an error I never saw...

Windows Azure: SQL Azure Windows Azure: Sync Framework for SQL Azure Windows Azure: Introduction to Database Manager for SQL Azure What do Business Decision Makers need to know about SQL Azure? What does "IT as a service" mean in regard to SQL Azure?

What should I know about selling Solutions with SQL Azure? How can my customers benefit from SQL Azure? Where can I find Azure resources? What are the common SQL Azure Usage Scenarios? Can you show me some good SQL Azure Case Studies?

If you ever administrated a couple of servers, you will have come across the problem of figuring out exactly what it is you have installed on your machine. Are all the servers aligned, did you patch all systems with the same patches, etc? You will have probably run SELECT @@VERSION, and then...

At times, when dealing with SQL Server Administration, you will encounter error messages like the one I encountered today: Msg 5149, Level 16, State 3, Line 1 MODIFY FILE encountered operating system error 112 (failed to retrieve text for this error. Reason: 15105) while attempting to expand...

Hi there, and welcome to MSSQLForum.com :) Off the bat, I do not think what you want is possible, but a simple script could probably do the trick. You could query sys.all_views in the database for a list of all available views, and then use a WHILE loop to grab the view definition from the text...

While trying to port a client's database objects from an incomplete test environment to a new copy of their production system, we came across a few views that had some odd-looking code in it: EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[GUID VALUE, 1.00]… ' We tried...

With SQL Server 2005, SQL Server introduced the Dedicated Administrator Connection, which enables database administrators to connect if regular connections are not possible, for whatever reason. The admin connection can, by default, only be established from the machine itself; not from the...

Today at a client, when attempting to pull up the properties for a databsae through SQL Server Management Studieo (SSMS), we were greeted with the following error: Initially we assumed this was due to insufficient access rights, but after verifying we had sysadmin credentials, we still were...

In the 64 bit version of SQL Server, to use several gigabytes of RAM, one does not have to turn on AWE like in the 32 bit version of SQL Server. However, there is a setting that does have to be changed in order to take full advantage of this RAM that is potentially available to SQL Server, and...