NVARCHAR(n) Vrs NVARCHAR(max)
These datatypes particularly NVARCHAR(n), have been with us for some time now but having seen some of the confusion around...
2012-05-28
7,947 reads
On my way to DevTeach in Vancouver
Just stepping out the door on on my way to the DevTeach / SQL Teach conference in Vancouver, BC, Canada. The...
2012-05-28
972 reads
SQL Server – DDL vs. DML Triggers
Although, DML and DDL triggers are used for different purposes, there are some similarities and differences between these.
Similarities between DDL...
2012-05-28
1,641 reads
Rolling out Windows 8 Client: First Impressions
A virus found it’s way on to my system through a trojan horse, past all the security & anti-virus software. I...
2012-05-28
1,040 reads
Unsubscribing
One of the things I’ve been doing lately is pruning (again) the number of newsletter type emails I get. Some...
2012-05-28
834 reads
Denali – Day 28: CDC for ORACLE
Denali – Day 28: CDC for ORACLE Sql server has provided a great features for changes monitoring as Change data Capture...
2012-05-28
1,361 reads
The Importance of Regular Blogging
Between my old website, which I started back in 2007 (which has since disappeared) and my blog, which I switched...
2012-05-28
1,038 reads
Denali – Day 27: System Center Advisor (aka ‘Atlanta’)
Denali – Day 27: System Center Advisor (aka ‘Atlanta’) As Microsoft is working more on Cloud base system, on that basis...
2012-05-27
1,010 reads
New built-in functions in SQL Server 2012
Introduction:
Microsoft SQL Server 2012 Release Candidate 0 introduces 14 new built-in functions. These functions will make the migration path for...
2012-05-26
25,551 reads
Denali – Day 26: Tool: Power View- Reporting Power View (Aka Crescent)
Denali – Day 26: Tool: Power View -Reporting Power View (Aka Crescent) If you are good with: Xls Pivot table Power...
2012-05-26
1,078 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
Alamat BCA KCU PURWOKERTO Tlp:0817825533
WA CS 62817825533 Alamat Jl. Jend. Sudirman No.391 A, Brubahan, Purwanegara, Kec. Purwokerto Tim.,...
Alamat BCA KCU SOLO BARU Tlp:08217555651
WA CS 628217555651 Alamat Kawasan Terpadu The Park, Jl. Ir. Soekarno, Solo Baru, Madegondo,...
Alamat Kantor BCA KCU CILACAP Tlp:08218154374
WA CS 628218154374 Alamat Jl. Jend. Ahmad Yani No.118, Sidakaya Dua, Sidakaya, Kec. Cilacap...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers