PASS Summit 2019 – spending the time
The session line up for PASS Summit 2019 was announced today...there are so many good sessions to go to..managing time and what we do with our limited time there...
2019-08-08
25 reads
Mala Mahadevan
Querying Temporal Tables
Temporal tables a.k.a Table Versioning was introduced in SQL Server 2016 and is an easy, convenient way to track changes to data. A good introduction to temporal tables can be found here. One of the key advantages of versioning tables is easy of querying – or getting a ‘single pane of glass’ look of how […]
2019-07-29
14,968 reads
Pathways to Progress
One of the most significant and hardest challenges we face as data professionals (or generally anyone in IT) is how to keep up with learning. Most of us are...
2019-06-05 (first published: 2019-05-17)
220 reads
PASS turns 20
Its really hard to believe that its been 20 years since the start of the PASS organization – the volunteer run...
2019-03-19
836 reads
WIT Panel for Women’s History Month
I cannot write this without stating some history. I have been part of PASS community since 1999. That is 21...
2019-03-11
216 reads
T-SQL Tuesday 109: To influence and to be influenced
The last T-SQL Tuesday of this year is hosted by Jason Brimhall – one of my long-time friends in the SQL...
2018-12-12
124 reads
Epic Life Quest – looking back
This will be my last post for the year. In this am going to look back on goals I set...
2018-12-03
731 reads
T-SQL Tuesday 108 – Learning R
I am the proud host of TSQL Tuesday for the month of November 2018.
My call to post entries is here ....
2018-11-28 (first published: 2018-11-18)
2,231 reads
Counting blessings – from Summit V2.0 and beyond
I have been a regular attendee at PASS Summit for 15 years now. This year (2018) marked my 15th year...
2018-11-22
196 reads
T-SQL Tuesday 108 – A poetic summary
This is November and T-SQL Tuesday time,
I hope you are ready to read the summary – I am the host and...
2018-11-19
175 reads
Blogs
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Monday Monitor Tips: SQL Auditing Preview
By Steve Jones
One of the features we advocates have been advocating for is a better way...
SQL Server 2025 CU1 Fixes the Docker Desktop AVX Issue on macOS
Microsoft fixed the AVX instruction issue in SQL Server 2025 CU1. The container now...
Forums
25 Years of SQL Server Central
Comments posted to this topic are about the item 25 Years of SQL Server...
The Decoded Value
Comments posted to this topic are about the item The Decoded Value
Deploying SQL Server Developer Edition in Kubernetes: A Cost-Effective Alternative to RDS
Comments posted to this topic are about the item Deploying SQL Server Developer Edition...
Question of the Day
The Decoded Value
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers