Pivoting Data Without TSQL 2020-02-25 Posted in: Development Machine Learning Services R SQL Server T-SQL Another way to PIVOT data in SQL Server...with a catch. [...Read More]
OPENROWSET and Quoted Data 2020-01-19 Posted in: Development SQL Server SSMS T-SQL How to remove those pesky double quotes when using OPENROWSET. [...Read More]
Schema-on-Read for SQL Server? 2019-12-22 Posted in: Big Data Development JSON NoSQL T-SQL Now that SQL Server supports JSON, schema-on-read should be a thing. Right? [...Read More]
The Bridge From NoSQL to SQL Server 2019-12-16 Posted in: Big Data Development JSON SQL Server T-SQL Thoughts on JSON functions and some suggestions for the future. [...Read More]
Documenting SSIS Packages 2019-09-25 Posted in: Database Administration Development SQL Server SSIS SSMS T-SQL Visual Studio SSIS packages are pretty easy to document if your deployments are old school. [...Read More]
Instant File Initialization 2019-09-06 Posted in: Database Administration T-SQL An overlooked DMV column that tells you if IFI is enabled or not. [...Read More]
Rounding to 15 Minute Intervals 2019-08-17 Posted in: Development Power BI PowerShell T-SQL When a simple task isn't so simple, sometimes you have to get weird. [...Read More]
Nonprintable ASCII Characters And Your Data 2019-07-31 Posted in: Development SSMS T-SQL Nonprintable characters in your data? Egads! [...Read More]
Splitting Strings With OPENJSON 2019-05-06 1 Comments Posted in: Development JSON SQL Server 2016 SQL Server 2017 T-SQL Another option for splitting strings in TSQL. This one addresses a shortcoming of STRING_SPLIT. [...Read More]
Parsing JSON Data In SQL Server 2019-05-05 Posted in: Big Data Development JSON SQL Server 2016 SQL Server 2017 T-SQL Get started with a few examples using the OPENJSON and JSON_VALUE functions. [...Read More]