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.
📦 aura/sqlquery 7.0.0
Object-oriented query builders for MySQL, Postgres, SQLite, and SQLServer; can be used with any database connection library.
🔗 https://github.com/auraphp/Aura.SqlQuery
Object-oriented query builders for MySQL, Postgres, SQLite, and SQLServer; can be used with any database connection library.
🔗 https://github.com/auraphp/Aura.SqlQuery
November 10, 2026 at 9:59 AM
📦 aura/sqlquery 7.0.0
Object-oriented query builders for MySQL, Postgres, SQLite, and SQLServer; can be used with any database connection library.
🔗 https://github.com/auraphp/Aura.SqlQuery
Object-oriented query builders for MySQL, Postgres, SQLite, and SQLServer; can be used with any database connection library.
🔗 https://github.com/auraphp/Aura.SqlQuery
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
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
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.
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.
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
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 —
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 10, 2026 at 1:45 AM
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
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
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.
New blog post:
Are blogs still relevant?
I asked my analytics dashboard, but it declined to comment.
vladdba.com/2026/11/10/t...
#sqlserver #tsql2sday #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql
Are blogs still relevant?
I asked my analytics dashboard, but it declined to comment.
vladdba.com/2026/11/10/t...
#sqlserver #tsql2sday #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql
T-SQL Tuesday #204 - Yes, maybe, I don't know
This month’s T-SQL Tuesday invitation comes from Jeff Iannucci, and it’s titled “Are blogs still relevant?”.
vladdba.com
November 10, 2026 at 8:10 AM
New blog post:
Are blogs still relevant?
I asked my analytics dashboard, but it declined to comment.
vladdba.com/2026/11/10/t...
#sqlserver #tsql2sday #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql
Are blogs still relevant?
I asked my analytics dashboard, but it declined to comment.
vladdba.com/2026/11/10/t...
#sqlserver #tsql2sday #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql
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
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
📦 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
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...
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
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.
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
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
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