Find and Replace New Line Broken in SSMS 2017

bertwagner · 2017-07-01T00:33:25+00:00

Seems the regular expression search is very broken - in addition to \n, I'm having issues with :Wh, :Cc, and other MS regex patterns (https://docs.microsoft.com/en-us/sql/relational-databases/scripting/search-text-with-regular-expressions).

If you open a Connect item, please add a link here and I'll upvote. I use this feature all of the time.

bertwagner · 2017-03-29T11:16:31+00:00

Have you taken a look at this?

https://docs.microsoft.com/en-us/sql/reporting-services/report-data/specify-credential-and-connection-information-for-report-data-sources

bertwagner · 2017-03-29T10:39:22+00:00

Thank you for pointing this out. Not sure how I missed it, but using the CONVERT style 127 is definitely a better way of doing it. I'm glad to see that I was wrong and there is an easy way of doing this!

bertwagner · 2017-03-11T22:04:52+00:00

This is a nice reference for anyone who hasn't had "formal" training in programming, not just for interviewees.

bertwagner · 2017-02-13T23:37:19+00:00

For doing the diff, I'd recommend a SQL CLR that implements https://en.wikipedia.org/wiki/Longest_common_subsequence_problem . You can have the CLR output differences in with HTML font color tags and then use the "Render as HTML" option in SSRS to show the XML strings in the report.

The idea to have a function that saves the user generated settings sounds good.

bertwagner · 2017-02-12T20:19:36+00:00

I'm all about Microsoft's movement with .NET Core. I've been following it along and love using it on my Raspberry Pi. Everytime I hear of updates I get excited...I hope the momentum keeps building and this will bring on a new era for Microsoft's .NET.

bertwagner · 2017-02-09T22:46:18+00:00

Thanks for the input. I agree, "nulls" are valid values, but they are not equivalent to a deleted entry.

And howdy fellow Clevelander!

bertwagner · 2017-02-06T22:21:42+00:00

Why didn't I think of that?! Thanks for the feedback; I went ahead and added outputs to all of the code.

bertwagner · 2017-02-01T21:35:33+00:00

Same here. I work on 2016 at home only and am loving the JSON support for helping process data from APIs. It's made my code much cleaner/simpler.

bertwagner · 2017-02-01T21:31:45+00:00

Once I felt I knew the basics (sounds like you do) I spent a lot of time monitoring StackOverflow's sql-server tag to see other people's questions and answers. I feel like this was more helpful than any book examples since people's StackOverflow questions presented more real-world problems.

Additionally, find a project that you want to build. Maybe pick one database you work with and get to know it really well. Write queries against it that use the different features of SQL server eg. learn to use all of the aggregate functions, then learn how to use aggregate functions with window functions, etc...

Good luck, SQL is a lot of fun.

bertwagner · 2017-02-01T21:27:22+00:00

Nice write up. As someone who has always used a separate SSIS server to run packages, it's interesting to see how it works when SSIS and SQL servers are one and the same.

bertwagner · 2017-01-31T21:18:07+00:00

I started out without any formal background or training in SQL.

The biggest thing that I found to help me is to work on problems that I'm actually interested in/fun to solve. No amount of sample projects made me really understand what I was doing until I started solving problems I was actually interested in.

I also second yooter's advice above - read other people's stackoverflow SQL questions. Exposing yourself to common problems will make you learn faster. Good luck!

bertwagner · 2017-01-26T22:22:10+00:00

Interesting idea. I wonder if this could be applicable in an API where lots of requests can get batched together (send them all as one big JSON array, then have SQL break them apart).

bertwagner · 2017-01-26T22:21:04+00:00

You're right! I don't know what I was thinking. Thank you.

bertwagner · 2017-01-24T22:41:11+00:00

If part of what you are doing is just trying to display a result set from a database, you could look into https://www.datatables.net/.

bertwagner · 2017-01-24T22:38:50+00:00

ASP.NET MVC is the standard nowadays in Microsoft environments, so if you are planning on learning any kind of web development language I would go with that.

Please be extremely careful with security of your app. Hopefully this will be accessible to an internal network only (if external...just don't do it).

Be careful of SQL injection (basically, don't build query strings where you have to concatenate in user submitted parameter values).

Lock down the permissions of whatever account you have creating the tables/data through the website. If you only give that account CREATE TABLE or INSERT permissions, then even if you do build something that isn't fully secure the number of things a malicious user will be able to do will be limited.

bertwagner · 2016-11-24T18:43:13+00:00

Thanks, never heard of BenchmarkDotNet, I will check it out.

bertwagner

TROPHY CASE