SQL Server 2016 available June 1st!
Woo hoo! Microsoft has announced that SQL Server 2016 will be generally available on June 1st. On that date all four...
2016-05-02
641 reads
Woo hoo! Microsoft has announced that SQL Server 2016 will be generally available on June 1st. On that date all four...
2016-05-02
641 reads
Pricing Azure SQL database is difficult because various database service tier options such as database transaction units (DTU’s), max database size,...
2016-04-22
2,061 reads
The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has just released an appliance update (AU5),...
2016-04-14
865 reads
There are so many benefits to the cloud, but one of the major features is the ease of use in...
2016-04-05
648 reads
I frequently present at user groups, and always try to create a brand new presentation to keep things interesting. We...
2016-03-29
905 reads
Azure SQL Data Warehouse (SQL DW) is a new platform-as-a service (PaaS) that distributes workloads across multiple compute resources, called massively parallel processing (MPP)....
2016-03-23
600 reads
I’m sure you are aware of Microsoft Azure, but are you aware there is special version of Azure for U.S....
2016-03-15
696 reads
Looks outside: pigs are flying!
In an announcement yesterday, SQL Server will be made available on Linux. The private preview of...
2016-03-08
899 reads
A limitation with Azure SQL database has been its inability to do cross-database SQL queries. This has changed with the...
2016-03-02
690 reads
No, Superdome X is not the name of the stadium where they played in the last Super Bowl. Rather, Superdome...
2016-02-25 (first published: 2016-02-24)
1,284 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...
Hi, Does anyone have experience with MEMORYBROKER_FOR_RESERVE ? when suddenly there is somehow constantly...
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...
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