SELECT TRY_CONVERT(date, 'a')
-- returns NULL
SELECT TRY_CONVERT(date, '')
- returns 1900-01-01
SELECT TRY_CONVERT(date, ' ')
- returns 1900-01-01
What's so special about an empty string or a whitespace?
#SQLServer
I just started trying out SSMS' dark theme, and I must admit I'm looking forward to it getting darker 🕶️
Lars Martin Bredal retweeted
It's not too late to register for @SQLSatOslo with @BuckWoodyMSFT & industry experts for a free, full day of training.
📅 August 29
Register today: sqlsaturday.com/971
#sqlsatoslo #sqlfamily #sqlsaturday
Lars Martin Bredal retweeted
Check out the first ever New Stars of Data event this Friday.
This is an event to help find and promote new speakers in the Microsoft Data Platform arena.
Schedule: newstarsofdata.com/schedule/
Registration: meetup.com/New-Stars-Of-Data…
Lars Martin Bredal retweeted
Denne notisen fra @nrknyheter er det eneste jeg har sett i store norske medier i dag om stortingsbehandling av ny lov om Etteretningstjenesten, som i dag ble vedtatt. Dette medfører "masseovervåkning av norske borgere" (sitat @Datatilsynet). Hvor er resten av medie-Norge?
Ganske ille at de store mediene ikke engang har nevnt at stortingsbehandling av ny lov om Etteretningstjenesten altså skjer i dag.
Er ikke dette nyhetsverdig, @nrknyheter @Aftenposten @vgnett @dagbladet @Nettavisen ?
Mye tung kompetanse som protesterer:
medium.com/@ti_opprop/opprop…
Working in an Excel spreadsheet and hit Enter a couple times too much - all of a sudden my glorious table is magically filled thanks to the works of Excel Flash Fill. #suddenfeature #TIL
(gif from myonlinetraininghub.com/exce…)
Lars Martin Bredal retweeted
Tonight, January 28th: Azure Data Factory CI/CD with @troyel, and SSIS in Azure Data Factory with @antonioabalos and Anna Belaia. Register and join us for a great evening! :) meetup.com/Microsoft-Data-Pl… #MDPUGOslo #MDPUGNorway
Last session of the year at @MDPUGNorway presented by Vasko Bashoski - Optimizing Databases for Power BI. And thank you for learning us that the cost threshold for parallelism may actually be optimized when lower than the default value :)
Petar Trbos starting our last @MDPUGNorway meeting of the year, diving so deep in execution plan caches we might need scuba equipment 🔮 – at Oslo, Norway
Lars Martin Bredal retweeted
On Thursday, December 12th, we will be hosting the final meetup of 2019. Join us in Microsoft Norway's offices for networking, food, and two great sessions! meetup.com/Microsoft-Data-Pl… #MDPUGNorway #MDPUGOslo
Inspired by @sqldbawithbeard speaking highly of Azure Data Studio at PASS Summit, I chose to use a Notebook instead of a PowerPoint-presentation for a client demo today - and it worked out rather well.
The presentation is instantly more interactive, and it looks really sleek!
Lars Martin Bredal retweeted
Big update for PStSQLtTestGenerator. Lots of fixes, speed improvements and better tests. #tsqlt #ssdt #sqlserver
powershellgallery.com/packag…
I'm still looking for new ideas for basic tSQLt tests that can be generalized and therefore generated.
github.com/sanderstad/PStSQL…


















