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
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
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
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,603 reads
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,902 reads
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)
4,967 reads
The agenda for the SQLBits event in May was announced today and after a quick look earlier today, it looks...
2013-02-13
621 reads
There is a new CU update for SQL 2012 SP1 and I noticed a very interesting new feature described in...
2013-01-25
1,500 reads
I bet you are half wondering what is the first? Well that would be the birth of my second child...
2013-01-17
781 reads
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,380 reads
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
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
I just learned that my database was created on my C:\ drive in the...
I am needing to migrate a MSSQL db to MySQL, on a different server...
Hi we run 2019 ssas std. Yesterday i imported my tabular project to vs...
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex] FILE = N'thirdone' , FILE = N'thirdtwo' , FILEGROUP = N'second' TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak' WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 GOSee possible answers