Generate Script in SQL Server With 6 Simple Steps
“I am a new user of SQL Server so I have very limited knowledge of its features. I would like to know how to generate script with data of...
2018-08-07
22 reads
Generate Script in SQL Server With 6 Simple Steps
“I am a new user of SQL Server so I have very limited knowledge of its features. I would like...
2018-08-07
1,187 reads
Table Value Constructors in TSQL
Last week’s quiz was on Table Value Constructors in TSQL. Essentially, table value constructors let you create a dataset on the fly. These can occasionally be useful in writing...
2018-08-07
41 reads
Displaying Long Values in SSMS
Click here to watch this week’s video on YouTube.
I write a lot of dynamic SQL and frequently encounter variables that...
2018-08-07
381 reads
Displaying Long Values in SSMS
Watch this week's video on YouTube
I write a lot of dynamic SQL and frequently encounter variables that contain many characters:
DECLARE @LongValue NVARCHAR(MAX) = CAST('' AS NVARCHAR(MAX)) +
N'SELECT
...
2018-08-07
23 reads
Displaying Long Values in SSMS
Watch this week's video on YouTube
I write a lot of dynamic SQL and frequently encounter variables that contain many characters:
DECLARE @LongValue NVARCHAR(MAX) = CAST('' AS NVARCHAR(MAX)) +
N'SELECT
...
2018-08-07
9 reads
Azure SQL Data Warehouse and Backups
Just because the cloud movement is strong doesn’t mean the end of “DBA’s”, it does mean a change in skills...
2018-08-07
423 reads
Analyze Actual Execution Plan
One of the many new sets of functionality introduced in SQL Server Management Studio 17 is the new option “Analyze...
2018-08-22 (first published: 2018-08-06)
2,630 reads
SSL Provider error 31 when connecting to SQL in a docker container
I recently bought a Dell XPS 13 running Ubuntu 16.04 and ran into an issue when connecting SQL Operations Studio...
2018-08-06
713 reads
SQL Saturday Denver 2018
Come see my presentation on Machine Learning Server for SQL Server at SQL Saturday Denver
2018-08-06
16 reads
Blogs
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
From DBA or Data Engineer to AI Engineer: A Realistic Path
If you spend your days tuning queries, managing pipelines, or keeping a production database...
Forums
Two queries work until compared with EXCEPT statement
I've got multiple databases on 2 SQL 2019 CU32 servers , all using the...
STRING_AGG DISTINCT
Has anyone written a wrapper function (or similar) around STRING_AGG() to allow the retrieval...
In-place OS upgrade or migration to new OS?
Putting this here as we're currently on SQL Server 2019 installed on Windows Server...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers