Thank you to everyone who attended my session at the Enertia User Conference in Las Vegas earlier this month! It was a blast meeting everyone, and I can’t wait...
2022-10-12 (first published: 2022-09-30)
169 reads
This is the third in the series of tools and technologies that I use to deal with the loss of functionality in my hands and arms. Check out this article for...
2022-09-14 (first published: 2022-09-01)
321 reads
Thank you to everyone who came out and saw me present at the SQL Saturday in Baton Rogue! It was a blast to see smiling faces and not be...
2022-09-09 (first published: 2022-08-23)
116 reads
Picture this, you have a report in Power BI that someone passes off to you for data quality checks. There are a few ways to make sure your measures...
2022-08-03 (first published: 2022-07-26)
526 reads
If you have excel data, or user-entered data, you have likely experienced frustration from repeatedly seeing the error message below upon hitting “Close & Apply” or refreshing your data...
2022-08-10 (first published: 2022-07-19)
223 reads
This is the second in the series of tools and technologies that I use to deal with the loss of functionality in my hands and arms. Check out this article for...
2022-07-15
36 reads
This is the first in the series of tools and technologies that I use to deal with the loss of functionality in my hands and arms. Check out this...
2022-07-08 (first published: 2022-06-24)
330 reads
I started this summary on LinkedIn. Check out that article here. I only used LinkedIn to introduce what is happening, if you’re interested in learning more keep reading. First,...
2022-06-16
23 reads
Knowing the days between events is a fairly common reporting request because a lot of reporting is created to track SLA’s (service level agreement) and other KPI’s (key performance...
2022-06-17 (first published: 2022-06-03)
283 reads
This post is a continuation of my adventure into the Tabular Object Model and how we can use it to make Power BI scalable and incorporate it into existing...
2022-06-06 (first published: 2022-05-12)
241 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...
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...
Hi we run 2019 ssas std. Yesterday i imported my tabular project to vs...
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