DATE_BUCKET uses an origin to align reporting windows. Keep width, unit and origin explicit while checking timestamps around each boundary.
SQL SERVER – Could not connect to TCP error code 10061: No connection could be made because the target machine actively refused it
TCP error code 10061 says the target machine actively refused the connection. In my StreamInsight app, a Windows Firewall exception for the port fixed it.
SQL SERVER – Change Column DataTypes
A simple way to change column datatypes in SQL Server with ALTER TABLE ALTER COLUMN, shown on a sample table and checked with sp_help.
SQL SERVER – System Stored Procedure sys.sp_tables
Most people run SELECT * FROM sys.tables to list tables. If you do not need all those details, sys.sp_tables returns tables and views with schema names.
datetime2 Precision: Rounding Can Cross Midnight
datetime2 precision changes can round into the next second or date. Compare typed seven-digit values with millisecond and whole-second conversions.
Where a Self-Service Report Actually Gets Its Data
Trace self-service BI numbers through source data, transformations, refresh schedules, credentials, gateways, and the owner of each step.
SQL SERVER – 1500 Posts – A MileStone – Origin of Blog Name Revealed
For my 1500th blog post, I keep a promise and reveal the origin of blog name SQLAuthority.com, inspired by a ColdFusion site called Fusion Authority.