Sabbatical!
Redgate Software has a policy wherein every 5 years, employees receive a 6-week paid sabbatical. Well, I’m up to year 11 (I skipped a year my first time), so...
2022-07-18
3 reads
Redgate Software has a policy wherein every 5 years, employees receive a 6-week paid sabbatical. Well, I’m up to year 11 (I skipped a year my first time), so...
2022-07-18
3 reads
Scary Scalar Functions series overview
Part One: Parallelism
Part Two: Performance
Foreword
In the second part of this series, we’ll look at how Scalar functions (or UDFs) affect performance.
If you want to follow...
2022-07-18 (first published: 2022-07-02)
554 reads
SQL Saturday is coming back in-person to Los Angeles. I’ve been to this event a few times, and was sad when the pandemic pushed it virtual. However, 2022 is...
2022-07-18
8 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-07-15
35 reads
For more formal enterprise Power BI development, many people have a checklist to ensure data acquisition and data modeling quality and performance. Fewer people have a checklist for their...
2022-07-15
143 reads
I was reading a SharePoint List using the “Get Items” activity in an Azure Logic App. I explain how you can create such a Logic App in the blog...
2022-07-15 (first published: 2022-06-27)
108 reads
Recently PASS Data Community Summit sessions were selected and the wounds were opened on Twitter around speaker diversity in the community. I heard from several people via my DMs...
2022-07-15 (first published: 2022-06-30)
213 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
Last week I posted about a request to get a list of services. The first problem I ran into was ... Continue reading
2022-07-14
211 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-07-14
32 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