Parallel Data Warehouse (PDW) Tip: Usage of SYSDATETIME() vs GETDATE()
Usage of GETDATE() dates back to the earliest versions of SQL server and has become the primary blade in our...
2012-07-21
2,766 reads
New articles posted.
My article Plotting SQL Server Data for Data Visualization is up on MSSQLTips now and discusses using PyQt and Matplotlib...
2012-07-21
823 reads
The Mentoring Experiment is taking applications
If you would like a mentor, we’ are taking applications at The Mentoring Experiment. We ran this last year and...
2012-07-20
1,156 reads
Presentations That Exceed The Allotted Time
Back in February I did a presentation for MagicPASS that ran long, maybe 30 minutes over the time allotted. It...
2012-07-20
830 reads
SQL CREATE TABLE Statement
We have created a simple tutorial for SQL Create Table that may help some of you to prepare for Microsoft...
2012-07-20
677 reads
technorati blog directory 8HBVGY7K4K5E
We found another Blog directory that is willing to accept our RSS feed. And we have been asked to put...
2012-07-20
516 reads
Parallel Execution in SSIS with MaxConcurrentExecutables
MaxConcurrentExecutables, a package level property in SSIS determines the number of control flow items that can be executed in parallel....
2012-07-20
19,557 reads
Contained Databases – Server Setting Matters
In doing some additional testing on contained databases, I decided to create a new database on a new test VM.
CREATE...
2012-07-19
2,152 reads
SQL Saturday #150 and TechDay Baton Rouge–BI 1 track
The SQL Saturday/TechDay in Baton Rouge will be the forth annual this year. The Business Intelligence sessions occupy 2 tracks...
2012-07-19
895 reads
Send me your pictures
If you got some with me at SQL in the City last week I London, or anytime in the last...
2012-07-19
1,064 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