SQL in the City London 2013
Wow!
You’d think that an event might get a little worn by the third time you’re doing it. That maybe it...
2013-07-02
724 reads
The Scary DBA
Getting Started With SQL Server 2014 the Easy Way
You know you want to at least take a look at the new Client Technology Preview (CTP) of SQL Server...
2013-07-05 (first published: 2013-07-01)
2,145 reads
I Don’t Care
It’s funny how certain sentences can both accurately reflect a situation and communicate entirely the wrong message.
When thinking about cloud-based...
2013-06-24
731 reads
Azure First
Microsoft has been pretty clear about their commitment to the entire Azure infrastructure. The updates to Azure come out on...
2013-06-20 (first published: 2013-06-17)
2,249 reads
Praise and a Suggestion for AlwaysOn
One of my favorite additions to SQL Server 2012 is the Availability Groups, referred to as AlwaysOn. These things are...
2013-06-10
813 reads
Helping Database Administrators
Let’s be honest. Database administration is not all that tough. Set up your backups. Test them. Get consistency checks on...
2013-06-07 (first published: 2013-06-04)
1,760 reads
Using PowerShell to move files to Azure Storage
I was searching all over the place to try to find out how to move files into Azure Storage. Most...
2013-06-03
2,306 reads
Microsoft Teched 2013 Keynote
Welcome to Teched 2013
We’re starting off with some type of James Bond video. Chase scene with a really cool car....
2013-06-03
872 reads
Painting the US Red
We are bringing Red Gate, through the free SQL in the City event, to the United States again this year.
This...
2013-05-29
814 reads
SMO vs Invoke-Sqlcmd in Azure
I’m working on a series of Powershell scripts for the pre-conference seminars on Windows Azure SQL Database that I’m going to be...
2013-05-28
1,066 reads
Blogs
Azure SQL offerings
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
T-SQL Tuesday #183 Roundup
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
A Little Brainstorming with an AI
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
Forums
Moving Database Files
I just learned that my database was created on my C:\ drive in the...
Migrate MSSQL to MYSQL - Different Servers
I am needing to migrate a MSSQL db to MySQL, on a different server...
how do you manage new columns in a tabular table
Hi we run 2019 ssas std. Yesterday i imported my tabular project to vs...
Question of the Day
Mixed Backups
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
GO
See possible answers