T-SQL Tuesday #87 – Fixing Old Problems with Shiny New Toys: STRING_SPLIT
Thanks to Matt Gordon (@atsqlspeed) for hosting this T-SQL Tuesday.
Splitting Strings in SQL
A problem that has plagued SQL developers through...
2017-02-14
431 reads
DataOnWheels
Consumption Based Architecture for Modern Data Analytics
Throughout many years of working with BI solutions and data warehouse solutions, we have strived to put all the data...
2017-02-09
653 reads
North Texas SQL Server User Group – September 2016 Follow
Thanks for attending my presentation on window functions in TSQL during the September 15, 2016. I hope you learned something you...
2016-09-19
386 reads
Power BI Is Finally in the Azure Trust Center
With the most recent announcement of Power BI’s inclusion in the Azure Trust Center, it is a good time to review...
2016-05-11 (first published: 2016-04-28)
2,667 reads
JSON in SQL Server 2016 – The Good, The Bad, and The Ugly
Microsoft introduced support for JSON data in SQL Server 2016 and in Azure SQL Database. I was excited to see...
2016-04-20
703 reads
SQL Saturday #492 Follow Up – A Window into Your Data
Thanks for attending my session on window functions in TSQL. I hope you learned something you can take back and...
2016-04-16
462 reads
VS Live 2016 – Las Vegas Follow Up
I spoke at Visual Studio Live in Vegas on two topics. While the presentations have been uploaded to the site and were...
2016-04-11
415 reads
SQL Saturday #486 Richmond – A Window Into Your Data
Thanks for attending my session on window functions in TSQL. I hope you learned something you can take back and...
2016-03-19
534 reads
Excel Tip #30: Excel Services Visual Limitations – Displaying Images
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2016-03-14 (first published: 2016-03-04)
1,704 reads
Minnesota BI User Group – Powering Up HDInsight with Power BI (December 2015)
On Wednesday, December 16, I presented on this topic at the Minnesota BI User Group. This session is based on...
2016-02-04
556 reads
Blogs
Choosing to not drive the Tesla
By Steve Jones
I started a short thread on Twitter/X and Bluesky recently after leaving the Tesla...
Advice I Like: Transactions and Relationships
By Steve Jones
Life gets better as you replace transactions with relationships. – from Excellent Advice for...
Free PostgreSQL Performance Monitoring with pgNow
I’ve been putting together a new PostgreSQL session called “Performance Monitoring for the Absolute...
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