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,688 reads
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)
216 reads
Its really hard to believe that its been 20 years since the start of the PASS organization – the volunteer run...
2019-03-19
833 reads
I cannot write this without stating some history. I have been part of PASS community since 1999. That is 21...
2019-03-11
211 reads
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
120 reads
This will be my last post for the year. In this am going to look back on goals I set...
2018-12-03
726 reads
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,225 reads
I have been a regular attendee at PASS Summit for 15 years now. This year (2018) marked my 15th year...
2018-11-22
192 reads
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
171 reads
It is day 2 of the summit already, am at the bloggers table again, waiting for the rest of the...
2018-11-08
153 reads
Welcome back, my fellow sleuths, to my mystery-inspired blog series! I’m having a ton...
By Steve Jones
This was one of the original values: The facing page has this text: No...
By Chris Yates
For decades, enterprises have thought about data like plumbers think about water: you build...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item I Love Editorials
Hi everyone I have a 1000 plus line query and I am getting an...
What happens when I run this code:
DECLARE @s VARCHAR(1000) = 'apple, pear, peach' SELECT * FROM STRING_SPLIT(@s, ', ')See possible answers