SQL Server 2014 CTP1 Released
It is here! the first CTP for SQL 2014 is available for download from the Technet evaluation centre... Just downloaded...
2013-06-25
595 reads
Art
Improved Backup/Restore to Azure in 2012 SP1 CU4
I’ve been using the backup to azure feature for a short while now and I really like it. Shows I...
2013-06-01
868 reads
There is currently a lease on the blob and no lease ID was specified in the request
I’ve been using the backup to Azure feature that shipped with SQL2012 SP1 CU2 and generally it works really well,...
2013-05-21
5,904 reads
How to backup a SQL 2012 database directly to Windows Azure
It has been a little while since I posted something and I’ve been meaning to finish off this blog for...
2013-04-24
1,916 reads
Retrieving the next or previous element node value in an Xml blob using XQuery
It’s been a little while since I wrote a blog post on my favourite subject but this is from a...
2013-03-20 (first published: 2013-03-13)
5,230 reads
SQLBits XI Agenda Announced
The agenda for the SQLBits event in May was announced today and after a quick look earlier today, it looks...
2013-02-13
627 reads
Backup SQL database directly to Azure Storage
There is a new CU update for SQL 2012 SP1 and I noticed a very interesting new feature described in...
2013-01-25
1,519 reads
SQLBits XI - My second most eagerly awaited event of 2013...
I bet you are half wondering what is the first? Well that would be the birth of my second child...
2013-01-17
784 reads
Using XQuery to remove duplicate values or duplicate nodes from an xml instance
Sometimes we need to retrieve a list distinct values from within an xml instance or even distinct nodes and this...
2012-12-20 (first published: 2012-12-13)
19,513 reads
Using Facebook to extend/enhance your blogging
I read a blog a few months ago by Ramkumar Gopal (blog) in which he had setup a Facebook page...
2012-11-22
682 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers