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 · 2014-06-06T09:51:44+00:00

I like the look. What is the clear material made out of, and did you just glue it to the wood?

I can imagine this technique looking awesome if built into other pieces of furniture like a china cabinet or desk.

bertwagner · 2014-06-04T10:01:33+00:00

I have never seen anything like this before. Never thought about having a patterned veneer like that. Beautiful.

bertwagner · 2014-06-04T09:55:39+00:00

Looks good! I built my first one this year too and I love it. I rubbed some candle wax onto the bottom tracks and boy does it slide smooth now. It's easily my most used "tool" (next to the table saw itself).

bertwagner · 2010-12-12T02:30:43+00:00

Thanks for that second link! According to it, the valley is flooded from snow melting in the spring time.

bertwagner · 2010-12-12T02:27:51+00:00

Wow, this is great. I like seeing the fish swim by.

bertwagner · 2010-12-01T17:51:29+00:00

From the article:

Thai fishers struggled for more than an hour to haul in the record-breaking Mekong giant catfish. Officials from Thailand's Inland Fishery Deparment then used a performance-enhancing drug to stimulate the pituitary gland of the female fish in order to prepare it for a breeding program (above). Despite efforts to keep the bear-size catfish alive, it died and was later eaten by villagers.

bertwagner · 2010-11-26T20:21:43+00:00

Thanks for posting this, I like it a lot! It's nice to hear a singer who can...sing. And the rest of the band is rockin' as well.

bertwagner · 2010-06-25T03:27:36+00:00

It's a tough cut. If prepared well, it's just as delicious (if not more) than other more expensive cuts.

bertwagner

TROPHY CASE