I would do what I am doing now where most of my time is spent in Snowflake or SAP Hana. I do some work in legacy SQL Server systems, but...

Potential for ransomware attacks can be reduced by eliminating the ability of employees to browse their personal emails on Gmail, hotmail, etc. That ensures that all email goes through your...

The reason those letters were in those locations is due to letter frequency in English, putting the most frequently used letters on the left in descending order. Current frequency lists...

I suspect that SQL Server evaluates all of the terms of the comparison while Sybase has success on the first term and stops. Try reversing the order of the terms...

With registered servers, you can set the color for that server on the second tab of the connection dialog by checking the "Custom Color" box. I got that from this...

Step one for me would be to have the disgruntled employee's laptop taken away from him(assuming it's a company owned machine) so you don't have to worry about the data...

Try the string insert command

It is possible we're losing value, on average. We are starting to age out of this position and more junior people are taking it on. Plus, lots of younger...

Ooh, I so feel this.

One I see all the time, and I'm sure you do too, is when traveling internationally, depending on your flights, blah, blah, blah, you end...

For a phone app, all the work should be on the server, with no queries, etc being sent by the phone. Similar to how a good website delivers the page,...

You could use TRY_CONVERT(int, field) to ensure that you have an integer to work with in your query. If it fails to convert you'll get a null rather than...

The fun thing with cloud data is that if you don't get it locked down before allowing users in, they get mad when you stop letting them login from their...

Yeah, this is a supremely bad design for access.

Take a look at logon triggers and reject logons that do not come from the application server host name. I think you...

I would say no, the dev doesn't get to test in production. She can be unhappy. She's lucky she has data that is only a day old. Imagine working where...

I don't have any issues with allowing traces to be run in the DEV environment. If I had to wait for a DBA to do that for me, it would...