Apparently there's another MS sample database called Futon Manufacturing. Anyone ever encounter it in training materials? github.com/microsoft/sq... #sqlhelp
sql-server-samples/samples/databases/futon-manufacturing at master · microsoft/sql-server-samples
Azure Data SQL Samples - Official Microsoft GitHub Repository containing code samples for SQL Server, Azure SQL, Azure Synapse, and Azure SQL Edge - microsoft/sql-server-samples
github.com
July 14, 2026 at 8:23 AM
Apparently there's another MS sample database called Futon Manufacturing. Anyone ever encounter it in training materials? github.com/microsoft/sq... #sqlhelp
Has anyone ever seen the latch wait QUERY_OPTIMIZER_VD_MANAGER with a >99% occurrence? This is on an always-up-to-date GP managed instance with ~360 client databases. #sqlhelp
July 6, 2026 at 8:02 PM
Has anyone ever seen the latch wait QUERY_OPTIMIZER_VD_MANAGER with a >99% occurrence? This is on an always-up-to-date GP managed instance with ~360 client databases. #sqlhelp
Looking for some #SQLConfirmation more than #SqlHelp, but when you take away a stats modification_counter number from the potential stats update threshold and get a negative number...
Does that mean the stat wasn't evaluated in a query recently enough to get updated?
Does that mean the stat wasn't evaluated in a query recently enough to get updated?
June 30, 2026 at 12:36 PM
Looking for some #SQLConfirmation more than #SqlHelp, but when you take away a stats modification_counter number from the potential stats update threshold and get a negative number...
Does that mean the stat wasn't evaluated in a query recently enough to get updated?
Does that mean the stat wasn't evaluated in a query recently enough to get updated?
#sqlhelp I've got a weird situation where serverproperty('servername') used to look like 'servername.loction.com' but for some reason, after a restart it now just shows 'servername'. @@servername still shows the full path. Anyone know a way to change serverproperty('servername')?
April 8, 2026 at 2:24 AM
#sqlhelp I've got a weird situation where serverproperty('servername') used to look like 'servername.loction.com' but for some reason, after a restart it now just shows 'servername'. @@servername still shows the full path. Anyone know a way to change serverproperty('servername')?
Code pattern is:
SELECT
fmt.id
, fmt.name
FROM OPENROWSET(
BULK 'path\to.csv'
, FORMAT = 'CSV'
, FIRSTROW = 2
)
WITH (
id nvarchar(50)
, name nvarchar(100)
) AS fmt
Error is 'A correlation name must be specified for the bulk rowset in the from clause.' Only on SQL Server 2017. Thanks! 2/2
#sqlhelp
SELECT
fmt.id
, fmt.name
FROM OPENROWSET(
BULK 'path\to.csv'
, FORMAT = 'CSV'
, FIRSTROW = 2
)
WITH (
id nvarchar(50)
, name nvarchar(100)
) AS fmt
Error is 'A correlation name must be specified for the bulk rowset in the from clause.' Only on SQL Server 2017. Thanks! 2/2
#sqlhelp
February 11, 2026 at 7:17 PM
Anyone else having trouble with OPENROWSET BULK on SQL Server 2017, getting errors when trying to provide a schema definition? Doesn't happen on later editions, just 2017. (Also doesn't seem to like ROWTERMINATOR despite that being in the documentation, but that's a secondary concern.) 1/
#sqlhelp
#sqlhelp
OPENROWSET BULK (Transact-SQL) - SQL Server
OPENROWSET BULK function reads data from an external data source.
learn.microsoft.com
February 11, 2026 at 7:17 PM
Anyone else having trouble with OPENROWSET BULK on SQL Server 2017, getting errors when trying to provide a schema definition? Doesn't happen on later editions, just 2017. (Also doesn't seem to like ROWTERMINATOR despite that being in the documentation, but that's a secondary concern.) 1/
#sqlhelp
#sqlhelp
In PowerQuery you can reference a variable just by its name. But you can now also put an @ in front of the name. Is this just syntactic sugar, or does the @ add some extra functionality?
#PowerQuery #PowerBI #sqlhelp
#PowerQuery #PowerBI #sqlhelp
January 21, 2026 at 10:47 AM
In PowerQuery you can reference a variable just by its name. But you can now also put an @ in front of the name. Is this just syntactic sugar, or does the @ add some extra functionality?
#PowerQuery #PowerBI #sqlhelp
#PowerQuery #PowerBI #sqlhelp
#sqlhelp This feels like a stupid question but what permission is required to view a database in sys.databases? I have a SQL Id that has db_owner on databaseA, but can only see databaseA in sys.databases when the current context is databaseA.
January 6, 2026 at 9:43 PM
#sqlhelp This feels like a stupid question but what permission is required to view a database in sys.databases? I have a SQL Id that has db_owner on databaseA, but can only see databaseA in sys.databases when the current context is databaseA.
January 6, 2026 at 1:43 PM
#sqlhelp
Hey #sqlserver peeps!
I’ve spent hundreds of hours using Diskspd on Windows; hoping to use it for the first time on Linux today!
Any gotchas/rave reviews to share?
Thanks!
(Working with bursty read tests, up to 10000 mb/s with 64k random reads)
Hey #sqlserver peeps!
I’ve spent hundreds of hours using Diskspd on Windows; hoping to use it for the first time on Linux today!
Any gotchas/rave reviews to share?
Thanks!
(Working with bursty read tests, up to 10000 mb/s with 64k random reads)
December 4, 2025 at 6:32 PM
#sqlhelp
Hey #sqlserver peeps!
I’ve spent hundreds of hours using Diskspd on Windows; hoping to use it for the first time on Linux today!
Any gotchas/rave reviews to share?
Thanks!
(Working with bursty read tests, up to 10000 mb/s with 64k random reads)
Hey #sqlserver peeps!
I’ve spent hundreds of hours using Diskspd on Windows; hoping to use it for the first time on Linux today!
Any gotchas/rave reviews to share?
Thanks!
(Working with bursty read tests, up to 10000 mb/s with 64k random reads)
When you download #SQLServer 2025 RTM Std&Dev Edtn, by default it uses #PID "33333-00000-00000-00000-00000"
Is that actually Dev Edtn with only Std features ?
#SQLHelp
Is that actually Dev Edtn with only Std features ?
#SQLHelp
November 26, 2025 at 8:03 PM
When you download #SQLServer 2025 RTM Std&Dev Edtn, by default it uses #PID "33333-00000-00000-00000-00000"
Is that actually Dev Edtn with only Std features ?
#SQLHelp
Is that actually Dev Edtn with only Std features ?
#SQLHelp
Any tips for getting SQL Server Database Mirroring working on PC with 3 instances (primary, mirror and witness). PC not connected to domain so instances are run using a user account which is sysadmin on all 3. TCP enabled and mirror endpoint created, but won’t start as it fails to connect #sqlhelp
September 24, 2025 at 5:30 PM
Any tips for getting SQL Server Database Mirroring working on PC with 3 instances (primary, mirror and witness). PC not connected to domain so instances are run using a user account which is sysadmin on all 3. TCP enabled and mirror endpoint created, but won’t start as it fails to connect #sqlhelp
#sqlhelp Has anyone figured out a way to change the time zone setting on an Azure Managed Instance? I know the documentation says it's not possible, I'm just hoping it's wrong or out of date or maybe someone figured out a hack?
September 24, 2025 at 2:48 PM
#sqlhelp Has anyone figured out a way to change the time zone setting on an Azure Managed Instance? I know the documentation says it's not possible, I'm just hoping it's wrong or out of date or maybe someone figured out a hack?
#sqlhelp
I want to deploy a SQL db project to Azure SQL via GitHub actions. I'd like to deploy it as a data tier application and increment / set the version when I deploy via gh actions. How do I do that?
I want to deploy a SQL db project to Azure SQL via GitHub actions. I'd like to deploy it as a data tier application and increment / set the version when I deploy via gh actions. How do I do that?
September 3, 2025 at 5:45 PM
#sqlhelp
I want to deploy a SQL db project to Azure SQL via GitHub actions. I'd like to deploy it as a data tier application and increment / set the version when I deploy via gh actions. How do I do that?
I want to deploy a SQL db project to Azure SQL via GitHub actions. I'd like to deploy it as a data tier application and increment / set the version when I deploy via gh actions. How do I do that?
Does anyone know of a way to get the number of ghost records in a #sqlserver database without using dm_db_index_physical_stats? I don't want the impact on the primary of an AG or to block redo on the secondary when running it. #sqlhelp
September 2, 2025 at 6:17 PM
Does anyone know of a way to get the number of ghost records in a #sqlserver database without using dm_db_index_physical_stats? I don't want the impact on the primary of an AG or to block redo on the secondary when running it. #sqlhelp
I have observed 2 sql servers 2022 that consume significantly more CPU and with prolonged execution time after patching from CU 19 to CU 20.
Both running AMD Epyx.
Anyone else who has observed similar issue with CU20?
#sqlhelp
Both running AMD Epyx.
Anyone else who has observed similar issue with CU20?
#sqlhelp
September 1, 2025 at 4:22 PM
I have observed 2 sql servers 2022 that consume significantly more CPU and with prolonged execution time after patching from CU 19 to CU 20.
Both running AMD Epyx.
Anyone else who has observed similar issue with CU20?
#sqlhelp
Both running AMD Epyx.
Anyone else who has observed similar issue with CU20?
#sqlhelp
💡 Got a burning question about #AI, #PowerBI, or #MicrosoftFabric?
Purple Frog's expert consultants are here to help.
Drop your questions below, and we’ll answer them in upcoming posts! #DataAnalytics #SQLHelp #DataExperts #QandA
Purple Frog's expert consultants are here to help.
Drop your questions below, and we’ll answer them in upcoming posts! #DataAnalytics #SQLHelp #DataExperts #QandA
July 18, 2025 at 3:19 PM
💡 Got a burning question about #AI, #PowerBI, or #MicrosoftFabric?
Purple Frog's expert consultants are here to help.
Drop your questions below, and we’ll answer them in upcoming posts! #DataAnalytics #SQLHelp #DataExperts #QandA
Purple Frog's expert consultants are here to help.
Drop your questions below, and we’ll answer them in upcoming posts! #DataAnalytics #SQLHelp #DataExperts #QandA
Honest question for #SqlFamily ... Am I the only one who noticed that my computer gets all slow and stuttery every time I open the new #SSMS v21?
#SqlHelp #SqlDBA #SQLServer
#SqlHelp #SqlDBA #SQLServer
July 2, 2025 at 7:24 AM
Honest question for #SqlFamily ... Am I the only one who noticed that my computer gets all slow and stuttery every time I open the new #SSMS v21?
#SqlHelp #SqlDBA #SQLServer
#SqlHelp #SqlDBA #SQLServer
#sqlhelp anybody using SDK Database Projects in VSCode w/extension? Trying to get Schema Compare to save changes to my project and it keeps failing. Is ADS the only way to update the project currently? My GitHub action reBUILDs the dacpac to properly exclude things, so I need the project updated.
June 30, 2025 at 5:11 PM
#sqlhelp anybody using SDK Database Projects in VSCode w/extension? Trying to get Schema Compare to save changes to my project and it keeps failing. Is ADS the only way to update the project currently? My GitHub action reBUILDs the dacpac to properly exclude things, so I need the project updated.
June 18, 2025 at 11:00 AM