Search results

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...

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...

If you check your MSSQL Server Error Log and encounter an error "Cannot use Large Page Extentions. Lock memory priviledges was not granted", it means you are running SQL Server 64 bit, but did not grant the account running it the privilege to lock pages in memory. Please see our article: 'How...

We all have to make changes to our tables every now and then. Columns might have to be added or removed, moved around within the table definition, made NULLABLE or not to accept NULLS, or perhaps the column definition originally built proves to be too conservative, and thus column lengths will...

In case you are running SQL Server on a 32 bit Operating System, you will by default only be able to have to allocate a maximum of 4GB of RAM, 2 GB of which will be reserved for the OS. In most cases, especially once the server gets busier, 2 GB might just not be enough to cut it, resulting in...

Today, while working on setting up a master/target server configuration which should enable me to define jobs on a single master server and then rolling them out to all other servers defined as targets, I kept running into a specific issue. I could easily execute the job created on the master...

When you want to connect to a SQL instance on your local machine (and let's assume it has been installed as the default instance), there's a few ways you can do so. The machine-name of the server (i.e. TESTSQL) localhost 127.0.0.1 (the IP address that defaults to "localhost") The actual IP...

Registered servers come in use when you find yourself regularly connecting to different servers on the network (for instance when, like yours truly, you are in a DBA position), and thus provide easy access to the servers. There are several ways to setup a registered server: Prior to...