I have a column in my database called 'Atozlisting', it is filled with only i character in each row of data. the character maybe an alpha character or a Numeral. i.e
a or g or f or 5 or 3 or j... etc
I'm trying to write two SQL statements. The first one will return only records that have an alpha characters as their value and the second one will return records that have a numerals as their value
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
SQL Server Integration Services can read XML files, that’s known by every BI developer. (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.)
But how far can you go? When does the XML Source component become …