The certification validates basic knowledge of cloud services and how those services are provided with Azure. Fundamental knowledge of cloud concepts, along with Azure services, workloads, security, privacy, pricing, and support.
Key Concepts covered by certification:
Core Azure services
Core solutions and management tools on Azure
General security and network security features
Identity, governance, privacy, and compliance features
Azure cost management and Service Level Agreements
I got my first certification. I’ve been in IT for more than a decade and have always been fearful to attempt getting certifications. I had a fear of failure. I realize now there is no shame in failing a certification test, it just means you need to keep studying. Luckily, I passed! Define your goals and do the work to achieve them.
I wanted to compare WiFi coverage of two different wireless access points and their various configurations in my house, and also check for dead spots. One quick and cheap way to do this that I have come across is using a free product called Ekahau HeatMapper.
Ekahau HeatMapper allows you to walk around your home or office and capture information about WiFi signals in various spots, and then the software aggregates this information into a banded topographical map.
Checks all databases on a server for any users who do not have a correlated login, based on SID. Uses the undocumented command of sp_msforeachdb. You could put in a loop if you want to avoid this command.
This script has three actions:
1) Put Current Job Information Into Temp Table
2) DISABLE All SQL Server Agent Jobs
3) ENABLE SQL Server Agent Jobs Which Were Enabled Prior to Disabling
Note: If you need to disconnect from the server after step 1 then step 3 will not be able to read from the temp table. Instead, you would have to feed a list of job IDs to the query. I have created a place for this just in case this is what you have to do.
Put Current Job Information Into Temp Table: 47 row(s) affected
DISABLE All SQL Server Agent Jobs: 33 row(s) affected
ENABLE SQL Server Agent Jobs Which Were Enabled Prior to Disabling: 33 row(s) affected
-- USE MSDB;
--Put Current Job Information Into Temp Table
INTO#SYSJOBS/* DROP TABLE #SYSJOBS */
PRINT'Put Current Job Information Into Temp Table: '+CONVERT(varchar,@@rowcount)+' row(s) affected'
--DISABLE All SQL Server Agent Jobs
PRINT'DISABLE All SQL Server Agent Jobs: '+CONVERT(varchar,@@rowcount)+' row(s) affected'
--ENABLE SQL Server Agent Jobs Which Were Enabled Prior to Disabling
EXISTS(SELECT1FROM#SYSJOBSBWHEREB.enabled=1ANDA.job_id=B.job_id)/*READ FROM TEMP TABLE*/
ORCONVERT(varchar(MAX),job_id)IN('')/*MANUALLY LIST JOB IDS*/
PRINT'ENABLE SQL Server Agent Jobs Which Were Enabled Prior to Disabling: '+CONVERT(varchar,@@rowcount)+' row(s) affected'