Azure SQL Database Managed Instance is now private preview
Today is the day that Azure SQL Database Managed Instance is available for the world to explore. Private preview means...
2018-03-06
292 reads
Tim Radney - Database Professional
Microsoft to Decommission Connect on 12/31/2017
Microsoft will be decommissioning the Connect platform on 12/31/2017 due to privacy concerns and will be replacing it with a...
2017-12-11
437 reads
New Course: Implementing a Hybrid Cloud Solution in Azure
My latest Pluralsight course – SQL Server: Implementing a Hybrid Cloud Solution in Azure – is well over two hours and long and is based...
2017-12-11
582 reads
New Course: Understanding and Using Azure SQL Database
At SQLskills, we just launched our new training class on Azure that I will be teaching in Chicago, and my...
2017-04-27
880 reads
SQL Saturdays and Why We Have Them
There has been some recent controversy over SQL Saturdays after PASS HQ announced some new changes. The changes introduced a...
2016-08-19 (first published: 2016-08-18)
1,862 reads
SQL Server: Consolidation Tactics and Best Practices
My very first course has been published on Pluralsight – SQL Server: Consolidation Tactics and Best Practices. In this course I...
2016-07-21
1,485 reads
Microsoft SQL Server MVP
Today I received an email notifying me that I have been awarded the Microsoft “MVP” award for my second year....
2015-07-01
1,229 reads
I am joining SQLskills
I am no longer just a SQLskills Insider, I am now a SQLskills employee. I have accepted an offer to...
2014-12-19
1,302 reads
Getting Your Worth the Struggles with Moving Ahead
I often get asked for advice on how to get started in a career as a DBA or in IT...
2014-12-19 (first published: 2014-12-10)
6,989 reads
#Summit14 Embarcadero Book Signing
The blessings continue as Embarcadero offered to support my new book by hosting a book signing and providing 100 copies...
2014-11-04
1,051 reads
Blogs
A Little Brainstorming with an AI
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
The Mysterious Empty Table
By alevyinroc
It seems like no matter how long you work with a system beyond a...
Choosing to not drive the Tesla
By Steve Jones
I started a short thread on Twitter/X and Bluesky recently after leaving the Tesla...
Forums
Understanding Bit Manipulation Functions: BIT_COUNT, GET_BIT, and SET_BIT in SQL Server 2022
Comments posted to this topic are about the item Understanding Bit Manipulation Functions: BIT_COUNT,...
Mixed Backups
Comments posted to this topic are about the item Mixed Backups
Or condition in where clause works differently in MS SQL comparing with Sybase
Hello, I ran below statements in MS SQL, and got error, but fine in...
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