"Occasionally, it seems students can be discouraged from asking 'foolish questions'. But no question you ask is foolish. It's like telling somebody who is afraid of spiders to stop having...

Twenty-five years is a remarkable achievement, I can't believe it's gone so quickly 🙂

What you, Steve, Andy and the rest of the team built, upgraded and tweaked is an awesome...

For jobs like these, I have a proc that goes through sysjobhistory. If there are any failures it passes the messages along to my usual SQL Agent Job failure proc...

All these new improvements and additions and I still miss Query Analyzer

Worth noting that the same 128 char limitation also applies to the QUOTENAME function.

https://docs.microsoft.com/en-us/sql/t-sql/functions/quotename-transact-sql?view=sql-server-ver15

 

I tend to go through spats with my personal GMail where I'll have a couple hundred unread emails. I'll browse the subject lines, find nothing interesting, select all, mark as...

• This reply was modified 6 years, 11 months ago by philcart.

This one popped up in my email this morning. Not totally sold on the colour though.

https://www.asus.com/Laptops/ASUS-ZenBook-Edition-30-UX334FL/Features/

 

 

I've also had my HP Spectre x360 for couple of years now, and it's been rock solid. Have even left it in the middle of a paddock for a couple...

Nice article Steve

Would be interested in seeing how the new function stacks up against the "custom" split functions that every DBA seems to have a few versions of.

Tried doing this, but for some reason the "Create Unit Tests..." option is disabled.
Running Visual Studio Professional 2015 v 14.0.25431.01 Update 3
SQL Server Data Tools v 14.0.61021.0

My commute is about 45-50mins each way on public transport.

On the way in, it's generally email time, checking to see if I'm going to be walking into any disasters, sending...

Good start ... very useful for places where there is no budget for monitoring SQL. You could even bundle in a couple of example SQL scripts. Like backup taken within...

Gary Varga (9/1/2016)

---

philcart (9/1/2016)

---

Also, to add to previous posts, something that has tripped me up before when using UNC paths. Powershell cmdlets can attempt to resolving the UNC path to...

Also, to add to previous posts, something that has tripped me up before when using UNC paths. Powershell cmdlets can attempt to resolving the UNC path to registry location instead...

Interesting solution. Just proves the point that there are always many different ways to achieve the same result.

We solved this issue with a very basic C# console app which called...