Dates and Times in SQL Server: DATEDIFF() and DATEDIFF_BIG()
Last time we looked at adding or subtracting date parts using the DATEADD() T-SQL system function. This week we see...
2018-11-21
390 reads
Born SQL with Randolph West
Dates and Times in SQL Server: DATEADD()
We are now in the home stretch of the long-running series about dates and times in SQL Server and Azure...
2018-11-14
261 reads
PASS Summit Speaker Idol 2018
This scheduled post is coming to you from Seattle, where the PASS Summit 2018 has just kicked off. Because it...
2018-11-07
202 reads
String or binary data would be truncated: get the full picture in SQL Server 2017
SQL Server 2019 Preview (CTP 2.0) introduced a long-awaited improvement to an error message that’s been around in SQL Server...
2018-10-31
527 reads
Create a slipstream installer for SQL Server on Windows
Since the release of SQL Server 2008 Service Pack 1 in April 2009, it has been possible to install SQL...
2018-10-24
249 reads
Fix SQL Server with one click
Tempting headline, isn’t it? It might even seem like clickbait, but that’s not the intention. The SQL Server default configuration...
2018-10-17
306 reads
Changes to the SQL Server servicing model (Cumulative Updates)
On Monday of this week, Microsoft announced changes to the servicing model for SQL Server, starting with SQL Server 2017....
2018-10-10
329 reads
What is a DBA anyway?
Some time ago we started a new series here, called Database Fundamentals. The very first post in that series asked...
2018-10-03
302 reads
Azure means hybrid now
On Monday 24 September 2018, Microsoft announced a slew of stuff at their annual Ignite conference that is going to...
2018-09-26
373 reads
Public Service Announcement: check your backup notifications
The Azure cloud platform lost a data centre for a number of hours recently due to inclement weather. This affected...
2018-09-19
243 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Alamat BCA KCP Pondok Ungu Bekasi Telp:0821°8200°233
Telp/Wa 628218200233 Jl. Sultan Agung No.19-20 Kavling Blok A, RT.007/RW.007, Medan Satria, Kecamatan Medan...
Alamat BCA KCP Central Park Telp:0821°8200°203
Telp/Wa 628218200203 Ruko GSA Blok Beufort 08 CB CC CD, RT.9/RW.5, South Tanjung Duren,...
Alamat BCA KCP Ruko Swadaya Telp:0821°7555°651
Telp/Wa 628217555651 Jl. Swadaya Raya No. 39 Ruko Swadaya City Square Blok 1. 11-23,...
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers