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 1 year, 1 month 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...

I have to admit, I'm totally amazed about the number of people that participate on the QoD and on Polls on linked in.

I'm also amazed at the number of...

Though its Azure MI Business critical , I see fragmentation, Any script to identify which IX's need to be rebuilt ,as Frag is over 50%.

I will add REBUILD WITH...

I am very curious why you decided to perform an in-place upgrade instead of starting with a fresh install and restore of the databases to a new server?  Especially with...