SQL Azure–Failed to Update because the database is read-only
An error message for one of our many SQL Azure databases was brought to my attention today.
Msg 40628, Level 16,...
2012-10-05
2,340 reads
Blog Posts
SQL Saturday #149 Session Materials
This past weekend I attended this year’s SQL Saturday in Minnesota. It was a good time, and it was on...
2012-10-05
676 reads
Create a portable virtual machine with OVF or OVA
Today a great client asked me how to export a VM to an OVF or OVA so he could transport...
2012-10-04
1,555 reads
Finally, it has happened…
Last month I blogged about my absence from the blogosphere. If you want, you can read about it again – here. Granted, it has been a month and I...
2012-10-04
2 reads
Finally, it has happened…
Last month I blogged about my absence from the blogosphere. If you want, you can read about it again – here....
2012-10-04
943 reads
Jacksonville Code Camp 2012
Hello one, hello all. It has been quite a while since I have blogged. I am looking forward to starting...
2012-10-04
1,173 reads
Master Data Services (MDS): Bug deleting an attribute
UPDATE on 11/28/2012: I had this same error when trying to delete a model. Fortunately, SQL Server 2012 SP1 has...
2012-10-04
1,412 reads
Parallel Data Warehouse (PDW) How-To: Using BACKUP and RESTORE DATABASE on PDW
Before we get to the backup and restore syntax, its worth noting that the Parallel Data Warehouse (PDW) appliance architecture offers...
2012-10-04
5,429 reads
SharePoint dependencies
Microsoft has made a big push the last few years to have all its end-user BI tools integrate with SharePoint,...
2012-10-04
697 reads
SQL Server: Sending Email in HTML Table Format Using TSQL
As part of our DBA life , we have to configure many alert or statistical mails which gives an idea about...
2012-10-04
1,506 reads
Blogs
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Creating a SQL Stored Procedure to Load a SCD2
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers