Name your #sqlserver default constraints, or there will be trouble.
Instead of...
ALTER TABLE dbo.table ADD col int NOT NULL DEFAULT (0)
... use...
ALTER TABLE dbo.table ADD col int NOT NULL CONSTRAINT DF_table_col DEFAULT (0)
And if you forgot, here's a script for you to help fix the database.
Instead of...
ALTER TABLE dbo.table ADD col int NOT NULL DEFAULT (0)
... use...
ALTER TABLE dbo.table ADD col int NOT NULL CONSTRAINT DF_table_col DEFAULT (0)
And if you forgot, here's a script for you to help fix the database.
Add name to system-named default constraints
Add name to system-named default constraints. GitHub Gist: instantly share code, notes, and snippets.
gist.github.com
November 8, 2026 at 6:29 PM
Name your #sqlserver default constraints, or there will be trouble.
Instead of...
ALTER TABLE dbo.table ADD col int NOT NULL DEFAULT (0)
... use...
ALTER TABLE dbo.table ADD col int NOT NULL CONSTRAINT DF_table_col DEFAULT (0)
And if you forgot, here's a script for you to help fix the database.
Instead of...
ALTER TABLE dbo.table ADD col int NOT NULL DEFAULT (0)
... use...
ALTER TABLE dbo.table ADD col int NOT NULL CONSTRAINT DF_table_col DEFAULT (0)
And if you forgot, here's a script for you to help fix the database.
Paradigma Software drops Valentina 18.4 — major Studio Query Editor upgrades for faster diagram-to-SQL workflows + unattended macOS Server install & Java 27 support. Free version of Studio and Server . Learn More [ valentina-db.com/en/discussio... ]
#java27 #datascience #sqlserver
#java27 #datascience #sqlserver
November 3, 2026 at 5:24 PM
Paradigma Software drops Valentina 18.4 — major Studio Query Editor upgrades for faster diagram-to-SQL workflows + unattended macOS Server install & Java 27 support. Free version of Studio and Server . Learn More [ valentina-db.com/en/discussio... ]
#java27 #datascience #sqlserver
#java27 #datascience #sqlserver
Incorrect. The language is "SQL". Microsoft SQLServer is "sequel server" though.
November 5, 2026 at 3:27 PM
Incorrect. The language is "SQL". Microsoft SQLServer is "sequel server" though.
Dew Drop Weekly Newsletter 507 - Week Ending November 6, 2026
buff.ly/IYkFHYg
#dewdrop #newsletter #cloud #aspnetcore #azure #javascript #css blazor #cpp #xaml #windowsdev #csharp #dotnet #ai #mcp #agile #devops #python #appdev #podcasts #m365 #sqlserver #data #terminal #cli #devtools
buff.ly/IYkFHYg
#dewdrop #newsletter #cloud #aspnetcore #azure #javascript #css blazor #cpp #xaml #windowsdev #csharp #dotnet #ai #mcp #agile #devops #python #appdev #podcasts #m365 #sqlserver #data #terminal #cli #devtools
Dew Drop Weekly Newsletter #507 - Week Ending November 6, 2026
Dew Drop Weekly Newsletter #507 - Week Ending November 6, 2026
buff.ly
November 6, 2026 at 12:43 PM
Dew Drop Weekly Newsletter 507 - Week Ending November 6, 2026
buff.ly/IYkFHYg
#dewdrop #newsletter #cloud #aspnetcore #azure #javascript #css blazor #cpp #xaml #windowsdev #csharp #dotnet #ai #mcp #agile #devops #python #appdev #podcasts #m365 #sqlserver #data #terminal #cli #devtools
buff.ly/IYkFHYg
#dewdrop #newsletter #cloud #aspnetcore #azure #javascript #css blazor #cpp #xaml #windowsdev #csharp #dotnet #ai #mcp #agile #devops #python #appdev #podcasts #m365 #sqlserver #data #terminal #cli #devtools
Happy birthday, Arthur Bowley (b. 1869), pioneer of survey sampling.
#SQLServer tip: TABLESAMPLE samples pages, not rows.
Our 10% sample: 187 runs of ~56 adjacent rows. A cluster sample.
For random rows (full scan + sort):
SELECT TOP (10) PERCENT *
FROM t
ORDER BY NEWID();
#SSMS #Statistics
#SQLServer tip: TABLESAMPLE samples pages, not rows.
Our 10% sample: 187 runs of ~56 adjacent rows. A cluster sample.
For random rows (full scan + sort):
SELECT TOP (10) PERCENT *
FROM t
ORDER BY NEWID();
#SSMS #Statistics
November 6, 2026 at 4:14 PM
Happy birthday, Arthur Bowley (b. 1869), pioneer of survey sampling.
#SQLServer tip: TABLESAMPLE samples pages, not rows.
Our 10% sample: 187 runs of ~56 adjacent rows. A cluster sample.
For random rows (full scan + sort):
SELECT TOP (10) PERCENT *
FROM t
ORDER BY NEWID();
#SSMS #Statistics
#SQLServer tip: TABLESAMPLE samples pages, not rows.
Our 10% sample: 187 runs of ~56 adjacent rows. A cluster sample.
For random rows (full scan + sort):
SELECT TOP (10) PERCENT *
FROM t
ORDER BY NEWID();
#SSMS #Statistics
https://buff.ly/48gHxFY Learn how to build more #secure #applications using the advanced #security features in #SQLServer, including Row Level Security, Always Encrypted, and more.
November 8, 2026 at 9:45 AM
https://buff.ly/48gHxFY Learn how to build more #secure #applications using the advanced #security features in #SQLServer, including Row Level Security, Always Encrypted, and more.
Cloud SQL SQL Server update on November 9, 2026 https://docs.cloud.google.com/sql/docs/sqlserver/release-notes#November_09_2026 #googlecloud The C4D machine series is available for Cloud SQL for SQL Server Enterprise Plus instances in the following regions: africa-south1 —
November 9, 2026 at 5:40 PM
Cloud SQL SQL Server update on November 9, 2026 https://docs.cloud.google.com/sql/docs/sqlserver/release-notes#November_09_2026 #googlecloud The C4D machine series is available for Cloud SQL for SQL Server Enterprise Plus instances in the following regions: africa-south1 —
In Visual Studio, Ctrl+Shift+F searches all files. In SSMS it silently switches to "Results to File": your next query asks where to save.
Find in Files: Ctrl+Shift+H
Back to grid: Ctrl+D
RenSQL for SSMS: run SQL without selecting, query history, SQL library. rowdyne.com/rensql
#SSMS #SQLServer
Find in Files: Ctrl+Shift+H
Back to grid: Ctrl+D
RenSQL for SSMS: run SQL without selecting, query history, SQL library. rowdyne.com/rensql
#SSMS #SQLServer
November 9, 2026 at 6:47 PM
In Visual Studio, Ctrl+Shift+F searches all files. In SSMS it silently switches to "Results to File": your next query asks where to save.
Find in Files: Ctrl+Shift+H
Back to grid: Ctrl+D
RenSQL for SSMS: run SQL without selecting, query history, SQL library. rowdyne.com/rensql
#SSMS #SQLServer
Find in Files: Ctrl+Shift+H
Back to grid: Ctrl+D
RenSQL for SSMS: run SQL without selecting, query history, SQL library. rowdyne.com/rensql
#SSMS #SQLServer
Fabric Warehouse on GPU: 3x to 7x Faster? Maraki & Conor | Fabric Insider Ep. 27
youtu.be/t7v-4nDWIJk
#MicrosoftFabric #FabricWarehouse #FabricInsider #GPU #DataWarehouse #SQLServer #TPCH #SIGMOD #AIAgents #DataEngineering #Performance #PowerBI #DataAnalytics #Microsoft #RADACAD
youtu.be/t7v-4nDWIJk
#MicrosoftFabric #FabricWarehouse #FabricInsider #GPU #DataWarehouse #SQLServer #TPCH #SIGMOD #AIAgents #DataEngineering #Performance #PowerBI #DataAnalytics #Microsoft #RADACAD
November 5, 2026 at 2:54 PM
Fabric Warehouse on GPU: 3x to 7x Faster? Maraki & Conor | Fabric Insider Ep. 27
youtu.be/t7v-4nDWIJk
#MicrosoftFabric #FabricWarehouse #FabricInsider #GPU #DataWarehouse #SQLServer #TPCH #SIGMOD #AIAgents #DataEngineering #Performance #PowerBI #DataAnalytics #Microsoft #RADACAD
youtu.be/t7v-4nDWIJk
#MicrosoftFabric #FabricWarehouse #FabricInsider #GPU #DataWarehouse #SQLServer #TPCH #SIGMOD #AIAgents #DataEngineering #Performance #PowerBI #DataAnalytics #Microsoft #RADACAD
https://buff.ly/3RnJqKb Questions about #sqlserver on Linux? Check out the course on LinkedIn, "Learning SQL Server Development on #Linux" and see if SQL Server on Linux is the correct solution for your data platform needs.
November 9, 2026 at 12:46 AM
https://buff.ly/3RnJqKb Questions about #sqlserver on Linux? Check out the course on LinkedIn, "Learning SQL Server Development on #Linux" and see if SQL Server on Linux is the correct solution for your data platform needs.
📦 tencentcloud/sqlserver 3.0.1693
TencentCloudApi php sdk sqlserver
🔗 https://github.com/tencentcloud-sdk-php/sqlserver
TencentCloudApi php sdk sqlserver
🔗 https://github.com/tencentcloud-sdk-php/sqlserver
November 1, 2026 at 8:59 PM
📦 tencentcloud/sqlserver 3.0.1693
TencentCloudApi php sdk sqlserver
🔗 https://github.com/tencentcloud-sdk-php/sqlserver
TencentCloudApi php sdk sqlserver
🔗 https://github.com/tencentcloud-sdk-php/sqlserver
Jerry Nixon's Favorite Undocumented Feature in SQL MCP Server
buff.ly/V898RSn
#sqlserver #database #azuresql #mcp #ai #cloud #azure #docker #containers
buff.ly/V898RSn
#sqlserver #database #azuresql #mcp #ai #cloud #azure #docker #containers
My Favorite Undocumented Feature in SQL MCP Server - Azure SQL Dev Corner
Deploy SQL MCP Server without a configuration file using DAB_CONNSTRING. Get started quickly with Docker, Azure Container Apps, ACI, or AKS.
buff.ly
November 4, 2026 at 3:01 PM
Jerry Nixon's Favorite Undocumented Feature in SQL MCP Server
buff.ly/V898RSn
#sqlserver #database #azuresql #mcp #ai #cloud #azure #docker #containers
buff.ly/V898RSn
#sqlserver #database #azuresql #mcp #ai #cloud #azure #docker #containers
I am currently looking for a new project. If you have a project that needs my skill set, or know someone who does, please reach out. I'd love to connect!
#SQLFamily #SQLServer #SQL #Data #AzureSQLServer #Azure #MicrosoftFabric #Fabric #Analytics #PerformanceTuning #AI #MVP #MicrosoftMVP #DataPlaform
#SQLFamily #SQLServer #SQL #Data #AzureSQLServer #Azure #MicrosoftFabric #Fabric #Analytics #PerformanceTuning #AI #MVP #MicrosoftMVP #DataPlaform
November 2, 2026 at 8:01 AM
I am currently looking for a new project. If you have a project that needs my skill set, or know someone who does, please reach out. I'd love to connect!
#SQLFamily #SQLServer #SQL #Data #AzureSQLServer #Azure #MicrosoftFabric #Fabric #Analytics #PerformanceTuning #AI #MVP #MicrosoftMVP #DataPlaform
#SQLFamily #SQLServer #SQL #Data #AzureSQLServer #Azure #MicrosoftFabric #Fabric #Analytics #PerformanceTuning #AI #MVP #MicrosoftMVP #DataPlaform
Blog post from the past:
In which I cover ANSI_NULLS and QUOTED_IDENTIFIER, two potentially dangerous SET options that stored procedures inherit from your session when created.
vladdba.com/2025/03/03/d...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba
In which I cover ANSI_NULLS and QUOTED_IDENTIFIER, two potentially dangerous SET options that stored procedures inherit from your session when created.
vladdba.com/2025/03/03/d...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba
Dangerous SET options stored procedure inherit from your session
ANSI_NULLS and QUOTED_IDENTIFIER, two potentially dangerous SET options that stored procedures inherit from your session when created
vladdba.com
November 4, 2026 at 7:05 PM
Blog post from the past:
In which I cover ANSI_NULLS and QUOTED_IDENTIFIER, two potentially dangerous SET options that stored procedures inherit from your session when created.
vladdba.com/2025/03/03/d...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba
In which I cover ANSI_NULLS and QUOTED_IDENTIFIER, two potentially dangerous SET options that stored procedures inherit from your session when created.
vladdba.com/2025/03/03/d...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba
One hour to go until today's Vancouver #PowerBI and Modern #Excel meet-up! Many will argue Excel is not a database. Well, Richard Nero will show how in a few clicks you can turn Excel workbooks into cloud based #SQLServer databases that fuel #AIAgents.
🕘Sign up here: www.meetup.com/vancouver-po...
🕘Sign up here: www.meetup.com/vancouver-po...
Excel as A Database and AI Agent Fuel | Richard Nero, Thu, Nov 5, 2026, 9:00 AM | Meetup
**SESSION TRACK:** Excel **SESSION OUTLINE:** Many will argue Excel is not a database. Well, Microsoft MVP Richard Nero will show how in a few clicks you can turn Excel wo
www.meetup.com
November 5, 2026 at 3:04 PM
One hour to go until today's Vancouver #PowerBI and Modern #Excel meet-up! Many will argue Excel is not a database. Well, Richard Nero will show how in a few clicks you can turn Excel workbooks into cloud based #SQLServer databases that fuel #AIAgents.
🕘Sign up here: www.meetup.com/vancouver-po...
🕘Sign up here: www.meetup.com/vancouver-po...
Cloud SQL SQL Server update on November 4, 2026 https://docs.cloud.google.com/sql/docs/sqlserver/release-notes#November_04_2026 #googlecloud Cloud SQL for SQL Server now supports read pool autoscaling ( GA ), which helps you more easily manage your application's workload
November 4, 2026 at 11:20 PM
Cloud SQL SQL Server update on November 4, 2026 https://docs.cloud.google.com/sql/docs/sqlserver/release-notes#November_04_2026 #googlecloud Cloud SQL for SQL Server now supports read pool autoscaling ( GA ), which helps you more easily manage your application's workload
◆TRUNCATE TABLEは、ロールバックできる。
SQLserverなどの一部のRDBMSでは、(トランザクション内なら)TRUNCATE TABLEはロールバックできるんですね。
知りませんでした。
blog.k-bushi.com/post/tech/da...
SQLserverなどの一部のRDBMSでは、(トランザクション内なら)TRUNCATE TABLEはロールバックできるんですね。
知りませんでした。
blog.k-bushi.com/post/tech/da...
各RDBMSでTRUNCATEはROLLBACKできるのかを確認する
blog.k-bushi.com
November 5, 2026 at 1:50 PM
◆TRUNCATE TABLEは、ロールバックできる。
SQLserverなどの一部のRDBMSでは、(トランザクション内なら)TRUNCATE TABLEはロールバックできるんですね。
知りませんでした。
blog.k-bushi.com/post/tech/da...
SQLserverなどの一部のRDBMSでは、(トランザクション内なら)TRUNCATE TABLEはロールバックできるんですね。
知りませんでした。
blog.k-bushi.com/post/tech/da...
https://buff.ly/3RnJqKb Questions about #sqlserver on Linux? Check out the course on LinkedIn, "Learning SQL Server Development on #Linux" and see if SQL Server on Linux is the correct solution for your data platform needs.
November 5, 2026 at 6:46 AM
https://buff.ly/3RnJqKb Questions about #sqlserver on Linux? Check out the course on LinkedIn, "Learning SQL Server Development on #Linux" and see if SQL Server on Linux is the correct solution for your data platform needs.
https://buff.ly/496Dahn Server #emergencies always seem to happen at 3 a.m. Getting assistance at 3 can be tricky unless you have DCAC's Emergency Response package. Our ER package provides methods to contact the DCAC team anytime to get help with emergencies. #sqlserver
November 4, 2026 at 8:46 PM
https://buff.ly/496Dahn Server #emergencies always seem to happen at 3 a.m. Getting assistance at 3 can be tricky unless you have DCAC's Emergency Response package. Our ER package provides methods to contact the DCAC team anytime to get help with emergencies. #sqlserver
Cheap check before a risky script: put
SET NOEXEC ON;
GO
at the top and hit F5. SQL Server compiles every batch but executes nothing. Typos and wrong column names show up; no data changes.
It stays on for the session: run SET NOEXEC OFF; before the real run.
#SQLServer #DBA
SET NOEXEC ON;
GO
at the top and hit F5. SQL Server compiles every batch but executes nothing. Typos and wrong column names show up; no data changes.
It stays on for the session: run SET NOEXEC OFF; before the real run.
#SQLServer #DBA
November 5, 2026 at 6:22 AM
Cheap check before a risky script: put
SET NOEXEC ON;
GO
at the top and hit F5. SQL Server compiles every batch but executes nothing. Typos and wrong column names show up; no data changes.
It stays on for the session: run SET NOEXEC OFF; before the real run.
#SQLServer #DBA
SET NOEXEC ON;
GO
at the top and hit F5. SQL Server compiles every batch but executes nothing. Typos and wrong column names show up; no data changes.
It stays on for the session: run SET NOEXEC OFF; before the real run.
#SQLServer #DBA
Selecting a query in SSMS before you press F5 is muscle memory. And when you miss a line, the wrong thing runs.
In RenSQL: put the cursor anywhere in the statement, press Ctrl+Shift+E. It finds the statement and runs just that one.
#SSMS #SQLServer
In RenSQL: put the cursor anywhere in the statement, press Ctrl+Shift+E. It finds the statement and runs just that one.
#SSMS #SQLServer
November 4, 2026 at 6:57 AM
Selecting a query in SSMS before you press F5 is muscle memory. And when you miss a line, the wrong thing runs.
In RenSQL: put the cursor anywhere in the statement, press Ctrl+Shift+E. It finds the statement and runs just that one.
#SSMS #SQLServer
In RenSQL: put the cursor anywhere in the statement, press Ctrl+Shift+E. It finds the statement and runs just that one.
#SSMS #SQLServer
https://buff.ly/498fRnA #database-driven applications using #SQLserver need to #scale to succeed. In this class, you'll learn the techniques to scale your SQL applications to grow with your user base. #rdbms #CloudComputing #Azure
November 3, 2026 at 2:46 PM
https://buff.ly/498fRnA #database-driven applications using #SQLserver need to #scale to succeed. In this class, you'll learn the techniques to scale your SQL applications to grow with your user base. #rdbms #CloudComputing #Azure
Part 2 of my series on building a Windows lab on a Linux host is up.
leemarkum.com/archive/2026...
#sqlserver
leemarkum.com/archive/2026...
#sqlserver
Building a SQL Server 2025 Lab on Linux Part 2
Building an Active Directory domain controller, cloning Windows Server virtual machines, and configuring domain authentication for a SQL Server 2025 lab on Linux Mint.
leemarkum.com
November 2, 2026 at 3:50 AM
Part 2 of my series on building a Windows lab on a Linux host is up.
leemarkum.com/archive/2026...
#sqlserver
leemarkum.com/archive/2026...
#sqlserver
Amazon RDS now supports the latest Cumulative Update and GDR updates for Microsoft SQL Server
https://aws.amazon.com/rds/sqlserver/ now supports the latest Cumulative Updates (CU) and General Distribution Release (GDR) updates for Microsoft SQL Server....
#AWS #AwsGovcloudUs #AmazonRdsForSqlServer
https://aws.amazon.com/rds/sqlserver/ now supports the latest Cumulative Updates (CU) and General Distribution Release (GDR) updates for Microsoft SQL Server....
#AWS #AwsGovcloudUs #AmazonRdsForSqlServer
Amazon RDS now supports the latest Cumulative Update and GDR updates for Microsoft SQL Server
https://aws.amazon.com/rds/sqlserver/ now supports the latest Cumulative Updates (CU) and General Distribution Release (GDR) updates for Microsoft SQL Server. This release includes support for Microsoft SQL Server 2017 CU31+GDR https://support.microsoft.com/en-us/help/5128496 (RDS version 14.00.3560.2.v1), SQL Server 2019 CU32+GDR https://support.microsoft.com/en-us/help/5128494 (RDS version 15.00.4500.2.v1), SQL Server 2022 CU27+GDR https://support.microsoft.com/en-us/help/5126934 (RDS version 16.00.4305.5.v1) and SQL Server 2025 CU10 https://support.microsoft.com/en-us/help/5125471 (RDS version 17.00.5035.5.v1).
For additional information on the improvements and fixes included in these updates, see Microsoft documentation for KB5128496, KB5128494, KB5126934 and KB5125471. We recommend that you upgrade your Amazon RDS for SQL Server instances to apply these updates using Amazon RDS Management Console, or by using the AWS SDK or CLI. You can learn more about upgrading your database instance in the https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.SQLServer.html.
aws.amazon.com
November 3, 2026 at 11:05 PM
Amazon RDS now supports the latest Cumulative Update and GDR updates for Microsoft SQL Server
https://aws.amazon.com/rds/sqlserver/ now supports the latest Cumulative Updates (CU) and General Distribution Release (GDR) updates for Microsoft SQL Server....
#AWS #AwsGovcloudUs #AmazonRdsForSqlServer
https://aws.amazon.com/rds/sqlserver/ now supports the latest Cumulative Updates (CU) and General Distribution Release (GDR) updates for Microsoft SQL Server....
#AWS #AwsGovcloudUs #AmazonRdsForSqlServer
https://buff.ly/48gHxFY Learn how to build more #secure #applications using the advanced #security features in #SQLServer, including Row Level Security, Always Encrypted, and more.
November 1, 2026 at 5:51 PM
https://buff.ly/48gHxFY Learn how to build more #secure #applications using the advanced #security features in #SQLServer, including Row Level Security, Always Encrypted, and more.