(Chris Webb) In a comment on my blog post about international date and number formats and changing data types with the “using locale” option in Power Query/Power BI, Jan Karel Pieterse asked if there was any way to get a list of the thousand and decimal separators used for number formatting by each
Community
Bulk insert and an identity column
(Kenneth Fisher) TL;DR; BULK INSERT doesn’t have an easy way to specify a column list so the columns in the insert file must match the columns in the table unless you use a format file or a staging table.
Using Track Causality to Understand Query Execution
(Erin Stellato) When deeply involved in troubleshooting an issue in SQL Server, sometimes you find yourself wanting to know the exact order in which queries ran.
IBM Spectrum Scale and IBM StoredIQ: Identifying and securing your business data to support regulatory requirements
(Sandeep R Patil, Sasikanth Eda, Atul V Gore and Nils Haustein) The appropriate storage for hosting business-critical data and the proper analytic software for deep inspection of that data is necessary, especially for data that is subject to regulatory compliance..
Less commonly used C# operators
(Damir Arh) There’s a large collection of operators available in C#.
Getting Image Data from Picture Files in .NET
(Hannes DuPreez) I love pictures, as some of my articles can attest to. I have just about done everything I could with images (drawing them, giving them special filter effects, manipulated them to become desktop wallpapers, and so on), or so I thought.
SQL SERVER – SETUP Error: The Syntax of Argument ‘/ACTION’ is Incorrect
(Pinal Dave) Recently, I was trying to uninstall SQL Server via command prompt and faced an interesting situation. In this blog, we would learn about the error “The syntax of argument “/ACTION” is incorrect” and how to fix it.
Why you should consider VS Code for your Kubernetes/Docker work
(Julien Oudot) Visual Studio Code (VS Code) is sometimes considered as a slimmer and minimalist version of Visual Studio. However, depending on the technology stack used, VS Code can really be the platform of choice to benefit from the best features.
Controlling JavaScript Program Flow
(Phil Ballard) Examines ways to recognize particular conditions and have your JavaScript program act in a prescribed way as a result.
MySQL: when will the password of my users expire ?
(Frederic Descamps) Has you may already know, in MySQL it is possible to set an expiration period for passwords.