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
594 reads
SQL Server Rocks!
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
864 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,716 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,907 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,036 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
622 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,502 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
782 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,444 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
678 reads
Blogs
SQL Server Logins vs. Users: Why You Really Need to Know the Difference
By Kevin3NF
The Two-Layer Model Explained “We added them to the database, but they still can’t...
Using AI to Test a SQL Query
By Steve Jones
Someone sent me this code. WITH p AS ( SELECT ID, ROW_NUMBER() OVER (ORDER...
Your SQL Starting Line: Best Free Databases for Beginners
Wondering which database to tackle first? I’ve got the lowdown on the top free...
Forums
can ssrs detect rls and cls thru proxy like user ids?
Hi we often use non expiring windows and sql accounts to actually run (credential...
Changing the Paradigm of Work
Comments posted to this topic are about the item Changing the Paradigm of Work
Removing a File
Comments posted to this topic are about the item Removing a File
Question of the Day
Removing a File
I attempted to use ALTER DATABASE to remove a file from my filegroup in SQL Server 2022. There are 4 files in this filegroup, but I don't need them all. However, I received a message that the file was not empty. How do I empty this file so it can be removed?
See possible answers