Hi Steve, no reports under home and...

Good Stuff.  There were a couple of the queries that didn't run against my Synapse instance.  "can't convert to int".  I had to cast some of the columns to bigints.

The...

Scott,

Your function works but outputs in rows.

I want like this in fact:

declare @tag varchar(100)

set @tag = 'one-two-three-four'

select 
upper(convert(varchar(10),ltrim(PARSENAME(REPLACE(@tag, '-', '.'), 4)))) as [Post0],
upper(convert(varchar(10),ltrim(PARSENAME(REPLACE(@tag, '-', '.'), 3))))...

DECLARE @StringToFind varchar(256) /* String to find */
 DECLARE @ObjectType char(2) /* Only look for objects of this type */
 DECLARE @NumberToExtract int /* Number of characters...

One thing, Rod, to think about is complaints or concerns about tech not being ready could be true. They could also be fear that if we stop using VS2013,...

I could probably cause WordPress to blow up with all of the poor practices I've had to fix.

Here is the issue of the day:

We have a large Synapse instance, it's...

Did the query you wrote produce the correct results? What was wrong with it?

I've been setting up bare metal SQL servers since SQL 2000, and I always set the max memory to the total memory - 4GB reserved for the operating system....

Great job on the article, really bad job on the 75% recommendation.

If there is 32 GB of RAM, then 75% is probably too high.  If there is 32TB of RAM,...

Hi!

I have successfully installed the always-on system from your current repository, and I want to thank you for that. However, while the primary database is inaccessible, I want to...

Why PowerShell?  Since anything can execute the xp_readerrorlog from a remote box then why not much more simply have the management server periodically execute the xp from its local...

• This reply was modified 11 months ago by  Michael L John.

Happy Holidays!  Christmas Day for me is all the kids and grandkids hang out in the morning, and then go their separate ways leaving me in peace.  I told my...

Will recordings of these be available???

Have a numeric column HRS Numeric(5,2)

Need to add error if the value after decimal point second digit is not 0

Example - 50.10 is acceptible

50.77 is not acceptable (Second digit...

Is this an export or report created out of a mainframe?  This is strangely similar to a situation I had to work on a while back.

Reading this thread, the issues...