Excel Apps – Not Quite Ready for Primetime
While this is not a regular Excel tip, but it is about Excel. In my Excel BI Tips series, I...
2015-01-22
1,089 reads
DataOnWheels
Excel BI Tip #17: Using the Timeline Filter
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2015-01-28 (first published: 2015-01-20)
6,806 reads
Part2 Adding a New CheckBox – Create your own SQL tools with PowerShell and Windows forms
Steve:
This is James’ second post on creating SQL tools with PowerShell and Windows forms. James is a DBA responsible for...
2015-01-19 (first published: 2015-01-14)
6,777 reads
Intro to Data Factory–Training on the T’s Follow Up Post
This is a follow up blog post based on the Intro to Data Factory session I gave on the Training...
2015-01-13
967 reads
She Taught Me to Code–A Tribute to Sheila, My Wife
A tribute is an expression of gratitude or praise. A couple of years ago, I started a series about individuals...
2015-01-12
742 reads
2014 Year In Review
As is our want, we must look back over the past year to see what happened. While I normally focus...
2015-01-11
613 reads
Create your own SQL Tools with PowerShell and Windows Forms
Steve:
Check out a new blogger who is sharing secrets of the DBA world. In his first post, James shows us...
2014-12-09 (first published: 2014-12-03)
7,211 reads
Power Testing ETL with Power BI – Creating the Tests with Power Pivot
This is the second deep dive into Power Testing ETL with Power BI. At this point, we have created the...
2014-11-13
1,159 reads
Power Testing ETL with Power BI – Shaping The Data with Power Query and Power Pivot
This blog post digs into the details of shaping the data with Power Query and Power Pivot in order to...
2014-11-19 (first published: 2014-11-12)
8,101 reads
Power Testing ETL with Power BI – The Process
This is a short blog series on using Power BI tools to support testing ETL processes. I have presented on...
2014-11-11
1,276 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
MEMORYBROKER_FOR_RESERVE experience
Hi, Does anyone have experience with MEMORYBROKER_FOR_RESERVE ? when suddenly there is somehow constantly...
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...
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